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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / satish k
One correction to the above. DBRM is DataBase Request
Module and not DataBase Replacement Module.
Is This Answer Correct ? | 10 Yes | 0 No |
Answer / ankur bhalla
1 DBRM(DATABASE REQUEST MODULE), 1 PACKAGE AND 1 PLAN.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Is db2 a programming language?
Where would you find information about the type of database authority held by the user?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th
What is an alias and how does it differ from a synonym?
What is the function of buffer manager?
Why do we use cursor?
how do u update the faltfile into db2 table ?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
define clustering index.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE