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