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 / keshireddy
further, multiple primary keys can be updated at time. Only
condition is that value should be unquie. else sql code -803
| Is This Answer Correct ? | 18 Yes | 0 No |
Post New Answer View All Answers
What are the contents of dclgen?
Which component is responsible for processing sql statements and selecting access paths?
List out the three types of page locks that can be held.
Explain what are the various isolation levels possible?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How does cobol compile db2 program?
What is a db2 package?
what is the sqlcode -501
What is the role of data manager in the db2 database?
Explain about rct.
Who uses db2?
Define db2.
Are view updateable?
what is the responsibility of the construction superintendent
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE