Trapping errors on sql error and os error

[ekinox]

hi all,
i'm running a script which exits execution whenever there is a sql error or an os error. Is it possible to trap the sql error or the os error which caused the script to exits and put it into another log file ? Please Help!!!

Thanks.

 

[Marco Kalter]

You can only use the spool file to view the error message. The whenever command does not allow any other option than commit/rollback and exit/continue.

------------------
Marco Kalter
Allround Automations