Data Warehouse Center Application Integration Guide

FLG.EXCHANGE table

The FLG.EXCHANGE table is used to keep track of the object sychronized between the Information Catalog Manager, the Data Warehouse Center, and DB2 OLAP Server^(TM).

This table is populated by the metadata interchange at installation time.

The OBJNAME and OBJTYPE columns form the primary key of the table.

Table 64 provides information about each column found in the FLG.EXCHANGE table.

Table 64. FLG.EXCHANGE table column properties

Column name Data type Description Nullable NLS
PRODUCT VARCHAR(40) The combination of product, version, and release numbers. No SBCS
OBJNAME VARCHAR(200) The object name, for example, step. No Both SBCS and DBCS
IMPDATE TIMESTAMP The import timestamp. No None
OBJTYPE CHAR(5) OBJTYPE can be one of the following values:

IR represents source metadata exchanged
DR represents target metadata
BV represents step metadata
OLAP represents OLAP metadata
No SBCS
Note:
NLS: National Language Support
SBCS: Single Byte Character Set
DBCS: Double Byte Character Set

Column name	Data type	Description	Nullable	NLS
PRODUCT	VARCHAR(40)	The combination of product, version, and release numbers.	No	SBCS
OBJNAME	VARCHAR(200)	The object name, for example, step.	No	Both SBCS and DBCS
IMPDATE	TIMESTAMP	The import timestamp.	No	None
OBJTYPE	CHAR(5)	OBJTYPE can be one of the following values: IR represents source metadata exchanged DR represents target metadata BV represents step metadata OLAP represents OLAP metadata	No	SBCS
Note: NLS: National Language Support SBCS: Single Byte Character Set DBCS: Double Byte Character Set

[ Top of Page | Previous Page | Next Page ]