(Executable only from DBSQLPR.)
A plan is the representation in SQL of an SQL application and, unless removed with the DROP PLAN statement, can continue to occupy table space long after the application has been retired. When you drop a plan, make certain that the plan is not related to an SQL application that is still in use.
We recommend that you do not use DROP PLAN to drop plans related to procedures. and functions. Use the DROP PROCEDURE statement and DROP FUNCTION statements to drop procedures. and functions.
The syntax for the DROP PLAN statement is as follows.
Note: The DROP PLAN statement is executable only from DBSQLPR, but it can also be submitted as a DBSQLPR in-line command (see Line Commands).
►►─ DROP PLAN ─┬────────────┬─ plan-name ─────────────────────────────────────►◄ └─ auth-id. ─┘
(Optional) The auth-id. is the authorization ID, followed by a period, related to the plan name that you want to drop.
a valid authorization ID
(No default)
The plan-name is the name of the plan that you want to drop.
a valid plan name
(No default)
|
Copyright © 2014 CA.
All rights reserved.
|
|