Hi Shalini,
This one is working,u can try this:
If IsNull(DSLink3.inputcolumnn) Then 'UNKNOWN' Else If trim(nulltoempty(DSLink3.inputcolumnn)) ='' Then 'UNKNOWN' Else DSLink3.inputcolumnn
Thanks.
Search found 5 matches
- Wed Jun 03, 2009 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling in transformer
- Replies: 19
- Views: 11574
- Tue Jun 02, 2009 5:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling in transformer
- Replies: 19
- Views: 11574
- Mon Jun 01, 2009 6:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Null handling in transformer
- Replies: 19
- Views: 11574
- Thu May 21, 2009 12:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: data flow in data stage
- Replies: 1
- Views: 1275
data flow in data stage
could you pls help some body to know about the data flow in datastge?
thanks in advace.
thanks in advace.
- Wed May 20, 2009 11:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: last day of the month of a given date
- Replies: 11
- Views: 5353
last day of the month of a given date
i will pass a date an input ,i need to get the last day of that month.
EX:if i will pass 2009-02-16 as input then my expected output should be 28(last day of FEB)
Thanks in advance.
EX:if i will pass 2009-02-16 as input then my expected output should be 28(last day of FEB)
Thanks in advance.