Forums | Admin

Discussion Forums: open-discussion

Start New Thread Start New Thread
Message: 63513
BY: Praveen Devarao (praveend)
DATE: 2009-01-02 08:11
SUBJECT: RE: Moving table to a new database

 

Hi David,

Unfortunately, there no such simple option with which you will be able to import a table with a column GENERATED ALWAYS AS IDENTITY. The only workaround as of now is to 1) recreate the table without GENERATED ALWAYS 2) load/import the data and then 3) alter the table to have the respective column as GENERATED ALWAYS AS IDENTITY.

I checked and also enquired about this and came to know that the import will work fine in case of GENERATED BY DEFAULT AS IDENTITY (the clause which ibm_db_adapter uses for the id column). However the same is not possible with a column defined as GENERATED ALWAYS AS IDENTITY.

Let me know if you require more info.

Thanking and wishing you a Happy New year

Praveen


Thread View

Thread Author Date
Moving table to a new databaseDavid Adler2009-01-01 23:23
      RE: Moving table to a new databasePraveen Devarao2009-01-02 08:11
            RE: Moving table to a new databasePhilip Nelson2009-01-02 11:52
                  RE: Moving table to a new databasePhilip Nelson2009-01-02 11:58
                        RE: Moving table to a new databasePraveen Devarao2009-01-02 13:06
                        RE: Moving table to a new databaseDavid Adler2009-01-02 14:03
                              RE: Moving table to a new databasePhilip Nelson2009-01-02 14:30

Post a followup to this message