Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 27110 Views
- I also Faced
- E-Mail Answers
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 |
Post New Answer View All Answers
What is bind and rebind in db2?
What is database manager in db2?
How do I delete a column in db2?
Why db2 is called db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What are the rules for db2 programming?
What is access path in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Mention the downsides of page level lock.
How do I add a column in db2?
can all users have the privilage to use the sql statement select * (dml)?
What does db2 mean?
Is the primary key a clustered index?
What is difference between rollback and commit?
What is deadlock in db2?
