Use the following steps to set the default authorization ID for a session.
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).
=> => => ------------------------------------------------------------------------------- Interactive SQL Service Facility Enter desired option number ===> __ (There are 05 options on the menu) 1. SQLMAINT SQL member maintenance/execution 2. SQLADMIN SQL administrative functions 3. SET MODE Reset Datadictionary processing mode 4. IDEAL Transfer to IDEAL application 5. OFF End session
Note: If CA Ideal is not installed on your system, the OFF option appears in place of the CA Ideal option on the panel.
Step 3
CA Datacom Datadictionary displays the Interactive SQL Service Facility SQLADMIN Panel with four menu options. Select Option 1 (SET AUTHID).
=> => => ------------------------------------------------------------------------------- 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 AUTHORIZATION-ID Panel appears. After reading the following information, complete your entry on the panel and press PF9 (EXECUTE). To change to the default authorization ID, press PF9 (EXECUTE) without placing an entry on the panel.
=> => => ------------------------------------------------------------------------------- Interactive SQL Service Facility SQLADMIN S03U AUTHORIZATION-ID 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
Note: If your terminal displays 24 lines, you must scroll forward to display the last line containing the descriptions of PF9 (EXECUTE) through PF12 (ALTERNATE).
(Optional) Enter the authorization ID which you want as the default for this session of the Interactive SQL Service Facility.
If you leave this field blank, CA Datacom Datadictionary resets the current authorization ID to the default which was in effect when you signed on or that you established with the RESET DEFAULT AUTHID command (see Changing Your AUTHID).
1- to 18-character authorization ID
Authorization ID in effect at signon
Step 5
When you successfully execute the request, CA Datacom Datadictionary returns a message to the panel naming the default authorization ID in effect. In this example, the default authorization is set to JONES.
=> => => ------------------------------------------------------------------------------- Interactive SQL Service Facility SQLADMIN S03U AUTHORIZATION-ID ENTER AUTHORIZATION-ID: JONES_____________ AUTHORIZATION-ID IS NOW 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
To exit this panel, you can:
|
Copyright © 2014 CA.
All rights reserved.
|
|