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.
How to accept whitespaces in a packed decimal field in the S
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.