Advantages:
► Speed of access is faster because of the predefined data paths.
Disadvantages:
► Complex implementation
► Predefined tree structure reduces flexibility.
► Difficult to manage
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. TIA
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?
What is DCLGEN ?
Can GROUP BY and ORDERED BY used in a single query?
EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?
When DB2 connection fails, will online program work or give errors?
Can you have more than one cursor open at any one time in a program ?
How does DB2 determine what lock-size to use?
What is a composite index and how does it differ from a multiple index?
What are delete-connected tables?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
