Creating SQL Objects › Creating a Table › Naming the Table

Naming the Table

The name you give the table in the CREATE TABLE statement is the SQL name you use when referencing the table in SQL statements.

The unqualified SQL table name is:

• 1 to 18 characters in length (to comply with ANSI or FIPS standards), or
• 1 to 32 characters in length (to take advantage of the CA Datacom/DB extended mode for SQL).

The qualified table name is the table name preceded by its schema and a period (.). The schema is represented by a valid authorization ID. Therefore, the qualified table name is in the format authid.table-name.

You can specify the authorization ID in the CREATE TABLE 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 table's SQL name to build the TABLE 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.

You can change the table's CA Datacom Datadictionary entity-occurrence name by restoring it to TEST status and using one of the following CA Datacom Datadictionary rename functions:

• The UPDATE NAME option of the CA Datacom Datadictionary Entity Maintenance (ENTMAINT) Mode.
• The NAM or NME margin commands in the CA Datacom Datadictionary CA Datacom/DB Structure Maintenance (DBMAINT) Mode.
• The 1000 NEWNAME batch transaction.

If you rename the TABLE entity-occurrence, you must recatalog it to the CA Datacom/DB Directory (CXX).

Note: Before copying back to PRODuction status, drop the table that currently exists there.

See the CA Datacom Datadictionary Online Reference Guide and CA Datacom Datadictionary Batch Reference Guide for more information on renaming entity-occurrences.