Hi,
I do have three scripts. Whcih inserts records into a table using sqlldr, creating some reprot files etc. The first script will call the second and then the second will call the third. When I run my first script from the shell prompt, all my operation are completed successfully. If I do the same using a cron , then its working partially. Not able to insert records, log files not generating etc.. Is there any seeting to be made in cron or how can this be solve ?? Help me out ... I am using HP-Unix

Do a search on this site. 99% of cron problems are due to people making wrong assumptions about the environment.

cron gives you a minimal environment, it does not run your .login, .profile or whatever.

I am using unzip in my second script. But that command is returning 127. As i said earlier if I run my first script from the prompt, then it call the second script, it does the unzip operation succesfullly and the process goes on. Only when the first script is scheduled in a cron, the unzip fails and after that nothing is working. Wat can be done for this ??

What can be done first is to start here with the FAQs

Unzip returns 127 = ???
And show us your script perhaps.

unzip myfile.zip > /dev/null
echo $?


If i store the above lines in a script and run that manually then its working fine. If i schedule the script using cron , htne its returning 127. What could be cause ??

try giving the absolute path of unzip

should be in /usr/bin/unzip

and wrap the commands in a script and redirect the script output to a log file to see what error is actually displayed.