The name of the entity type in the data model that this table logically represents. This is a read only in the Data Structure List.
This is the database for which this table is implemented.
You cannot change which database implements this table in the Data Structure List. (If you need to change this, go to the Data Store List.)
The database name is a maximum of 8 characters.
A name that is consistent for the implemented entity type throughout all of the technical designs. It is called generic because it is not DBMS specific.
The generic name can be no more that 18 characters long.
Change this name if you want the name of this table to be consistent throughout all of the technical designs, regardless of DBMS.
Used by the specific DBMS generation to identify a table.
CA Gen uses the table name as the default table name, unless otherwise specified here or in the data model. If this name is changed in the data model, each time a transformation is made you would not have to change the name.
The DBMS table name can be no more than 30 characters long in the CA Gen model. Certain databases, however, only allow a maximum of 18 characters. Do not exceed 18 characters unless you are certain your database supports it.
Specifies your name or ID. The DDL uses this owner during processing.
Select from the following options:
Select this option if you want the permitted value enforcement to be handled at the database level.
Select this option if you want the permitted value enforcement for table reads to be handled at the table level and you want the DBMS to do the enforcement.
By enabling the DBMS to control the permitted value enforcement, you are requiring all application (CA Gen or not) that will be reading this table to adhere to the same permitted value rules.
Select this option if you want the permitted value enforcement to be handled at the table level and you want CA Gen to do the enforcement.
This is a good selection if there are no permitted values in the table, or if you do not want the DBMS to enforce the permitted values for READ statements.
Permitted Value Default Enforcement-Creates/Updates-Select from the following options:
Select this option if you want the permitted value enforcement to be handled at the database level.
Select this option if you want the permitted value enforcement for row creates and updates to be handled at the table level and you want the DBMS to do the enforcement.
By enabling the DBMS to control the permitted value enforcement, you are requiring all application (CA Gen or not) that will be creating or updating rows in this table to adhere to the same permitted value rules.
Select this option if you want the permitted value enforcement to be handled at the table level and you want CA Gen to do the enforcement. This is a good selection if there are no permitted values in the table, or if you do not want the DBMS to enforce the permitted values for create or and update statements.
Freeform text documentation about the table.
Keep information about changes that have been made to this table in technical design. Although CA Gen knows these changes, you may want to know what changes were made in case the table is retransformed.
Note: Remember that this description will be eliminated when this table is transformed again (either by transformation or retransformation).
Other than these properties, each table contains a number of details that are specific to target DBMS implementations. The default settings are usually sufficient for unit testing; they need not be considered until volume or integration testing begins.
|
Copyright © 2013 CA.
All rights reserved.
|
|