I was wondering how to use the Custom - (Conditional) in a sequencer.
I am pretty new to DataStage and need my job to fail if there is a null found in out CurrentDate column.
Anyone know how I handle this requirement?
Thanks!
Custom - (Conditional) -- How do I use this?
Moderators: chulett, rschirm, roy
Those trigger expressions are used to check for conditions after a job completes, for example to see if it aborted. And as one might expect, the 'custom' one lets you write your own condition when none of the standard ones are appropriate.
To force a job to about based on a data condition, you'll need to do that inside the job itself. One way is to conditionally call the DSLogFatal() function but i'm not certain that is valid in a PX job. Another is to setup a reject link from a Transformer with a constraint that directs your null rows down it and then set the 'Abort after' row count to 1.
To force a job to about based on a data condition, you'll need to do that inside the job itself. One way is to conditionally call the DSLogFatal() function but i'm not certain that is valid in a PX job. Another is to setup a reject link from a Transformer with a constraint that directs your null rows down it and then set the 'Abort after' row count to 1.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers