I have a server job that includes an FTP stage to retrieve a file to the DataStage server. Before it ftp's this file we have a 'Before Telnet Command' execute a unix shell script to sort the file before the ftp. Our issue is that occasionally the shell script fails due to lack of space or the file not being there but this does not cause the job to abort!?!?
Has anyone seen this and know of a solution or does an error in a Before Telnet Command NEVER return and error?
Yes, I specifically check the error codes and have code that forces the script to return a 99 if there is an error. I have tested this functionality and ensured it is returning a non-zero return code.
Thanks for the response Ray.
I can definitely do that, but do you know if a "Before Command' ever returns a non-zero return code or will cause the job to abort?