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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Foreign Key?

658


Mention the definition of cobol in varchar field.

700


How do I delete a table in db2?

651


What are db2 tables?

649


What is db2 and what is the use of db2 optimizer?

655






What is the difference between cursor stability and repeatable read isolation levels?

686


What is bind plan?

613


When do you specify the isolation level?

609


What is the function of logging in the db2 database?

645


Give a brief description of db2 isolation levels?

602


What is the purpose of using commit?

618


How to fetch the last row from the table in SQL (db2)?

1041


What is clone table?

592


List out the data types available.

704


What is collection in db2 bind?

577