Previous Topic: ODBC_TABLE (Table ODBC Extension)Next Topic: OPEN_SRVR_NAME


ODBC_TD (Technical Design ODBC Extension)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

ODBC_TD

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

OWNER_ID

STRING

Owner identifier

DFLT_DBNAME

STRING

Default DB Name

RI_ENFORCEMENT

CHAR

Referential integrity enforcement

RES_WORD_CHK

CHAR

Reserved word check

DBMS_REL_VER

CHAR

DBMS release version

PV_READ_ENF

CHAR

Permitted value READ enforcement

PV_DBMS_ENF

CHAR

Permitted value DBMS enforcement

DEF_VALUE_ENF

CHAR

Default value enforced?

NULL_OR_DEF

CHAR

Create NULL or default value?

GEN_ODBC_INT

CHAR

Generate ODBC Interface?

TECH_DSN_ID

NUMERIC

Base technical design this object is extended from

Join with TECHNICAL_DESIGN