This option enables you to specify additional synonyms by providing a list of the synonyms for the tables in the Extract File.
When you select Option 4 SYNONYMS on the CREATE Process menu, the CREATE Additional Synonyms panel is displayed. Assume the Extract File that has been specified contains six tables and the CREATE Additional Synonyms panel is displayed as shown in the following figure.
------------------------- CREATE Additional Synonyms---------------------------
Command ===> Scroll ===> PAGE
Use CREATE ALL Primary Command to Create all Selected Synonyms
Available Line Commands:
S - Select Synonym to be Created
U - Unselect Synonym to bypass Creation.
Synonym Owner ===> 1 of 7
Cmd Status Synonym Name Base Name
--- -------- --------------------- -----------------------------
*** **************************** TOP *****************************
___ SELECT S_CUSTOMERS FOPDEMO2.CUSTOMERS
___ UNSEL S_ORDERS FOPDEMO2.ORDERS
___ CONFLICT S_ORDS FOPDEMO2.ORDERS
___ EXISTS DETAILS FOPDEMO2.DETAILS
___ EXISTS ITEMS FOPDEMO2.ITEMS
___ SELECT V_SALES FOPDEMO2.V_SALES
___ SELECT V_SHIP_TO FOPDEMO2.V_SHIP_TO
*** ************************** BOTTOM ****************************
Review SQL before Create ===> _ (Y-Yes, N-No)
This panel includes:
When you are satisfied with your selections, use CREATE ALL.
SQLIf you have responded N to Review SQL before Create, the request is executed.
If you responded Y, the SQL is displayed for review in the ISPF editor. It can be modified and saved. Use END to execute the SQL. Use CANCEL to abandon execution of the SQL.
After the SQL is executed, the DB2® output is provided in a browse-only display. This output is in SPUFI-like format and includes the executed SQL statement, the DB2 SQLCODE, and any other pertinent execution information. (An example of the display is shown in Figure 3.)