How to accept whitespaces in a packed decimal field in the S

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
verify
Premium Member
Premium Member
Posts: 99
Joined: Sun Mar 30, 2008 8:35 am

How to accept whitespaces in a packed decimal field in the S

Post by verify »

How to accept whitespaces in a packed decimal field in the Sequential File Stage?

The properties in the Format Tab have been set as

Decimal

Packed = no(overpunch)
Sign position = trailing

The reason for setting the data field as Packed Decimal instead of a Char is to read certain special character resulting form the conversion of EBCDIC format to ASCII format.

Thanks.
RK Raju
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

White space is illegal in packed decimal and there is therefore no way to force DataStage to accept the same. You can read the field as a string, and then parse the result.
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