DB2 graphic QMF Version 8

Prepare

Select Query--> Prepare to invoke the PREPARE SQL command. This command instructs DB2 to evaluate the query for the most efficient execution and then devise a plan for its execution.

The Prepare option is available for queries only in the SQL view.

The Set User Information dialog box opens after you select the PREPARE option. Type a valid user ID and password to prepare the query on the database.

During this operation:

If successful, an empty results set will be returned that shows all columns selected for the query.

Note:
An error message displays if the PREPARE function determines that the query contains errors. The message provides details of the error condition.

Later, when you run the prepared query, the prepared plan will be executed instead of developing a plan at run time.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004