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 the max length of sqlca?

770


How do I delete a column in db2?

686


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1628


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2759


What is db2?

747






Is db2 a mainframe database?

569


What is buffer pool?

619


What is multi row fetch in db2?

614


How and when does the db2 enforces the unique key?

619


What is runstats and reorg in db2?

802


What types of tables are there in the db2 database?

559


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

1043


What is ibm db2 used for?

605


What is null value in db2?

571


i want to maintain uniqueness on pdf without make lf??????????

1638