8.2 UDB win32
I need update a one column in very large table. PK for this table -
generated always as identity :-(
I can't recreate table without generated always.I don't want write SP
or any non-sql script.
I'd like simple export & import with commit as I typically do
export to file select pk, new_value as upd_col from table
import from file commitcount xxx insert_update into table(PK,upd_col)
Is it possible? or give me another solution, plz.
Andy
Brian Tkatch - 01 Dec 2005 14:16 GMT
I do not understand what you are asking. What is the problem?
Perhaps you should look at the MODIFIED BY parameter for IMPORT. This
is in the "Command Reference" in "Chapter 3. CLP Commands" section
"IMPORT".
I would look at "identityignore" and "identitymissing" to see if that
helps.
B.
Serge Rielau - 01 Dec 2005 14:57 GMT
> 8.2 UDB win32
>
[quoted text clipped - 11 lines]
>
> Andy
You should be able to ALTER TABLE .. ALTER COLUMN SET GENERATED BY
DEFAULT (or something like that. check the syntax in alter table for V8.2)
Cheers
Serge

Signature
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab