A table can have no more than one primary key. primary keys are optional and can be defined in create table or alter table statements. the unique index on a primary key is called a primary index. when a primary key is defined in a create table statement or alter table statement, db2 automatically creates the primary index.. Is it possible to update a primary key in a db2 table? was told it is but even with changing the field in question in the table definition to not a key (there are other fields that are p keys too) i am getting errors.. Hi to all !!! i am new working with db2. i have one table with 4 primary key (clientid, timestamp,entitytype,entityid) and i need update this table (history)..
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... portal | manuals tue may 01, 2007 3:28 pm post subject: can we update a primary key value of a db2 table: i am need to update one of the primary key data. can we update the key field addr as mentioned below, here is the. Add primary key(id,some_val); keep in mind, however, that the data in your existing table may affect your ability to effectively change the primary key, such as any null values in a field. any fields you want to add to the primary key definition must be declared as "not null", so you may have to alter that column as well.. Why are you doing primary keys this way. why would you need to dynamically generate/modify your own id values? if you need a unique generated id for a table, create a sequence and use that sequence value in your table..
