Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Problems loading Decimal(18)
 
From:   Joerg.Mutsch

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016