Archives of the TeradataForum
Message Posted: Fri, 15 Feb 2002 @ 08:27:14 GMT
<-- Anonymously Posted: Thursday, February 14, 2002 19:46 -->
I'm trying to mload some data that has numeric values in display format. The data was given with a separate sign. I'm trying to put the values into an integer field and am at a loss on how to define the thing.
FLD1 FLD2 FLD3 0034 - 0001 ---> record 1 0056 0048 ---> record 2
The data is in all Character format. There is a minus sign in FLD2 when FLD3 should be a negative value. Question is what do I put for define, and the insert statement column list and value list areas? In the example record one should cause the data value in the table to be a negative 1 and record two should result in a positive 48.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|