NULL in where of a filter stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

NULL in where of a filter stage

Post by ds_is_fun »

What syntax do i throw in a filter stage while looking for a NULL value in a specific column.
IsNull(Col)
OR
??
Thx
throbinson
Charter Member
Charter Member
Posts: 299
Joined: Wed Nov 13, 2002 5:38 pm
Location: USA

Post by throbinson »

Parallel Developer's Guide Chapter 29-4 (page654)

Testing for a Null
You want to test column serialno to see if it contains a null. If it does,
you want to write the corresponding records to the output link.
You enter the following in the Where property:
serialno is null

or
is not null
Post Reply