Archives of the TeradataForum

Message Posted: Wed, 14 Sep 2005 @ 09:41:44 GMT

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

Hi all,

I've been faced with an Issue with loading a Falue into a DECIMAL(18) Filed.

The Definition for the Table looks like

     Create Table ....
     (
        Field1 DECIMAL(18,0) not NULL DEFAULT 10101010101010101.,
        Field1_CF CHAR(18) CHARACTER SET LATING NOT CASESPECIFIC DEFAULT
     '010101010101010101',
     ....
     )
     UNIQUE PRIMARY INDEX (FIELD1);

The insert Section look like this:

     INSERT INTO ... (10101010101010101, '010101010101010101', .....)

The Result look lik this

     SELECT * FROM ....
     Field 1            Field1_CF
     10101010101010100  '010101010101010101'

which is kind of strange. I do not have any clue why this is happen. Does anyone have an idea?

Thanks and regards

Joerg

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