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
- 27109 Views
- I also Faced
- E-Mail Answers
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
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
When reorg is used?
What is the syntax for creating a table in the db2 database?
What is the use of runstats in db2?
What is cascading rollback?
What is rebind in db2?
What are the contents of a dclmgen?
How connect db2 database to datastage?
Mention the various locks that are available in db2.
What is dclgen in db2?
What is the max length of sqlca?
What is null in db2?
What is check constraint. Explain with example.
How can the duplicate values be eliminated from db2 select?
Define predicate?
