Ans 3 is correct. If the key already present, while updating it will show

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 / guest

Answer Posted / guest

Ans 3 is correct. If the key already present, while
updating it will show the sql code as = -803.

Is This Answer Correct ?

12 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between drop table and delete table?

1198

What does sqlcabc has?

1040

Explain packages.

1102

How to find the number of rows in a db2 table?

1111

What is db2?

1165

What is a collection in db2?

1027

What is null indicator in db2?

1099

How to take backup of table in db2?

1065

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

1262

What is a db2 package?

1041

Can you use max on a char column?

1086

What is dbrm in db2 database?

1103

What is the result of open cursor statement?

1073

How to restart a DB2 program?

1883

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1179