Shell Programming and Scripting

I was running a script to upload data from file to database but it is failing in middle.Can i use trap command to find the error that is occured while running the script.

Thanks in advance,
Satish.

Provide us some details...
What is your os? (i.e. windows, unix, etc.)
What is your datanase? (i.e. oracle, db2, mysql, etc.)
What kind of script are you having the problem with? ( bash, ksh, perl, etc.)

Post the script and any messages you are receiving and point out which line you think the error occurs on.

OS - UNIX
DB - oracle
script - ksh

Code:

handleInterrupts 1 2 3  4 5 6 7 8 9 10 11 12 13 14 15

handleInterrupts
{
     echo "\n handling "
     cp ~$HOME/sat/* ~$HOME/sat/middlefile/*
}

I am trying to print the logs which are getting generating while running the script into other directories

I was able to handle ctrl+c and other interrupts and the files are getting copied successfully.
But if the program is failing at reporting code which is called from the script then the above handleInterrupts function is unable to handle hence the logs are not copied to the destination path.I could not find the reason for my reporting code failure because the files are getting deleted when the whole process is completed.

Is there any other handle interrupt which i can use to copy the logs even if the program ends like the above scenario.

Thanks ,
Satish.

What is this 'program' you are calling from the script?(i.e. sqlplus, another script, etc.)
Where does the 'program' being called log any errors/exceptions that occurs?
Check the exit status code from the 'program' in the script right after you call it:

Code:

if [[ $? = 1 ]] then
  print "$? - ERROR"
fi

There are at least three problems with these three lines of code. First: You need a semicolon or a newline before the then in your if statement. Second: What happens if the 'program' exits with a non-zero exit status other than 1. (The answer is that this code will silently ignore it.) Third: The $? in the print statement will not be the exit status of the 'program'; it will be the exit status of the conditional expression ([[ $? = 1 ]] which will be 0 if you get to the print statement. I assume that what you intended was something like:

Code:

ec=$?
if [ $ec -ne 0 ]
then    print "$ec - ERROR"
fi