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
- 25460 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 the physical storage length of the data types date, time, and timestamp?
What is the difference between cursor stability and repeatable read isolation levels?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
How to restart a DB2 program?
What is an instance database?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Describe major components of db2?
Why do we bind in db2?
How can you quickly find out the # of rows updated after an update statement?
What is rct?
How to fetch the last row from the table in SQL (db2)?
What is universal database?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
