Hi,
We've created a routine that runs as an after-job subroutine in which DSExecute is utilized to launch a unix script with some sql in it.
The program works fine. However, we're trying to build in error messages, so that let's say the SQL didn't execute for whatever reason (database down, etc.) then an error message will be passed to the Ascential Log files.
At first, I thought I could use DSExecute's SysRet, but it appears to return 0 as long as the command is launched...regardless of what happens from there.
Anyone have any suggestions as to how to pass an error message to the Ascential logs?
DSEXECUTE Help in after job subroutine
Moderators: chulett, rschirm, roy