All Forums Enterprise
Rakesh nc 11 posts Joined 06/07
27 Mar 2008
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.

NetFx-3203 155 posts Joined 09/06
27 Mar 2008

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?

Rakesh nc 11 posts Joined 06/07
28 Mar 2008

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.

You must sign in to leave a comment.