Hi
The output of my log for the execute command stage is
Seq_Madison_Customer_Master..JobControl (@Command_To_Chk_Rejects): Executed: wc -l /cdwdata/reject/pharma/madison/*Rejects.txt | grep total | awk '{print $1}'
Reply=0
Output from command ====>
0
Then I do a custom expression in the next check condition stage as in
Command_To_Chk_Rejects.$CommandOutput > 0
The problem is I still get a email as it seems to not pass this above condition
I think I am missing something basic woudl greatly appreciate any help
sigma
Sequence check condition stage help
Moderators: chulett, rschirm, roy
Output from the Execute Command stage is returned in a dynamic array, which means there's more to that zero than meets the eye. It's actually a zero followed by a Field Mark, which is why your test fails.
Couple of solutions. Either check just the first element of the array or remove the field mark. Trigger examples for both:
Couple of solutions. Either check just the first element of the array or remove the field mark. Trigger examples for both:
Code: Select all
Command_To_Chk_Rejects.$CommandOutput<1> > 0
Code: Select all
Convert(@FM,"",Command_To_Chk_Rejects.$CommandOutput) > 0
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thanks a lot for the reply
Convert(@FM,"",Command_To_Chk_Rejects.$CommandOutput) > 0 solution works
I will try and understand what it does but it seems to work
The other solution
Command_To_Chk_Rejects.$CommandOutput[1] > 0 does not seem to work
Thanks a lot again and I will consider this post closed
Regards
Sigma
Convert(@FM,"",Command_To_Chk_Rejects.$CommandOutput) > 0 solution works
I will try and understand what it does but it seems to work
The other solution
Command_To_Chk_Rejects.$CommandOutput[1] > 0 does not seem to work
Thanks a lot again and I will consider this post closed
Regards
Sigma
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What error did you get from the compiler when "it wouldn't compile"?
Instead of the angle bracket notation you can use a Field() function which is equivalent (that is, the delimiter is @FM).
Instead of the angle bracket notation you can use a Field() function which is equivalent (that is, the delimiter is @FM).
Code: Select all
Field(Command_To_Chk_Rejects.$CommandOutput,@FM,1,1) > 0
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.