Hi,

I am using Db2 v8.x. One of new table has "ID" column which will store 11 digits max. It is an Identifier.
In version 8.x BIGINT is not supported. Please suggest which one should I prefer BIGINT(19,0) or char(12) store 11 digit value in ID coulmn and why?

If BIGINT is not supported you have to use Varchar(12), not a char(12)... Also you can use DECIMAL(11, 0).

Kara+

Hi DB2Plus
Can you please explain which one will fit best Varchar(12) or DECIMAL(11, 0) and WHY ?

BIGINT is supported in DB2 V8.x.

Decimal (11,0) takes up 6 bytes[(n+1)/2 rounded to next highest byte if necessary], and CHAR(11) takes up 11 bytes. BIGINT takes up 8 bytes.

Varchar has a 2 byte overhead for the actual number of bytes stored, plus the number of bytes (not sure why CHAR cannot be used).

V8 (DB2 LUW) is out of service, so the whole product version is "not supported".