Answer Posted / ekalavya
USE AS MANY COMMITS IN THE PROGRAM.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to create backup table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Before you give the explain statement, what are the prerogatives?
Mention the downsides of page level lock.
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
Is the primary key a clustered index?
Why cursor is used in db2?
Give a brief description of db2 isolation levels?
What is a system catalog table in db2?
What is database manager in db2?
What is explain in db2?
What is view db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Can we insert update delete in view?
Explain package in db2 and its advantages?