Decimal datatype in Teradata V12

UDA
Enthusiast

Decimal datatype in Teradata V12

I was previously using Teradata Version 6 and we used to fastload data into tables with fields, decimal(18,4). Now we have shifted to Teradata Version 12 and requirement is that the tables should have decimal(19,4) fields. I get the following error when I try to fastload data into a decimal field(19,4), "DECIMAL TYPE- record too short".
However when I try to fastload with decimal(18,4) in Teradata Version 12, it runs just fine. So could someone please help me with this.
3 REPLIES
Teradata Employee

Re: Decimal datatype in Teradata V12

Decimal(18) takes up 8 bytes while Decimal(19) through Decimal(38) takes up 16 bytes.
See SQL Reference: Data Types and Literals.

Is the source data/field 16 bytes long?
Enthusiast

Re: Decimal datatype in Teradata V12

The source datatype is "MONEY" in SQL Server with Length=8, Precision=19, Scale=4. Pls let me know which is the corresponding datatype in Teradata V12 for this "MONEY" datatype.

thanx in advance.
Enthusiast

Re: Decimal datatype in Teradata V12

You found solution ?

Because I also need a variable that replaces the "money" in Teradata.