Naming conventions for Database IDs, Area names, and Table IDs

Document ID : KB000108587
Last Modified Date : 30/07/2018
Show Technical Document Details
Question:
Is there a way to find the guidelines for naming conventions of CA Datacom Database IDs, Area names, and Table IDs?
Answer:
In general, any specific questions about various attributes and their values can be answered by looking at the Datadictionary Attribute Types Reference information in CA DocOps.

For database IDs, this is in the section of DATABASE Attribute-types, for DATACOM-ID:
A 5-digit ID for the database (also known as the DBID). The ID must be unique within the status. This ID is stored in the CA Datacom®/DB Directory (CXX) and is used by CA Datacom®/DB to identify a database.

Database IDs over 999 have a few special considerations:
  • If you have databases with IDs greater than 999 and want to secure them, you must use an external security package (CA ACF2, CA Top Secret, or IBM's RACF). You cannot use CA Datacom®/DB internal (or kernel) security for these databases. External security fully supports all database IDs.
  • Databases 1000, 2000, 3000, 4000, and 5000 have the rules of global databases. Other databases (such as 1001 through 1999, and so on) have the rules of 1 through 999.
  • You cannot change the CA Datacom® Datadictionary™ databases (the DATA-DICT and DDD-DATABASE which are IDs 2 and 15 when you first install CA Datacom®/DB) to IDs greater than 999.
  • For CA Dataquery™ for CA Datacom®, if you have tables in databases with IDs greater than 999 that need to be secured, then you must use external security. CA Dataquery™ for CA Datacom® cannot access a table in a database that is greater than 999, unless the database is externally secured.
  • The CA Datacom® CICS Services supports User Requirements Table (URT) numbers of 0 through 999. Therefore, if you use database IDs greater than 999, you cannot match URT numbers with those database IDs.
Restrictions:
Database IDs 00001 -- 00020, 1000 -- 1020, 2000 -- 2020, 3000 -- 3020, 4000 -- 4020, and 5000 are reserved for CA.

Length:         5
Valid Entries:  00001 to 0000 - leading zeros may be omitted.
Default Value:  (No default)

Area name information is in the section AREA Attribute-Types, for DATACOM-NAME:
The 3-character CA Datacom®/DB short name for the area. CA Datacom®/DB uses this name to identify the area.

Requirements:
  • This attribute-value must be unique among the areas in a DATABASE structure in a specific status/version and cannot contain leading, embedded, or trailing blanks (X'40').
  • The first byte must be alphabetic. The second and third bytes can be alphanumeric. Do not enter XX as the last two bytes. If the last two bytes are XX, the CATALOG or VERIFY function will result in a warning message.
Length:         3
Valid Entries:  Unique 3-character name
Default Value:  (No default)


The Table name is found in the TABLE Attribute-types, for DATACOM-NAME:
Enter a 3-character CA Datacom®/DB short name for the TABLE occurrence. For tables created within the Interactive SQL Service Facility, CA Datacom® Datadictionary™ creates this name.

Requirements
  • It cannot contain leading, embedded or trailing blanks (X'40').
  • The first byte must be alphabetic.
  • The second and third byte must be alphanumeric.
Restrictions
  • The DATACOM-NAME attribute-value must be unique among the tables in a DATABASE structure in a specific status/version.
  • If the last two bytes are XX, a warning is issued with the VERIFY or CATALOG function. This does not stop a database from being cataloged.
  • If the table has constraints, updating this attribute-value can affect the constraint.
Length:          3
Valid Entries:   3  characters
Default Value:  (No default)
Additional Information:
The Datadictionary Attribute Types Reference information in CA DocOps contains a wealth of information about Datadictionary entity attribute values. For more information, please refer to this documentation.

Version 15.1 - Datadictionary Attribute Types Reference
Version 15.0 - Datadictionary Attribute Types Reference

As always, please contact CA Technologies support for CA Datacom if you have further questions.