Create/Edit Db2 synonym
The Create Synonym screen shown in the following figure is displayed when you enter the S (Select) line command on a Db2 synonym in the Target Environment screen. This screen lets you modify the create synonym information from the extract file to your new target environment.
Create Synonym
Command ===>
Source Object: SSID: DSN Location: DSNLOCAT
SQLID : FRSAMP
Synonym name : SYNCUSTOMER
Table name : FRSAMP.CUSTOMER_TABLE
Target Object: SSID: DSN Location: DSNLOCAT
Table Name ...: TSOID01.CUSTOMER_TABLE
SQLID ===> TSOID01
Synonym name ===> SYNCUSTOMER
Use this screen to update the Db2 synonym information. After you view or modify the synonym information, press END to return to the Target Environment.
Source Object
This section provides information about the following parameters:
SSID
Displays the Db2 subsystem ID of the “Source Environment”.
Location
Displays the remote Db2 location name of the “Source Environment”.
SQLID
Displays the SQL ID as extracted for the synonym.
Synonym name
Displays the synonym name as extracted.
Table name
Displays the table name of the extracted synonym name.
Target Object
This section provides information about the following parameters:
SSID
Displays the Db2 subsystem ID of the Target Environment.
Location
Displays the remote Db2 location name of the Target Environment.
Table name
Displays the target table name for the synonym.
SQLID
Specify the creator name for the new synonym name.
Synonym name
Specify the name for the synonym in the target environment.