Previous Topic: TECH_DESN_STG_TS (Technical Design Default Tablespace Storage Group)Next Topic: TECHNICAL_DESIGN


TECHNICAL_DES_I (Technical Design)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

TECHNICAL_DES_I

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

NAME

STRING

Name of the technical design

DBMS

CHARACTER

Data base management system:

  • 2-DB2 z/OS
  • B-ODBC/ADO.NET
  • C-MS/SQL
  • E-DB2 UDB
  • H-NONE
  • J-JDBC

RESERVED_WORD

CHARACTER

Reserved word check?

  • Y-Yes
  • N-No

REF_INTEGRITY

CHARACTER

Referential Integrity Default enforcement:

  • D-DB2
  • I-System

STG_VSAM_DEF

CHARACTER

Storage group/VSAM default:

  • S-Storage group
  • V-VSAM