Data Warehouse Center Application Integration Guide

FLG.HISTORY table

The FLG.HISTORY table is used to keep track of object instances that have been deleted from the Information Catalog Manager and the Data Warehouse Center.

The table is populated when the user deletes an object instance and the recording delete history flag is ON. At any time, this table can contain zero to many rows.

The HISSEQ column is the primary key of the table.

Table 65 provides information about each column found in the FLG.HISTORY table.

Table 65. FLG.HISTORY table column properties

Column name Data type Description Nullable NLS
HISSEQ TIMESTAMP The sequence number of the delete history. No None
HISTYPE INTEGER The type of the delete history.

A value of 1 in this column indicates a deletion from the information catalog.
A value of 2 in this column indicates a deletion from the Data Warehouse Center.
No None
HISTAG LONG VARCHAR This column will store the identifier of the object to be deleted. Yes Both SBCS and DBCS
Note:
NLS: National Language Support
SBCS: Single Byte Character Set
DBCS: Double Byte Character Set

Column name	Data type	Description	Nullable	NLS
HISSEQ	TIMESTAMP	The sequence number of the delete history.	No	None
HISTYPE	INTEGER	The type of the delete history. A value of 1 in this column indicates a deletion from the information catalog. A value of 2 in this column indicates a deletion from the Data Warehouse Center.	No	None
HISTAG	LONG VARCHAR	This column will store the identifier of the object to be deleted.	Yes	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 ]