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 ...);