The following table describes the technical design objects:
|
Object Type |
Property Type |
Name Uniqueness Rule |
Length |
Character Set Rule |
|---|---|---|---|---|
|
TECHNICAL DESIGN DEFAULT |
RITRIGNM |
Unique within all online load modules, window load modules, batch job steps, implementation logics, external implementation logics, and implementation screens |
8 |
No NLS Rule |
|
DATABASE |
NAME |
Unique within all base database objects and unique within all extended database objects types that the base database does not extend to. |
8 |
No Underscore TD Rule |
|
DATABASE DB2 z/OS EXTENSION |
NAME |
Unique within all database DB2 z/OS extension objects and unique within all base database objects that do not extend to a database DB2 z/OS extension object |
8 |
No Underscore TD Rule |
|
DATABASE DB2 UDB EXTENSION |
NAME |
Unique within all database DB2 UDB extension objects and unique within all base database objects that do not extend to a database DB2 UDB extension object |
8 |
TD Rule |
|
DATABASE MS SQL SERVER EXTENSION |
NAME |
Unique within all database MS SQL Server extension objects and unique within all base database objects that do not extend to a database MS SQL Server extension object |
30 |
Mixed Case TD Rule |
|
DATABASE ORACLE EXTENSION |
NAME |
Unique within all database Oracle extension objects and unique within all base database objects that do not extend to a database Oracle extension object |
8 |
Oracle TD Rule |
|
DATABASE ODBC EXTENSION |
NAME |
Unique within all database ODBC extension objects and unique within all base database objects that do not extend to a database ODBC extension object |
32 |
ODBC TD Rule |
|
DATABASE NonStop SQL/MP EXTENSION |
NAME |
Unique within all database NonStop SQL/MP extension objects and unique within all base database objects that do not extend to a database NonStop SQL/MP extension object |
8 |
Identifier Rule |
|
DATA/ DENORMALIZED/ FOREIGN KEY COLUMN
|
MACRONAM |
Unique within all base data/denormalized/foreign key columns in the table and unique within all extended data/denormalized/foreign key columns in the table that the base data/denormalized/foreign key column does not extend to |
30 |
TD Rule |
|
DATA/ DENORMALIZED/ FOREIGN KEY COLUMN DB2 z/OS EXTENSION
|
NAME |
Unique within all data/denormalized/foreign key column DB2 z/OS extension objects in the table and unique within all names of base data/denormalized/ foreign key columns that do not extend to a data/ denormalized/foreign key DB2 z/OS extension object |
30 |
TD Rule |
|
DATA/ DENORMALIZED/ FOREIGN KEY COLUMN DB2 UDB EXTENSION
|
NAME |
Unique within all data/denormalized/foreign key column DB2 UDB extension objects in the table and unique within all names of base data/ denormalized/foreign key columns that do not extend to a data/denormalized/foreign key DB2 UDB extension object |
30 |
TD Rule |
|
DATA/ DENORMALIZED/ FOREIGN KEY COLUMN MS SQL SERVER EXTENSION
|
NAME |
Unique within all data/denormalized/foreign key column MS SQL Server extension objects in the table and unique within all names of base data/ denormalized/foreign key columns that do not extend to a data/denormalized/foreign key MS SQL Server extension object |
30 |
Mixed Case TD Rule |
|
DATA/ DENORMALIZED/ FOREIGN KEY COLUMN ORACLE EXTENSION
|
NAME |
Unique within all data/denormalized/foreign key column Oracle extension objects in the table and unique within all names of base data/denormalized/ foreign key columns that do not extend to a data/ denormalized/foreign key Oracle extension object |
30 |
Oracle TD Rule |
|
DATA/ DENORMALIZED/ FOREIGN KEY COLUMN ODBC EXTENSION
|
NAME |
Unique within all data/denormalized/foreign key column ODBC extension objects in the table and unique within all names of base data/denormalized/ foreign key columns that do not extend to a data/ denormalized/foreign key ODBC extension object |
32 |
ODBC TD Rule |
|
DATA/ DENORMALIZED/ FOREIGN KEY COLUMN JDBC EXTENSION
|
NAME |
Unique within all data/denormalized/foreign key column JDBC extension objects in the table and unique within all names of base data/denormalized/ foreign key columns that do not extend to a data/ denormalized/foreign key JDBC extension object |
32 |
ODBC TD Rule |
|
DATA/ DENORMALIZED/ FOREIGN KEY COLUMN NonStop SQL/MP EXTENSION
|
NAME |
Unique within all data/denormalized/foreign key column NonStop SQL/MP extension objects in the table and unique within all names of base data/denormalized/ foreign key columns that do not extend to a data/ denormalized/foreign key NonStop SQL/MP extension object |
30 |
Identifier Rule |
|
DATA/LINK TABLE |
MACRONAM |
Unique within all base data/link tables and unique within all names of extended data/link tables that the base data/link table does not extend to |
32 |
TD Rule |
|
DATA/LINK TABLE DB2 z/OS EXTENSION |
NAME |
Unique within all data/link table DB2 z/OS extension objects and unique within all names of base data/link tables that do not extend to a data/link table DB2 z/OS extension object |
32 |
TD Rule |
|
DATA/LINK TABLE DB2 UDB EXTENSION |
NAME |
Unique within all data/link table DB2 UDB extension objects and unique within all names of base data/link tables that do not extend to a data/link table DB2 UDB extension object |
32 |
TD Rule |
|
DATA/LINK TABLE MS SQL SERVER EXTENSION |
NAME |
Unique within all data/link table MS SQL Server extension objects and unique within all names of base data/link tables that do not extend to a data/link table MS SQL Server extension object |
30 |
Mixed Case TD Rule |
|
DATA/LINK TABLE MS SQL SERVER EXTENSION |
RINAME |
Unique within all data/link table MS SQL Server extension objects |
26 |
Mixed Case TD Rule |
|
DATA/LINK TABLE ORACLE EXTENSION |
NAME |
Unique within all data/link table Oracle extension objects and unique within all names of base data/link tables that do not extend to a data/link table Oracle extension object |
30 |
Oracle TD Rule |
|
DATA/LINK TABLE ODBC EXTENSION |
NAME |
Unique within all data/link table ODBC extension objects and unique within all names of base data/link tables that do not extend to a data/link table ODBC extension object |
32 |
ODBC TD Rule |
|
DATA/LINK TABLE ORACLE EXTENSION |
RINAME |
Unique within all data/link table Oracle extension objects |
30 |
Oracle TD Rule |
|
DATA/LINK TABLE JDBC EXTENSION |
NAME |
Unique within all data/link table JDBC extension objects and unique within all names of base data/link tables that do not extend to a data/link table JDBC extension object |
32 |
ODBC TD Rule |
|
DATA/LINK TABLE NonStop SQL/MP EXTENSION |
NAME |
Unique within all data/link table NonStop SQL/MP extension objects and unique within all names of base data/link tables that do not extend to a data/link table NonStop SQL/MP extension object |
23 |
Identifier Rule |
|
ENTRY POINT |
NAME |
1) Unique within all base entry points in the database and 2) unique within all base tablespaces in the database and 3) unique within all extended entry point types in the database that the base entry point does not extend to and 4) unique within all equivalent extended tablespace types in the database that the base entry point does not extend to
|
32 |
No Underscore TD Rule |
|
ENTRY POINT DB2 z/OS EXTENSION |
NAME |
1) Unique within all entry point DB2 z/OS extension objects in the database and 2) unique within all tablespace DB2 z/OS extension objects in the database and 3) unique within all base entry point objects in the database that do not extend to an entry point DB2 z/OS extension object 4) unique within all base tablespace objects in the database that do not extend to a tablespace DB2 z/OS extension object
|
32 |
No Underscore TD Rule |
|
ENTRY POINT DB2 UDB EXTENSION |
NAME |
1) Unique within all entry point DB2 UDB extension objects in the database and 2) unique within all tablespace DB2 UDB extension objects in the database and 3) unique within all base entry point objects in the database that do not extend to an entry point DB2 UDB extension object 4) unique within all base tablespace objects in the database that do not extend to a tablespace DB2 UDB extension object
|
18 |
TD Rule |
|
ENTRY POINT MS SQL SERVER EXTENSION |
NAME |
1) Unique within all entry point MS SQL Server extension objects in the database and 2) unique within all base entry point objects in the database that do not extend to an entry point MS SQL Server extension object
|
30 |
Mixed Case TD Rule |
|
ENTRY POINT ORACLE EXTENSION |
NAME |
1) Unique within all entry point Oracle extension objects in the database and 2) unique within all tablespace Oracle extension objects in the database and 3) unique within all base entry point objects in the database that do not extend to an entry point Oracle extension object 4) unique within all base tablespace objects in the database that do not extend to a tablespace Oracle extension object
|
32 |
Oracle TD Rule |
|
ENTRY POINT ODBC EXTENSION |
NAME |
1) Unique within all entry point ODBC extension objects in the database and 2) unique within all base entry point objects in the database that do not extend to an entry point ODBC extension object |
32 |
ODBC TD Rule |
|
ENTRY POINT JDBC EXTENSION |
NAME |
1) Unique within all entry point JDBC extension objects in the database and 2) unique within all base entry point objects in the database that do not extend to an entry point JDBC extension object
|
32 |
ODBC TD Rule |
|
ENTRY POINT NonStop SQL/MP EXTENSION |
NAME |
1) Unique within all entry point NonStop SQL/MP extension objects in the database and
2) unique within all base entry point objects in the database that do not extend to an entry point NonStop SQL/MP extension object
|
23 |
Identifier Rule |
|
STORAGE GROUP |
NAME |
Unique within all storage groups |
8 |
No Underscore TD Rule |
|
TABLESPACE |
NAME |
1) Unique within all base tablespaces in the database and 2) unique within all base entry points in the database and 3) unique within all extended tablespace types in the database that the base tablespace does not extend to and 4) unique within all equivalent extended entry point types in the database that the base tablespace does not extend to
|
8 |
No Underscore TD Rule |
|
Copyright © 2014 CA.
All rights reserved.
|
|