DB2 Packed Decimal

Database
Enthusiast

DB2 Packed Decimal

Hi,

I am working on migration from DB2 to Teradata. I found out that all Decimal fields in DB2 are defined as Packed Decimals that includes a sign (negative or positive). What would be the teradata equivalent data-type for such DB2 packed decimal fields with sign ? Would the Teradata Decimal data type include sign or do I have to use Double ?

Please advise.

1 REPLY
Teradata Employee

Re: DB2 Packed Decimal

All Teradata numeric data types including DECIMAL support signed values.