Creating SQL Objects › Creating an Index › Naming the Index (Key)

Naming the Index (Key)

The name you place in the CREATE INDEX statement is the SQL name you use when referencing the key in SQL statements.

The unqualified SQL name is:

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

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

You can specify the authorization ID in the CREATE INDEX 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.