VMS Help  —  RMU72  Using LogMiner for Rdb, Record Definition Prefix
    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.
Close Help