I want to define a ID Column of SERIAL TYPE that will be my Primary Key. What is the maximum value that the Column with SERIAL TYPE will hold.
---------------------------------------------------------------------
I should have been more specific in my question. Here is it:

If I create a database TABLE like this... what is maximum value BBX_KEY will hold? I need to know that.

create table SPX.BBX (
BBX_KEY NO not null,
CHAS_KEY SI not null,
CAL_DATE SI not null,
);

NOTE: The above code has been generated in Powerdesigner.

Shaan

There is no datatype 'SERIAL'

The auto-increment Identity Column can be int, smallint, bigint or decimal.
1 Largest INTEGER value +2 147 483 647
2 Largest BIGINT value +9 223 372 036 854 775 807
3 Largest SMALLINT value +32 767

Cheers
Sathyaram

If I create a database TABLE like this... what is maximum value BBX_KEY will hold? I need to know that.

create table SPX.BBX (
BBX_KEY NO not null,
CHAS_KEY SI not null,
CAL_DATE SI not null,
);

You are in the DB2 forum ..

What db2 version are you on ?

This CREATE TABLE Statement will not work on LUW and zOS ...

NO, SI are not valid datatypes

Cheers
Sathyaram