identity column & import - need help

[bughunter]

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]

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]

bughunter@ru wrote:

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

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

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab