An RMS file containing the record structure definition for the
output file can be used as an input file to the RMU Load command
if extracted data is to be loaded into an Oracle Rdb database.
The record description uses the CDO record and field definition
format (this is the format used by the RMU Load and RMU Unload
commands when the Record_Definition qualifier is used). The
default file extension is .rrd.
The 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 a record definition file
for the actual user data fields being unloaded. Alternately,
the Record_Definition qualifier can be used with the Table
qualifier or within an Options file to automatically create the
record definition file. This can be used to load a transaction
table within a database. A transaction table is the output that
LogMiner for Rdb writes to a table consisting of sequential
transactions performed in a database.
DEFINE FIELD RDB$LM_ACTION DATATYPE IS TEXT SIZE IS 1.
DEFINE FIELD RDB$LM_RELATION_NAME DATATYPE IS TEXT SIZE IS 31.
DEFINE FIELD RDB$LM_RECORD_TYPE DATATYPE IS SIGNED LONGWORD.
DEFINE FIELD RDB$LM_DATA_LEN DATATYPE IS SIGNED WORD.
DEFINE FIELD RDB$LM_NBV_LEN DATATYPE IS SIGNED WORD.
DEFINE FIELD RDB$LM_DBK DATATYPE IS SIGNED QUADWORD.
DEFINE FIELD RDB$LM_START_TAD DATETYPE IS DATE
DEFINE FIELD RDB$LM_COMMIT_TAD DATATYPE IS DATE
DEFINE FIELD RDB$LM_TSN DATATYPE IS SIGNED QUADWORD.
DEFINE FIELD RDB$LM_RECORD_VERSION DATATYPE IS SIGNED WORD.