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 / sampath
1 DBRM, 1 Package & 1 plan
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Mention the location where the output received from explain statement is stored.
What is the use of reorg in db2?
What is collection in db2 bind?
Is ibm db2 open source?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the use of db2?
What is check constraint. Explain with example.
Can there be more than one cursor open for any program?
Explain about open switch business continuity software?
What is an instance database?
How to test SQL -911 error while developing COB-DB2 program
What is rebind in db2?
What is db2 stogroup?
Why cursor is used in db2?