Is it possible to write unpacked decimal data into CFF?

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
vrishabhsagar
Participant
Posts: 33
Joined: Mon Nov 12, 2007 1:02 am
Location: Bangalore

Is it possible to write unpacked decimal data into CFF?

Post by vrishabhsagar »

I am trying to map a decimal column into a complex flat file, however i notice that the layout of the file shows the column being stored in packed decimal format with storage length less than the actual length of the column.

Is it possible to write a decimal column into a complex flat file, without actually packing it? One solution that comes to my mind is to write the column as a CHAR field and take care of the 'numeric' semantics of the column ourselves. Is there any other way?
Rishabh Sagar V
Bangalore
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Can't you write into a PIC 9(9)V99 field or similar?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply