Interested to Buy Any Domain ? << Click Here >> for more details...
If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
- 8 Answers
- 18121 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / ankur bhalla
1 DBRM(DATABASE REQUEST MODULE), 1 PACKAGE AND 1 PLAN.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Name the various locking levels available?
Explain various types of locks in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What are the various isolation levels possible?
Explain the contention situations caused by locks?
What are db2 tables?
Define buffer pool.
Mention some fields that are a part of sqlca.
What is the latest version of ibm db2?
What is db2 bind process?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What is the syntax for creating a table in the db2 database?
What do you mean by rollback?
What is difference between isnull and coalesce?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
