Default format is ignored

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
surfsup
Participant
Posts: 18
Joined: Thu Apr 23, 2009 8:43 am

Default format is ignored

Post by surfsup »

Hi,

I am trying to convert a decimal to string using the "string_from_decimal" modify function and write that to a file. The only trick is that the separator needs to be a comma (",") and has to be without leading/ trailing zeros.

I see three choices. The last one works but is least desirable by the client.
- use the sequential file "decimal separator" option but I cannot suppress zeroes.
- use a modify, but that ignores the "Format" tab properties and uses a (.) for decimal separator.
- use a transformer.

Any help with the first two? Am I omitting something?
Post Reply