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?
Answer Posted / priya
If a primary key column cannot be updated, what is the
error code given when an attempt is made to update it
through a SQL query in a COBOL program?
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What language is db2 written in?
What is bind plan?
How do you pull up a query which was previously saved in qmf?
How can record locking be achieved in those DB2 versions which do not support it?
How does coalesce work?
What is cursor stability in db2?
What is difference between alias and synonym in db2?
What are the benefits of using the db2 database?
What is db2 optimizer?
How connect db2 database to datastage?
How do I delete a column in db2?
How do I add a column in db2?
Explain the contention situations caused by locks?
How would you find out the total number of rows in a db2 table?