![Smile :-)](./images/smilies/icon_smile.gif)
I do not actually have a .ksh per se that calls the .sql. My DSEE job launches the sqlplus command as an After-job subroutine on successful completion of the job and looks like this:
sqlplus USR/PWD@SCHEMA @filename.sql PARAMETER
There is one PARAMETER which is the only one required by the .sql
Thus is there anyway I could include the way to catch the sql error in this? Or do I have to write a ksh. This ksh has to be called by Datastage and thus I decided to do it this way since just for one command I didn't see the point in creating a Sequence job.encapsulating the unitary job.