Losing leading Zeroes
Posted: Fri Jul 16, 2004 12:47 pm
We are pulling a comma-delimited file off of the mainframe, onto a server. The file has character fields with numbers like "06". These are in quotations, as they are character fields, not numeric. When DataStage pulls them in, though, it is treating them as numbers, and dropping the leading zeroes, despite the fact that they are defined as characters throughout the entire process.
I'm guessing there is probably a way to add leading zeroes back on, but we'd prefer not to do that. We may have a "06" that we want to remain a "06" despite the fact that the field may be defined as CHAR(3) (in other words, we don't want "006"). We want to make sure we retain the original data off of the mainframe.
Any ideas/help would be greatly appreciated. Thanks! :>
I'm guessing there is probably a way to add leading zeroes back on, but we'd prefer not to do that. We may have a "06" that we want to remain a "06" despite the fact that the field may be defined as CHAR(3) (in other words, we don't want "006"). We want to make sure we retain the original data off of the mainframe.
Any ideas/help would be greatly appreciated. Thanks! :>