Creating SQL Objects › Creating a Synonym › Naming the Synonym

Naming the Synonym

The name you give the synonym in the CREATE SYNONYM statement is the SQL name you use when referencing the synonym in SQL statements.

The SQL synonym name is:

• 1 to 18 characters in length if you want it to comply with ANSI or FIPS standards.
• 1 to 32 characters in length if you want to take advantage of the CA Datacom/DB extended mode for SQL.

The CREATE SYNONYM statement syntax does not allow you to specify an authorization ID before the synonym name. Since you cannot specify an authorization ID, CA Datacom Datadictionary uses the current default authorization ID.

The default authorization ID is the AUTHORIZATION occurrence related to the PERSON occurrence of the user ID entered to sign on to CA Datacom Datadictionary or the current authorization ID established with the SET AUTHID function. See Relating the Person to the AUTHID.

Since you cannot prefix the synonym name with an authorization ID in the CREATE SYNONYM statement, CA Datacom Datadictionary automatically prefixes the synonym name with the current authorization ID for the online session. If the combined authorization ID and synonym name is greater than the maximum allowed length of 32 characters, CA Datacom Datadictionary truncates the concatenated name.

If the truncated name already exists, CA Datacom Datadictionary truncates it by four more characters and adds four zeros to the end of the name. CA Datacom Datadictionary increments the digits by 1 until the name is unique.