DECIMAL REPRESENTATION IN EXPORTED FILE AND TABLE

Database

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? 

Tags (1)
3 REPLIES
Supporter

Re: DECIMAL REPRESENTATION IN EXPORTED FILE AND TABLE

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?

Re: DECIMAL REPRESENTATION IN EXPORTED FILE AND TABLE

Hello,

Tool -Sql Assistant 12.0.0.13

DB - 14.00.605

Connection through -ODBC 12.00.00.07

Thanks 

Sri

Senior Apprentice

Re: DECIMAL REPRESENTATION IN EXPORTED FILE AND TABLE

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 :-)