All Forums Database
sri99iitm 3 posts Joined 10/13
18 Nov 2014
DECIMAL REPRESENTATION IN EXPORTED FILE AND TABLE

Hello forum ,
COLUMN_1 datatype in table is DECIMAL(38,6).
When I  updated as below 

UPDATE TAB_1 SET COLUMN_1 = 1234567891234567891234567891234.000000 WHERE COLUMN_2='AAA';

 

SEL COLUMN_1 FROM TAB_1  WHERE COLUMN_2='AAA'; --> 1234567891234567900000000000000.000000

 

 

SEL  TRIM (COALESCE(  CAST (CAST( COLUMN_1 AS DECIMAL (38,6) ) AS VARCHAR(38)), '') )   FROM TAB_1  WHERE COLUMN_2='AAA';

-->1234567891234567891234567891234.000000

 

Can somebody plgg explain me about general decimal representation and above scenario in teradata? 

 

ulrich 816 posts Joined 09/09
19 Nov 2014

which tool do you use to query the DB?
Which DB version?
Which Tool version?
How do you connect? JDBC, ODBC, CLI?
Which ODBC/JDBC version?

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

sri99iitm 3 posts Joined 10/13
19 Nov 2014

Hello,
Tool -Sql Assistant 12.0.0.13
DB - 14.00.605
Connection through -ODBC 12.00.00.07
 
Thanks 
Sri
 
 

dnoeth 4628 posts Joined 11/04
19 Nov 2014

Hi Sri,
this is probably due to the "Display BigInt and Decimal(16)+ values as Strings" option being unchecked, i can't remember where this is set in SQLA12, might be Tools-Options-Data Format
Btw, you should upgrade to a newer ODBC/SQLA version asap :-)

Dieter

You must sign in to leave a comment.