Ishita, The first step is to find the UNIX commands for each of those steps. For example, can you find a command that gets the date? For the stored procedure, look at your database documentation for the command line calls.
You don't need to change the shell. The shell is declared in the first line of the script: #! /usr/bin/ksh
This logic may not seem to be much relevant but this in in draft version for now. Now I need to perform while i am in SQL connection, but if i insert statements 1-6 inside 7-10. It gives me error for each of the command - not found error which is expected since they are not sql commands.
Can somebody tell me what should be the way to do this. Thanks.