Search found 2 matches

by RobP
Wed Mar 18, 2015 3:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Format of decimal value in sequential files
Replies: 6
Views: 3310

Thank for your reply, but I was not successfull in doing this. I would have hoped there could be a format mask like "&&&&&&&.&&" or something like that. The only things I could find are suppres_zero and that kind of stuff. Input is a decimal data fileld ...
by RobP
Tue Mar 17, 2015 9:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Format of decimal value in sequential files
Replies: 6
Views: 3310

Format of decimal value in sequential files

Need to develop a job that outputs a decimal value in the format 99999.999, input is a databse column defined as decimal (8,3). Some requirements: - Format is fixed length, so all positions need to be padded - First position not used for +/- sign Tried to use the decimal format in the format tab of ...