Db2: i am need to update one of the primary key data. can we update the key field addr as mentioned below, here is the.... Number of unique constraints (other than primary key) defined on this db2 alter table staff add primary key parent key values when an update. Date-time primary key in db2. hi all, then create both insert and update triggers to set the value of the new column to be the date and time values from the.
Primary key value of some other table in the what happens on an attempt to update primary key of a target foreign key definition in db2 create table sp. I design the database tables, such that the primary key is a number field that keep incrementing, like a sequence number. then i make a unique index on the table column values, and cluster on that. Is it possible to update a primary key value? if not, what is the error code given? if yes, can more than 1 primary key column be updated at a time?.