Data Warehouse Center Application Integration Guide

FLG.CHECKPT table

The FLG.CHECKPT table is used by the Import API to restart the import process at a checkpoint.

The table is populated by the Import API. At any time, this table can contain zero to many rows.

The TAGFNAME column is the primary key of table.

The COMMITID, LASTUPDT, and USERID columns are all indexes of the table.

Table 62 provides information about each column found in the FLG.CHECKPT table.

Table 62. FLG.CHECKPT table column properties
Column name Data type Description Nullable NLS
TAGFNAME VARCHAR(240) The name of the tag language file (without the path information). No Both SBCS and DBCS
COMMITID CHAR(26) The identifier of the last COMMIT checkpoint. This identifier is supplied by the user in a COMMIT tag placed at appropriate locations in the tag language file. It can be a system timestamp or any series of characters. No Both SBCS and DBCS
LASTUPDT TIMESTAMP The system timestamp when this entry was either created or updated. The Last Update field will not need padding, because it will always occupy the full 26 bytes. No None
USERID CHAR(8) The user ID of the information catalog administrator. No Both SBCS and DBCS
ENTSAVED INTEGER The total number of entries that have been saved in the save area. No None
SAVEAREA LONG VARCHAR Storage area for a list of object type names. Each object type name is 8 bytes. No SBCS
Note:

NLS: National Language Support

SBCS: Single Byte Character Set

DBCS: Double Byte Character Set


[ Top of Page | Previous Page | Next Page ]