Archives of the TeradataForum
Message Posted: Tue, 09 Oct 2001 @ 19:44:56 GMT
| Subj: || || Re: 38 position NUMERIC field? |
| From: || || Geoffrey Rommel |
| ||We are receiving a file where the data is pulled out of Oracle.|| |
You have my deepest sympathy.
| ||Apparently Oracle has the data defined as NUMERIC(38) and the field in the file is populated like this
| ||Any suggestions on how to get this data into Teradata with the leading zeroes displayed as blanks?|| |
Can't you just ignore the leading zeroes when you load it? For instance, if this were the first field in the file, and you were loading
it with FastLoad, you could say:
define filler01 char(20)
and then insert 'bignumber' into a DECIMAL(18) field. I assume you don't have any numbers of more than 18 digits; if you do, you won't
be able to fit them into a FLOAT field anyhow.