On Apr 16, 5:31 pm, Serge Rielau <srie...@[EMAIL PROTECTED]
> wrote:
> > Why don't I use IM****T/EX****T? Because a lot of tables have IDENTITY
> > GENERATED ALWAYS, so I have conflicts in IDs when I load ex****ted
> > data. Also, db2move tool allows only 10 table names to be specified at
> > a time...
>
> Why don't you use LOAD instead of IM****T. It is faster and can handle
> generated columns just fine.
>
> Also IIRC you can drop (and add) the identity property in DB2 8.2.
>
Slightly offtopic, but ... I assume IDENTITY GENERATED ALWAYS is
implemented via a sequence, correct? If so, is it possible to
determine which sequence that is used for a table?
/Lennart
|
