Trigger In Execute Command Stage Fails

[mikesherm]

I'm using an Execute Command stage in a Sequencer job to grab a single value from a text file (the file has only one value). In this case, the value in the text file is 1.

I've created a DOS batch file to read the value from the file:

@Echo Off
set /p "var="<"C:\IBM\Data\Dev\Output\ChecksumTest.txt"
echo %Var%

I've set Command in the stage to run the .bat file.

The trigger in the Command Stage is set as follows: Execute_Command_17.$CommandOutput > 1

When I look at the Event Detail, the value seems to be returned:

DBC_Master_Daily_Sequence..JobControl (@Execute_Command_17): Executed: C:\IBM\Data\Dev\Output\ReturnValue.bat
Reply=255
Output from command ====>
1
However, the trigger doesn't work as one would expect as the next stage in the Sequence still runs.

Any help would be appreciated. Thanks.

[chulett]

Command Output is a dynamic array rather than a single value, with returns being converted to Field Marks. Remove them then check:

Code: Select all

Convert(@FM,"",Stage.$CommandOutput) > 1

Or reference just the first array element:

Code: Select all

Stage.$CommandOutput<1> > 1

[mikesherm]

Chulett,

If I read your post correctly I changed the Trigger to:

CONVERT(@FM, "",Execute_Command_17.$CommandOutput > 1)

However, this still didn't work. Am I missing anything?

Mike

[ray.wurlod]

The right parenthesis is misplaced. Try

Code: Select all

CONVERT(@FM, "",Execute_Command_17.$CommandOutput) > 1

[chulett]

Hmmm... I thought for a moment you meant mine was.

[mikesherm]

Thanks, Guys. Problem Solved.