Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / December 2005

Tip: Looking for answers? Try searching our database.

identity column & import - need help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bughunter@ru - 01 Dec 2005 14:02 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.