HELPLIB.HLB  —  RMU72  Using LogMiner for Rdb, SQL Table Definition Prefix
    The SQL record definition for the fields that LogMiner for Rdb
    writes to the output is shown in the following example. These
    fields can be manually appended to the table creation command
    for the actual user data fields being unloaded. Alternately, the
    Table_Definition qualifier can be used with the Table qualifier
    or within an Options file to automatically create the SQL
    definition file. This can be used to create a transaction table
    of changed data.

    SQL> create table MYLOGTABLE (
    cont> RDB$LM_ACTION          CHAR,
    cont> RDB$LM_RELATION_NAME      CHAR (31),
    cont> RDB$LM_RECORD_TYPE     INTEGER,
    cont> RDB$LM_DATA_LEN        SMALLINT,
    cont> RDB$LM_NBV_LEN         SMALLINT,
    cont> RDB$LM_DBK             BIGINT,
    cont> RDB$LM_START_TAD       DATE VMS,
    cont> RDB$LM_COMMIT_TAD      DATE VMS,
    cont> RDB$LM_TSN             BIGINT,
    cont> RDB$LM_RECORD_VERSION  SMALLINT ...);
Close Help