How Plan is created while executing the query using SPUFI?

Answer Posted / arun chinnadurai

A package/plan is created is created for DB2I tools and the
authorization to execute that plan is given to Public.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain dclgen.

935


B37 abend during spufi?

1213


What is the difference between plan and package in db2?

832


What is the cobol picture clause of the db2 data types date, time, timestamp?

835


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1969


What is collection in db2 bind?

772


What is dbrm in db2 database?

790


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

939


Mention the various locks that are available in db2.

790


How to get the ddl of a table in db2?

862


What is the clustering index in the db2 database?

749


What is database manager in db2?

757


What is the usage of open cursor command?

785


What is cursor stability in db2?

1051


What is db2 instance?

797