Loading data to a hash file

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
EJRoufs
Participant
Posts: 73
Joined: Tue Aug 19, 2003 2:12 pm
Location: USA

Loading data to a hash file

Post by EJRoufs »

I am loading data from a comma-delimited file to a hash file, so I can do quick look-ups on it. The problem I'm having is that some of the data gets reformated when I move it over, for no apparent reason.

Example: I have account numbers that need to be 4 digits. Some of them have leading zeroes, though. 0001, 0002, 0003, etc. When I move the data to the has file, it drops the zeroes. I do not want it to drop the zeroes, but can't see how to stop that from happening.

Any info/help would be greatly appreciated. Thanks! :)
Eric
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

Eric, declare that column as VARCHAR in the source and hashed file and it won't strip out the leading zeroes.
Top
EJRoufs
Participant
Posts: 73
Joined: Tue Aug 19, 2003 2:12 pm
Location: USA

Post by EJRoufs »

ArndW wrote:Eric, declare that column as VARCHAR in the source and hashed file and it won't strip out the leading zeroes. ...

Thanks! I will give that a shot! :)
Eric
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”