⟩ Explain the main control blocks available in IMS DB?
There are three control blocks (also known as DL/I control blocks)
► Database Description (DBD)
► Program Specification Block (PSB)
► Application Control Block (ACB)
There are three control blocks (also known as DL/I control blocks)
► Database Description (DBD)
► Program Specification Block (PSB)
► Application Control Block (ACB)
could you give me an example how, where i code CHECKPOINT and restart. I need and example
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?