Search found 2 matches
- 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
- 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 ...