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 does runstats do in db2?

1119

What is a trigger in the db2 database?

1080

What happens in bind step in a db2 program?

974

What is image copy in db2?

1019

What is dclgen (declaration generator)?

1059

What is null in db2?

1026

Which isolation level provides highest data integrity?

1118

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

1044

How do you stop a db2 database in linux?

1014

i want to maintain uniqueness on pdf without make lf??????????

2158

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2214

What are foreign keys in db2?

1105

Define data page.

1070

What is isolation level in db2?

1005

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1107