Archives of the TeradataForum
Message Posted: Thu, 01 Jun 2000 @ 14:45:08 GMT
If the data on input is stored as ' 7' and you want the data loaded to a numeric column it may be best to DEFINE the field as a CHAR(04) but load it to an integer column and let Teradata do the conversion.
There may be a need to put a FORMAT of 'ZZZ9' on the column in the VALUE clause. I'll check out some code at work today and let you know.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|