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

File-AID/RDX ---------------- 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.