DataStage tips is now active on datastagetipsntricks.blogspot.com
Iconv is internal conversion,Oconv is External conversion.Finally it is used to convert date format.Function to convert mm/dd/yyyy format to mm-dd-yyyy isOconv(Iconv(fieldname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]")
Iconv is internal conversion,
ReplyDeleteOconv is External conversion.
Finally it is used to convert date format.
Function to convert mm/dd/yyyy format to mm-dd-yyyy is
Oconv(Iconv(fieldname,"D/MDY[2,2,4]"),"D-MDY[2,2,4]")