Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    37

    Unanswered: CREATE TABLE oracle <--> db2

    hi all,

    in oracle there ist for "CREATE TABLE" statement option like



    STORAGE (INITIAL NEXT MAXEXTENTS UNLIMITED) PCTINCREASE FREELISTS FREELIST


    what is the pendant in db2?


    thanks

    bab

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: CREATE TABLE oracle <--> db2

    Don't know of any option like this one in DB2

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: CREATE TABLE oracle <--> db2

    Years ago in version 4, I did use such specifications. However, I'm not sure anymore whether it was for tables, or for tablespaces.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: CREATE TABLE oracle <--> db2

    But, was this on Distributed Platforms ?

    Cheers
    Sathyaram

    Originally posted by DoktorBlue
    Years ago in version 4, I did use such specifications. However, I'm not sure anymore whether it was for tables, or for tablespaces.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: CREATE TABLE oracle <--> db2

    On IBM mainframe
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: CREATE TABLE oracle <--> db2

    Thanks for clarifying ......

    Cheers
    Sathyaram

    Originally posted by DoktorBlue
    On IBM mainframe
    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
  •