Nov 28, 2002 #1 arzoocbe Programmer Nov 21, 2002 8 US Hi I would like to know if there is a way to verify the status(Success/failure) of a particular Bteq script (other than by verifying the error code) Thankyou Arzoo
Hi I would like to know if there is a way to verify the status(Success/failure) of a particular Bteq script (other than by verifying the error code) Thankyou Arzoo
Nov 29, 2002 #2 Patten Technical User Aug 22, 2002 106 BE No you should work with the errorcode. In Unix your shell script may look like this: BTEQ<<EOF SQL command1; .if errorcode <> 0 then quit 9 SQL command2; .if errorcode <> 0 then quit 9 EOF export EXITCODE=$? you can use the unix-variable EXITCODE to do additional other testing within your unix shell script Upvote 0 Downvote
No you should work with the errorcode. In Unix your shell script may look like this: BTEQ<<EOF SQL command1; .if errorcode <> 0 then quit 9 SQL command2; .if errorcode <> 0 then quit 9 EOF export EXITCODE=$? you can use the unix-variable EXITCODE to do additional other testing within your unix shell script