Performing SQL Administrative Tasks › Deleting a Plan › How to Delete a Plan

How to Delete a Plan

Use the following steps to delete a plan.

Step 1

When you sign on or select the SET MODE function, CA Datacom Datadictionary displays the Datadictionary Mode Select Panel. Select Option 7 or enter the SET MODE SQL command.

Step 2

On the Interactive SQL Service Facility Panel, select Option 2 (SQLADMIN).

Step 3

CA Datacom Datadictionary displays the Interactive SQL Service Facility SQLADMIN Panel with five menu options. Select Option 2 (DELETE PLAN).

 =>
 =>
 =>
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLADMIN
 
 Enter desired option number ===> __    (There are 05 options on the menu)
  1. SET AUTHID                   Set default AUTHID for session
  2. DELETE PLAN                  Delete SQL plan
  3. REBIND PLAN                  Rebind SQL plan
  4. DISPLAY PLAN                 Display index of SQL plans
  5. END                          End SQLADMIN processing

Step 4

The DELETE PLAN Panel appears. After reading the list below, complete your entries on the panel and press PF9 (EXECUTE) to execute your request.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLADMIN
 
                             DELETE  PLAN PANEL                             S03U
 
 
 
 ENTER PLAN NAME TO  DELETE : __________________
 ENTER AUTHORIZATION-ID:    __________________
 
 
 
 
 
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

ENTER PLAN NAME TO DELETE

(Required) Specify the name of the plan you want to delete. This is the name specified in the SQL PLANAME= option or the PROGRAM-ID value in the application program.

Valid Entries:

1- to 18-character plan name

Default Value:

(No default)

ENTER AUTHORIZATION-ID

(Optional) Specify authorization ID which owns the plan you are deleting.

If you do not specify the authorization ID, CA Datacom Datadictionary uses the default authorization ID for the current online session.

It is possible for different authorization IDs to have a plan with the same name. To be certain you are deleting the right plan, specify authorization ID on this panel if you do not know the default for current online session.

Valid Entries:

1- to 18-character authorization ID

Default Value:

Default authorization ID for current session

Step 5

When you successfully execute the request, CA Datacom Datadictionary returns a message to the panel naming the plan and the authorization-ID, which is either the one you specified on the panel or the default for the session if you left that field blank.

 =>
 =>
 =>
 
 -------------------------------------------------------------------------------
 Interactive SQL Service Facility                                       SQLADMIN
 
                             DELETE  PLAN PANEL                             S03U
 
 
 
 ENTER PLAN NAME TO  DELETE : PLANA_____________
 ENTER AUTHORIZATION-ID:    __________________
 SUCCESSFUL DELETE OF PLAN PLANA              AUTHID=JONES
 
 
 
 
 
 
 
 PF1=HELP         PF2=END         PF3=SPLIT         PF4=PROCESS
 PF5=TOP          PF6=BOTTOM      PF7=BACKWARD      PF8=FORWARD
 PF9=EXECUTE      PF10=LEFT       PF11=RIGHT        PF12=ALTERNATE

After successfully deleting the plan, you can:

• Press PF2 (END) to display the Interactive SQL Service Facility SQLADMIN Panel.
• Press the CLEAR key to return to the Interactive SQL Service Facility Panel where you can choose another option.