Archives of the TeradataForum

Message Posted: Fri, 15 Feb 2002 @ 08:27:14 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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.

Input record:

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>