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
What is db2 instance?
Explain the benefits you can get from mainframe connect?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is the difference between db2 and oracle?
What are the bind parameters ibm db2?
How can you do the explain of a dynamic sql statement?
What is null indicator in db2?
What is bind and rebind in db2?
Describe major components of db2?
Explain in brief how does db2 determine what lock-size to use?
What is package in cobol db2?
What is rebind in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
How is the value function used?
What is a db2 collection?