Search found 5 matches

by Swaruparani
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

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.
by Swaruparani
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

Hi Shalini,

pls try this one in transformer,this is working

If IsNull(DSLink3.inputcolumn) Then 'UNKNOWN' Else If trim(nulltoempty(DSLink3.inputcolumn)) ='' Then 'UNKNOWN' Else DSLink3.inputcolumn
by Swaruparani
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

hi,

can u try this one:( NullToValue(DSLink3.sal,'Unknown'))
by Swaruparani
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.
by Swaruparani
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.