The following example shows the Output Panel received when executing the previous CREATE SYNONYM statement.
=> => => --------------------------------------------------------------------------- >>> Interactive SQL Service Facility SQLMAINT Output Panel S01O EDIT Member= PROJSYN Description: CREATE SYNONYM PROJECTTBL ------------------------------------------------------------------------------- ====== ========================== T O P ======================================= 000001 (OUTPUT CREATED FROM SOURCE MEMBER PROJSYN ) 000002 create synonym projects for ted.projecttbl; 000003 ---------+---------+---------+---------+---------+---------+---------+-- 000004 STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 000005 ---------+---------+---------+---------+---------+---------+---------+-- 000006 SQL STATEMENTS ASSUMED TO BE BETWEEN COLUMNS 1 AND 72 000007 NUMBER OF INPUT RECORDS READ IS 0001 000008 NUMBER OF SQL STATEMENTS PROCESSED IS 0001 ====== ======================= B O T T O M ==================================== PF1=HELP PF2=END PF3=SPLIT PF4=PROCESS PF5=TOP PF6=BOTTOM PF7=BACKWARD PF8=FORWARD PF9=EXECUTE PF10=LEFT PF11=RIGHT PF12=ALTERNATE
This example of creating a synonym defines an alternative name, PROJECTS, for the PROJECTTBL table listed in the schema that has the authorization ID of TED. The synonym is listed in the schema with the authorization ID of JONES.
To exit from the Output Panel, you can perform one of the following:
|
Copyright © 2014 CA.
All rights reserved.
|
|