|
|
|
Junior Member
 
Group: Forum Members
Last Login: 8/14/2008 7:50:18 AM
Posts: 11,
Visits: 34
|
|
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.
Rakesh nc
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 1:34:04 PM
Posts: 117,
Visits: 238
|
|
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?
Shaw
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 8/14/2008 7:50:18 AM
Posts: 11,
Visits: 34
|
|
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.
Rakesh nc
|
|
|
|