06-03-2014
loops
Just to pull the active DB's but i'm trying to practice using a loop rather than just pulling the entire database schema
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
Actually I have a file which consists data . for eg names.
Then I want my sql query to read this file and produce the output.
Currently I am using this
FOR EG : FILENAME is NAMES
for i in `cat NAMES`
{
sqlplus -s $CONNECTID << EOF
spool rooh
set heading off
select... (1 Reply)
Discussion started by: rooh
1 Replies
2. Shell Programming and Scripting
Hi
I have around 100 users in sun server and have default home directory in /usr/home/<username>
I want to clean their home directory time to time to make free space on root, as users generate many output files during usage of application.
My idea is, generate a file with following command... (4 Replies)
Discussion started by: ishir
4 Replies
3. Shell Programming and Scripting
Hi,
I have to write a KSH script to loop through the directory and transfer all the files through FTP. The source machine is the Network shared drive and the files in the directory needs to be FTPied to the UNIX server.
For eg. Directory (Datasource)
+ Directory1
... (6 Replies)
Discussion started by: mahalakshmi
6 Replies
4. Shell Programming and Scripting
I run into a issue when I try to do sorting of the following with ascending order, one round of for looping seems not working, anyone knows how to use shell or perl?
$array = (5,0,3,2,7,9,8) (2 Replies)
Discussion started by: ccp
2 Replies
5. Shell Programming and Scripting
Hello, where can I get usefull information on the use of looping with for , if and while with extensive examples.
Also use of variables in scripts (1 Reply)
Discussion started by: sam4now
1 Replies
6. Shell Programming and Scripting
vesselNames values:
xxx
yyy
zzz
vesselPlanned values:
xxx
zzz
zzz
zzz
OIFS=""
OIFS=$IFS
IFS="\n" (2 Replies)
Discussion started by: finalight
2 Replies
7. Shell Programming and Scripting
Hi everyone,
I am having trouble looping through entries in a file. The file several entries that are separated by topics e.g.
<Topic r:id="Top/World/Français">
</Topic>
<Topic r:id="Top/World/Français/Actualité">
</Topic>
<Topic r:id="Top/World/Français/Actualité/A_la_Une">
<link... (1 Reply)
Discussion started by: BlueberryPickle
1 Replies
8. Shell Programming and Scripting
Hi,
Now I have written a script which sorts the records in the file and splits them according to some condition.
Now, I need to modify the script so that it reads all the files one after the other and does the sorting & splitting.
Pls help me in reading all the files in a directory and... (8 Replies)
Discussion started by: Sunitha_edi82
8 Replies
9. Shell Programming and Scripting
Hi evryone
i need a help .
i have a file xcv.the content is :
accelerate
i want a script which will run 1000 times in loop and changing the value to
accelerate to
acceler
in 1st loop and in 2nd loop it will be again
accelerate and so on . (6 Replies)
Discussion started by: Aditya.Gurgaon
6 Replies
10. Shell Programming and Scripting
so when i use rm file -i vv bb i can delete the first file vv but i cant seem to delete the second file bb as i tried to use shift on it, but it seems that it delete the first one and stops it without looping it to the next file. what is wrong with my coding ?
#!/bin/bash
function... (3 Replies)
Discussion started by: cman123
3 Replies
LEARN ABOUT DEBIAN
rt-setup-database-4
rt-setup-database(8) Request Tracker Reference rt-setup-database(8)
NAME
rt-setup-database - Set-up the database for Request Tracker
SYNOPSIS
rt-setup-database --action ...
OPTIONS
action
Several actions can be combined using comma separated list.
init
Initialize the database. This is combination of multiple actions listed below. Create DB, schema, setup acl, insert core data and
initial data.
upgrade
Apply all needed schema/acl/content updates (will ask for version to upgrade from)
create
Create the database.
drop
Drop the database. This will ERASE ALL YOUR DATA.
schema
Initialize only the database schema
To use a local or supplementary datafile, specify it using the '--datadir' option below.
acl Initialize only the database ACLs
To use a local or supplementary datafile, specify it using the '--datadir' option below.
coredata
Insert data into RT's database. This data is required for normal functioning of any RT instance.
insert
Insert data into RT's database. By default, will use RT's installation data. To use a local or supplementary datafile, specify it
using the '--datafile' option below.
datafile
file path of the data you want to action on
e.g. "--datafile /path/to/datafile"
datadir
Used to specify a path to find the local database schema and acls to be installed.
e.g. "--datadir /path/to/"
dba dba's username
dba-password
dba's password
prompt-for-dba-password
Ask for the database administrator's password interactively
skip-create
for 'init': skip creating the database and the user account, so we don't need administrator privileges
root-password-file
for 'init' and 'insert': rather than using the default administrative password for RT's "root" user, use the password in this file.
perl v5.14.2 2013-05-22 rt-setup-database(8)