04-27-2006
A simple way would be to use case statments. Use your test#.sql
as arguments to your main script. Make sure any scripts that follow
are part of the case statement being called. This is for sh and bash
shells other shells may be slightly different.
"$var" in
value1)
commands;
;;
value2)
commands;
;;
esac
ex.
main.test.sql test2.sql
This would cause your main script to accept test2.sql as the value for
$1, or 1st argument to main.test.sql and the main script would start at
the 2nd case value.
case "$1" in
'test1.sql')
<dir path>/test1.sql
<dir path>/test2.sql #so on and so forth
<dir path>/test3.sql
;;
'test2.sql')
<dir path>/test2.sql
<dir path>/test3.sql
#continue this pattern untill all following test have been included
;;
esac
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
Could someone help me to get yesterday's date in MMDDYY format.
echo `date '+%m%d%y'`
is giving me today's date in the above format.
Thanks in advance for your help..
Suresh. (1 Reply)
Discussion started by: svannala1
1 Replies
2. Shell Programming and Scripting
I have a few xml files and I want to input say 5 parameters within each file. is it possible to do so with sed?
<parameter>A</parameter>
<parameter>B</parameter>
....
....
And so on.
These parameters are meant to go in just inside:
<?xml... (2 Replies)
Discussion started by: collern2
2 Replies
3. UNIX for Dummies Questions & Answers
i have a function defined in one ksh
i want to use the same functionality in another ksh
i am using
. ../<ksh name>
but it is not picking that functionality
what i have to do for the same (2 Replies)
Discussion started by: trichyselva
2 Replies
4. Shell Programming and Scripting
Hi please help in the below request
Input File 1:
a,1
b,2
c,3
d,4
e,5
f,6
Input File 2:
2
5
3
1
Output Required:
b 2
e 5
c 3 (3 Replies)
Discussion started by: ravin
3 Replies
5. Shell Programming and Scripting
Hi,
I am trying to emulate the '|' functionality through pipe function call. I am passing the o/p of exec in parent as input to the exec in child. The buf is readin the o/p but the exec in child is not working. Can somebody checkout the code and point where am i going wrong or missing something.... (3 Replies)
Discussion started by: amejoish
3 Replies
6. UNIX for Dummies Questions & Answers
I'm a Bash Newbie, hope you guys can help.
n.n
Ok, So I need to make a script that will get a list of the Users that are/have logged in (recently).
I've been wondering how to get it with either the last or the who command.
This Poses a problem, as with who, it ONLY shows the Users... (3 Replies)
Discussion started by: lsteamer
3 Replies
7. Shell Programming and Scripting
here is what i have...
i=1
while read line
do
if grep -i-q "create procedure"<<<$line
then
startline="$line"
endline="blahblah"
Get procedure name into a variable named procName
procName="procedure name is stored"
do some... (2 Replies)
Discussion started by: vivek d r
2 Replies
8. UNIX for Dummies Questions & Answers
Hi everyone, today i need that someone help to understand this particular line of command.
So you can explain to me step by step, it will be great.
---------- Post updated at 11:53 AM ---------- Previous update was at 11:51 AM ---------- (9 Replies)
Discussion started by: Newer
9 Replies
9. Shell Programming and Scripting
I have make an menu in which first option is to start and second is to stop the services
echo "Please enter the appropriate choice for doing the operations"
echo "
1) STOP Services
2) START Services
case $choice in
1)
... (4 Replies)
Discussion started by: punpun66
4 Replies
10. UNIX for Dummies Questions & Answers
Hi ,
I've written the following code to zip the big file
$dir_temp ="/home/etc/hst
zip -r $dir_temp/file_nm.zip $dir_temp/file_nm
The zip file has been created . When I try to UNZIP the file
with the following command
unzip file_nm.zip
The file got unzipped but created in the... (3 Replies)
Discussion started by: smile689
3 Replies
LEARN ABOUT DEBIAN
oarnodesetting
oarnodesetting(1) OAR commands oarnodesetting(1)
NAME
oarnodesetting - Change the state and properties of a node in OAR.
SYNOPSIS
oarnodesetting [-h hostname | [[-r resource_number][--sql "sql syntax"] | -a]]
DESCRIPTION
This command is used to Change the state and properties of a node in OAR.
OPTIONS
-a, --add
Add a new resource.
-s, --state STATE
Set the new state of the node. The available states are: Alive, Absent and Dead.
-m, --maintenance on/off
Set the maintenance mode on/off (resource state will be set to absent and available_upto field set to 0).
-h, --hostname HOSTNAME
Set the node hostname.
-r, --resource
Set the resource.
--sql
Get resource identifiers which respond to the SQL where clause on the table jobs (ex: "type = 'default'").
-p, --property "PROPERTY=VALUE"
Set the property of the node to the given value.
-n, --nowait
Do not wait for job ends when the node switches to Absent or Dead.
EXAMPLES
oarnodesetting -s Alive -h node012
oarnodesetting -s Absent -h node012
COPYRIGHTS
Copyright 2003-2012 LIG http://lig.imag.fr This software is licensed under the GNU General Public License Version 2 or above. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarnodesetting 2012-05-23 oarnodesetting(1)