Problem running a .bat file from Command Stage

[danddmrs]

Any reason this line would work in a .bat file executed from Windows Explorer but fails when executing the .bat file from the Execute Command stage?

IF %length% == 0 GOTO NOMSG

DataStage Event Detail:
Reply=255
Output from command ====>
GOTO was unexpected at this time.

Thanks!

[SURA]

Is it executing when you executed from dos prompt?

Code: Select all

IF %length% == 0 GOTO NOMSG 

space might be the reason i guess!

IF %length%==0 GOTO NOMSG


DS User

[danddmrs]

The .bat file does execute successfully from DOS prompt, removing the spaces did not change the result. Thanks!

[qt_ky]

Post some details, like the values from the fields in the Execute Command stage, and the contents of the .bat file, the path, and file name.

[danddmrs]

Was going to use this to detect records in a file. Converted the file into a reject, triggered a notification stage to send the file, used a sequencer with ANY option to continue process.