DSXchange

Following are the list of null handling function i found in help of datastage/ Parallel section


HandleNull
IsNotNull
IsNull
NullToEmpty
NullToZero
NullToValue
MakeNull
SetNull

will these work in Server jobs (Transformation)?

How to handle null value for date type column (target - db2) ?
e.g. Default null date in Sybase is '1900-01-01'

Thanks in advance

In response to your first question:

The following functions should work in Server:
IsNull
NullToEmpty
NullToZero

and you could make use of "Not" and "IsNull" together to get the same functionality of "IsNotNull".

I don't believe the rest are available in Server.

Hope this helps...

To create a null in server jobs use the system variable @NULL. Server jobs only have out-of-band null; they do not really have the concept of in-band null except in the format/column properties of table definitions of, particularly, sequential files, where you specify how null is represented in the file.

It is a simple matter to copy the NullToEmpty Transform and create your own NullToValue Transform.