Archives of the TeradataForum
Message Posted: Wed, 14 Sep 2005 @ 09:41:44 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|