calling 'n' number of shell scripts based on dependency in one shell script.

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting calling 'n' number of shell scripts based on dependency in one shell script.
# 1  
Old 11-03-2009
calling 'n' number of shell scripts based on dependency in one shell script.

Hello gurus,

I have three korn shell script 3.1, 3.2, 3.3. I would like to call three shell script in one shell script.

i m looking for something like this

call 3.1;
If 3.1 = "complete" then
call 3.2;
if 3.2 = ''COMPlete" then
call 3.3;

The status can obtained from Oracle table called "STATUS_TBL", field names STATUS_RUN And Script_name. It can be either "COMPLETE" or "RUNNING"or "FAILED".

So i want refer each time to status_tbl to see what status it is. If 3.1 is failed then i want to exit, if complete then kick off 3.2, if 3.2 is failed exit, else if 3.2 is complete then kick off 3.3.

So how do i accomplish this in one shell script???? Any example of the code would be great or either code template would be great....

Thank you so much!!!
# 2  
Old 11-03-2009
In shell it would be something like
STATUS=$(FunctionToGetValueFromOracleTable STATUS_TBL STATUS_RUN 3.1)
[ $STATUS = "complete" ] || exit 1 # exit with error
STATUS=$(FunctionToGetValueFromOracleTable STATUS_TBL STATUS_RUN 3.2)
[ $STATUS = "complete" ] || exit 1 # exit with error
... and so on

maybe better in a loop like
for PROG in 3.1 3.2 3.3
     STATUS=$(FunctionToGetValueFromOracleTable STATUS_TBL STATUS_RUN $PROG)
     [ $STATUS = "complete" ] || exit 1 # exit with error

It's a kind of template
Notes :
  1. The script waits the called process to finish, therefore it's not necessary to check "running"
  2. the construction with || replaces the if not [condition] then .. fi
  3. Maybe you need to replace the [ ] with [[ ]]
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script to create runtime variables based on the number of parameters passed in the script

Hi All, I have a script which intends to create as many variables at runtime, as the number of parameters passed to it. The script needs to save these parameter values in the variables created and print them ---------- export Numbr_Parms=$# export a=1 while do export... (3 Replies)
Discussion started by: dev.devil.1983
3 Replies

2. Shell Programming and Scripting

How to match floating number range in shell scripts?

for example: # I want to judge the value of $1 which should be $2<$1<$3. temp0=`echo "$1 - $2" | bc` temp1=`echo "$1 - $3" | bc` if ] ; then echo OK else echo False fi Please use code tags, thanks. (6 Replies)
Discussion started by: 915086731
6 Replies

3. Shell Programming and Scripting

Calling oracle package Unix from shell scripts.

Hi, Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell script. I want to know the way to capture the output values in my shell script. Please send some... (1 Reply)
Discussion started by: anil029
1 Replies

4. Solaris

difference in calling shell scripts

Hi I am getting some errors when i am running the shell script using the following syntax: > but the same script works fine with the following syntax: >sh wats the difference in both....please help thanks in advance. (6 Replies)
Discussion started by: arpit_narula
6 Replies

5. Shell Programming and Scripting

Calling shell functions from another shell script

Hi, I have a query .. i have 2 scripts say and contains many functions written using shell scripts. is a script which needs to call the functions definded in function calls are with arguments. Can some one tell me how to call the functions from Thanks in... (6 Replies)
Discussion started by: jisha
6 Replies

6. UNIX for Advanced & Expert Users

Shell Script Dependency/Tracer

Hello All, We have a very old system at hand in which there are hundreds of shell scripts that use other shell scripts, all on the same server. There are several that are not used at all as well. In short, it's an unmanaged system thats been lying around for many years, and it needs to be... (12 Replies)
Discussion started by: ag79
12 Replies

7. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies

8. Shell Programming and Scripting

Need a simple file based utilty for shell scripts

Hello, I'm wondering if you may know of a simple file based UNIX utility that can be used to store and retrieve values on a flat file, let's say i have a file called "kru", i'd like to be able to specify a request like: while(....) if ; then kru.fld2 = $rec_cnt kru.fld3 =... (4 Replies)
Discussion started by: bobk544
4 Replies

9. Shell Programming and Scripting

Calling SQL scripts through Shell Script

Oracle and Scripting gurus, I need some help with this script... I am trying to add the query SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'METADATA' in the current script.... Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Discussion started by: madhunk
18 Replies

10. AIX

Difference between writing Unix Shell script and AIX Shell Scripts

Hi, Please give me the detailed Differences between writing Unix Shell script and AIX Shell Scripts. Thanks in advance..... (0 Replies)
Discussion started by: haroonec
0 Replies
Login or Register to Ask a Question

Featured Tech Videos