Use the following steps to rebind 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. Select Option 3 (REBIND 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 REBIND PLAN Panel appears. After reading the list below, complete your entries on the panel and press PF9 (EXECUTE) to execute your request.
The options for the plan are displayed on the panel.
=> => => ------------------------------------------------------------------------------- Interactive SQL Service Facility SQLADMIN REBIND PLAN PANEL S03U ENTER PLAN NAME TO REBIND : __________________ ENTER AUTHORIZATION-ID: __________________ PLAN OPTIONS CBSIO : ______ (between 0 and 524287) MSG-PREP: _ (N,S or D) PRIORITY: __ (between 1 and 15) MSG-EXEC: _ (N,S or D) TIMEMIN : ___ (between 0 and 120) PLNCLOSE: _ (T or R) TIMESEC : ___ (between 0 and 120) PLNISOLA: _ (U,C or R) SQLMODE : ________ (DATACOM, ANSI, FIPS) PLNJOVRD: _ (M,P or E) PLNWKSP : ____ (between 0 and 0128K) PLNDATE : _ (0 thru 4) PLNTIME : _ (0 thru 4) PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
(Required) Specify the name of the plan you want to rebind. This is the name specified in the SQL PLANAME= option or the PROGRAM-ID value in the application program. See Naming the Plan.
1- to 18-character plan name
(No default)
(Optional) Specify the authorization ID which owns the plan you are rebinding. 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 make certain you are rebinding the right plan, specify the authorization ID on this panel if you do not know the default for the current online session.
1- to 18-character authorization ID
Default authorization ID for current session
The options you can specify in the rebind of this plan are shown on the panel. See Coding Plan Options for an explanation of the valid entries.
Step 5
When you successfully execute the request, CA Datacom Datadictionary returns a message to the panel naming the plan and the authorization-ID. The AUTHID 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 REBIND PLAN PANEL S03U ENTER PLAN NAME TO REBIND : PLANB ENTER AUTHORIZATION-ID: JONES . SUCCESSFUL REBIND OF PLAN PLANB AUTHID=JONES PLAN OPTIONS CBSIO : ______ (between 0 and 524287) MSG-PREP: _ (N,S or D) PRIORITY: __ (between 1 and 15) MSG-EXEC: _ (N,S or D) TIMEMIN : ___ (between 0 and 120) PLNCLOSE: _ (T or R) TIMESEC : ___ (between 0 and 120) PLNISOLA: _ (U,C or R) SQLMODE : ________ (DATACOM, ANSI, FIPS) PLNJOVRD: _ (M,P or E) PLNWKSP : ____ (between 0 and 0128K) PLNDATE : _ (0 thru 4) PLNTIME : _ (0 thru 4) 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 rebinding the plan, you can:
Note: If you press Enter instead of PF9 (EXECUTE), the values for each option the plan currently has are displayed. If you press Enter instead of PF9 (EXECUTE) after making a change to any option, the current option is redisplayed.
|
Copyright © 2014 CA.
All rights reserved.
|
|