Interested to Buy Any Domain ? << Click Here >> for more details...
What is a DBRM, PLAN ?
- 3 Answers
- 18394 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mehdee
The above answer is right, but the 2nd part should change
to: PLAN is an executable module containing the access path
logic to one or more DBRMs and packages.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / kundan kumar
DBRM :-database request module(DBRM) , they are created after the
pre-compilation is performed. It contains parsed SQL statements.
PLAN :- PLAN is an executable module containing the access path
logic to one or more DBRMs and packages created after bind process .
| Is This Answer Correct ? | 0 Yes | 0 No |
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is phantom read in db2?
What is a DB2 plan?
What are concurrency issues?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What will the DB2 optimizer do?
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What information is used as input to the bind process?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Which is faster delete or truncate?
COBOL 
