further, multiple primary keys can be updated at time. Only condition is

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?

Question Posted / keshireddy

Answer Posted / keshireddy

further, multiple primary keys can be updated at time. Only
condition is that value should be unquie. else sql code -803

Is This Answer Correct ?

18 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1063

Explain about dbrm.

1051

What is difference between isnull and coalesce?

1060

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1275

What are the prerogatives?

1084

What is cursor stability in db2?

1363

What is the physical storage length of time data type?

1133

Explain correlated sub-queries.

1038

What is null in db2?

1031

What is the information associated with sysibm.syslinks table?

1129

When reorg is used?

1137

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1053

What is multi row fetch in db2?

1054

Which command is used to remove all rows from a table?

1118

How and when does the db2 enforces the unique key?

1086