Search found 2 matches

Go to advanced search

by naresh_kakarla
Mon Nov 22, 2010 4:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: remove leading zeros in decimal field in sequential file
Replies: 26
Views: 79090

I think the Below logic is useful for you

convert(' ','0',(trim(convert('0',' ',Column_Name)))

Note: If u r using above logic then you have to change the column datatype like Char or Varchar
by naresh_kakarla
Sun Nov 21, 2010 3:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need Days from two Dates
Replies: 9
Views: 4484

convert date formate to integer format by using juliandays from date and then you use '-' operator

Go to advanced search