Interested to Buy Any Domain ? << Click Here >> for more details...
what is the input to PLAN?
what is the input to DBRM?
- 4 Answers
- 10671 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harish
dbrm or package is input to plan....talking abt
dbrm.......the cobol+db2 prgrm is input to precompiler which
separtes cobol souce code and dbrm
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / mani
DBRMs and Packages are the input to the plan as said above.
The input to DBRM is the sql statements in the cobol db2
program
i.e all the sql statements in the cobol db2 program will be
replaced by the host language statements in this case it is
cobol and the sql statements are bound into DBRMs.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / guest
The input to a plan is a DBRM or package. The DBRM is a
copy of the SQL statements of the program that is being
prepared.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / anil reddy
DBRM-Caontains SQL statments seperated from your host
laguae bt Precompiler.
PLAN-Is the generated by BIND process , which will contain
Excutale cde for SQL statements in the DBRM.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is a plan and how do you refer the plan in the program?
In terms of DB2 indexing, what is the root page?
What is database alias db2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
Suppose if I need to update a column, how you do that using cursor?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
Are views updateable?
What is dbrm?
Can we delete records from view?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
COBOL 
