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 / srinivas chennareddy
As the name indicates DBRM(Data Base Replacement Module) is
for one module...irrespective of the number of SQL's in a
module/program...one DBRM will be created and it will be
bound to one package,and collection of all calling/called
module packages forms an application PLAN,which will be
loaded into main memory and executed during run time.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
what is utility for parm lib
Can we update view in db2?
How do you concatenate the firstname and lastname from emp table to give a complete name?
Which is faster delete or truncate?
What is cascading rollback?
What is database alias db2?
What is db2?
What is the use of db2 optimizer?
How to retrieve rows from a db2 table in embedded sql?
Why select is not preferred in embedded sql programs?
What is meant by union and union all?
Mention the location where the output received from explain statement is stored.
What are the benefits of using the db2 database?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How can you do the explain of a dynamic sql statement?