Shell Programming and Scripting

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;
else
exit

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!!!

In shell it would be something like

Code:

3.1
STATUS=$(FunctionToGetValueFromOracleTable STATUS_TBL STATUS_RUN 3.1)
[ $STATUS = "complete" ] || exit 1 # exit with error
3.2
STATUS=$(FunctionToGetValueFromOracleTable STATUS_TBL STATUS_RUN 3.2)
[ $STATUS = "complete" ] || exit 1 # exit with error
... and so on

maybe better in a loop like

Code:

for PROG in 3.1 3.2 3.3
do
     $PROG
     STATUS=$(FunctionToGetValueFromOracleTable STATUS_TBL STATUS_RUN $PROG)
     [ $STATUS = "complete" ] || exit 1 # exit with error
done

It's a kind of template
Notes :