Data Warehouse Center Application Integration Guide

FLG.RELINST table

The FLG.RELINST table defines relationships between two objects. The table contains one row for each source-to-target object instance relationship.

The RELTYPE, SOURCE, and TARGET columns form the primary key of the table.

The RELTYPE, SRCCAT, SOURCE, SRCTNAME, SRCINAME, TRGCAT, TARGET, TRGTNAME, and TRGINAME columns are indexes of the table.

Table 72 provides information about each column found in the FLG.RELINST table.

Table 72. FLG.RELINST table column properties
Column name Data type Description Nullable NLS
RELTYPE CHAR(1) Relation type:

C
Contains

T
Contact
No SBCS
SRCCAT CHAR(1) Category of the source object. No SBCS
SOURCE CHAR(16) The FLGID that represents the source object instance. No SBCS
SRCTNAME VARCHAR(80) The external name of the source object type. No Both SBCS and DBCS
SRCINAME VARCHAR(80) The external name of the source object instance. No Both SBCS and DBCS
TRGCAT CHAR(1) The category of the target object. No SBCS
TARGET CHAR(16) The FLGID that represents the target object instance. No SBCS
TRGTNAME VARCHAR(80) The external name of the target object type. No Both SBCS and DBCS
TRGINAME VARCHAR(80) The external name of the target object instance. No Both SBCS and DBCS
Note:

NLS: National Language Support

SBCS: Single Byte Character Set

DBCS: Double Byte Character Set


[ Top of Page | Previous Page | Next Page ]