Trigger in sequence not recognising the command output

[mouni]

Hi

In the sequence trigger i'm specifying when the script output is "ERR-0099" by Execute_Command_0.$CommandOutput='ERR-0099'

But the trigger is not getting activated even when i see in logs messages like this
Output from command ====>
ERR-0099

[priyadarshikunal]

Hi

In the sequence trigger i'm specifying when the script output is "ERR-0099" by Execute_Command_0.$CommandOutput='ERR-0099'

But the trigger is not getting activated even when i see in logs messages like this
Output from command ====>
ERR-0099

check for any unwanted character in the output

you can also try a combiation of field and convert functions.

Code: Select all

 field(convert(@FM,',', Execute_Command_0.$CommandOutput),',',1)='ERR-0099'

since I don't have access to datastage and I am unable to verify it please verify the syntax.

[priyadarshikunal]

Hi

In the sequence trigger i'm specifying when the script output is "ERR-0099" by Execute_Command_0.$CommandOutput='ERR-0099'

But the trigger is not getting activated even when i see in logs messages like this
Output from command ====>
ERR-0099

check for any unwanted character in the output

you can also try a combiation of field and convert functions.

Code: Select all

 field(convert(@FM,',', Execute_Command_0.$CommandOutput),',',1)='ERR-0099'

since I don't have access to datastage and I am unable to verify it please verify the syntax.

[chulett]

That's kind of overkill, one or the other should work but the basics are sound. The output is a dynamic array and what you are not seeing (or taking into account) are the Field Marks between the elements. Either remove them or just check the first element. Some examples below, not an exhaustive list.

Code: Select all

Convert(@FM,'',Execute_Command_0.$CommandOutput)='ERR-0099'

Field(Execute_Command_0.$CommandOutput),@FM,1,1)='ERR-0099'

Execute_Command_0.$CommandOutput<1>='ERR-0099'

I prefer the last one.