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?
Answer Posted / lu
when u bind , 5 queries has 5 sql statements in 1 DBRM, its
regroup into 1 package, 1 plan...Plan is a collection of
packages..
correct me if i'm wrong..
| Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
What is temporal table in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the maximum No of rows per page?
What is a bind card?
How does a cursor work?
what is the responsibility of the construction superintendent
What is the physical storage length of timestamp data type?
Comment whether the cursor is closed during commit or not.
What is ibm db2 used for?
How to test SQL -911 error while developing COB-DB2 program
How do you simulate the explain of an embedded sql statement in spufi/qmf?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What are catalog tables in db2?
What is the purpose of using commit?
What is a db2 cursor?