what is the input to PLAN?
what is the input to DBRM?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is declare cursor?

801


What is dbrm? When it will be created?

761


What is the role of data manager in the db2 database?

827


What is innodb buffer pool?

728


How to access db2 tables in mainframe?

784






What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

932


What is the difference between bind and rebind in db2?

1154


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

798


How do I optimize a query in db2?

802


Which isolation level provides highest data integrity?

796


Which component is responsible for db2 startup and shutdown?

790


How would you find out the total number of rows in a db2 table?

763


What is an instance in db2?

733


Which isolation level provides maximum concurrency?

873


How can deadlocks be resolved?

708