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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is concurrency?

902


Why do we use cursor?

788


How does a cursor work?

742


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

814


What is the use of commit in db2?

809


If I have a view which is a join of two or more tables, can this view be updateable?

893


Mention the different locking levels that are available in db2.

839


What is the difference between using bind () and rebind () methods of naming class?

1063


How to find the number of rows in a db2 table?

842


What is iseries database?

777


Explain the benefits you can get from mainframe connect?

721


What is syscat in db2?

768


What is host variable in db2 cobol?

799


What is query_cache_limit?

743


What is package in db2 mainframe?

725