Friends can any one seggest the correct method to use isnull in datastage
ISNULL function
how can use ISNULL function in datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You use it anywhere an expression can be used. In a Transformer stage this includes stage variable initialization, stage variable derivation, output link constraint expressions and output column derivation expressions. You can use IsNull() in expressions in job sequences also. And you can use the function in any DataStage BASIC routine.
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.
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan