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
Null Hadling - Server Jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
It is a simple matter to copy the NullToEmpty Transform and create your own NullToValue Transform.
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.