Hi,

I want to migrate a Database from DB2 OS390 to DB2 8.1 AIX in the OS390 generated DDL is the following statement:
create table xxxx ( idcol rowid not null generated always )
On DB2 8.1 this generate me an error SQL0104N and DB21034E
How can I translate this coloumn definition for DB2 8.1 on AIX ?

Thanks for your help

DB2 8.1 for LUW (Unix,etc) does not currently support ROWID (direct storage of the internal DB2 rowid). The closest thing would probably be:

CREATE TABLE XXXX
(IDCOL INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY
(START WITH 1, INCREMENT BY 1),

You can use certain other numeric data types in addition to integer. This column can be populated by the load/import command.

You might want to consult the following guide downloadable from the IBM website: "SQL Reference for Cross-Platform Development Version 1.1"