What is the logical entity between plan and Package?

Answer Posted / kamal

plan is an optimized access path,but it is an executable component,package contains optimized access path,which is generated by optimizer of bind & it is a non-executable component.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is diffrence b/w file-aid tool and file-aid utility???

4170


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

694


What is bind and rebind in db2?

646


What are the benefits of using the db2 database?

658


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

648






Explain about rct.

644


How to rename a table in DB2 ?

635


Comment whether the cursor is closed during commit or not.

665


B37 abend during spufi?

978


How and when does the db2 enforces the unique key?

611


What is image copy in db2?

564


How would the varchar column remarks defined?

631


Where can you declare a cursor in a cobol-db2 program?

602


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

644


What is the function of logging in the db2 database?

638