Removing a record with null field using transformer

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
hari4dsx
Participant
Posts: 14
Joined: Wed Feb 13, 2008 4:53 am

Removing a record with null field using transformer

Post by hari4dsx »

Hi,
My requirement is to check the value for a particular field.If the value is null then send the entire record to error table else pass it to output.

I am using the following condition in the constraint field.

IsNull(input column)

the job executes well but the error table is not populated with the null records.null records pass through the target.

Please help and thanks in advance.
regards
Hari
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Then they're not nulls, probably just an empty string. What kind of field are we talking about? Can you try checking for both?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply