Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    2

    Exclamation Unanswered: URGENT: WHAT IS MAX VALUE for Serial Type Column

    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
    Last edited by shamshad; 06-09-04 at 15:03.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2004
    Posts
    2
    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,
    );
    Last edited by shamshad; 06-09-04 at 14:54. Reason: Question clarification

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •