Creating SQL Objects › Creating a View › Naming the View

Naming the View

The name you give the view in the CREATE VIEW statement is the SQL name you use when referencing the view in SQL statements.

The unqualified view 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 qualified view name is the view name preceded by its schema and a period (.). The schema is represented by a valid authorization ID. Therefore, the qualified view name is in the format authid.view-name.

You can specify the authorization ID in the CREATE VIEW statement. If you do not specify an authorization ID, CA Datacom Datadictionary uses the current default authorization ID for the session.

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. However, you can establish an authorization ID that is the default for the current session. See Relating the Person to the AUTHID.

CA Datacom Datadictionary uses the authorization ID and the view's SQL name to build the VIEW entity-occurrence name, as follows:

• The period (.) separating the AUTHID and the SQL name is replaced with a dash (-).
• If the combination of the authorization ID, the SQL name and the dash 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.