HELPLIB.HLB  —  RMU72  Unload  Database  Command Qualifiers, Debug Options
    Debug_Options={options}

    The Debug_Options qualifier allows you to turn on certain debug
    functions. The Debug_Options qualifier accepts the following
    options:

    o  [NO]TRACE

       Traces the qualifier and parameter processing performed by
       RMU Unload. In addition, the query executed to read the table
       data is annotated with the TRACE statement at each Commit
       (controlled by Commit_Every qualifier). When the logical name
       RDMS$SET_FLAGS is defined as "TRACE", then a line similar to
       the following is output after each commit is performed.

       ~Xt: 2009-04-23 15:16:16.95: Commit executed.

       The default is NOTRACE.

       $RMU/UNLOAD/REC=(FILE=WS,FORMAT=CONTROL) SQL$DATABASE WORK_STATUS WS/DEBUG=TRACE
       Debug = TRACE
       * Synonyms are not enabled
       Row_Count = 500
       Message buffer: Len: 13524
       Message buffer: Sze: 27, Cnt: 500, Use: 4 Flg: 00000000
       %RMU-I-DATRECUNL,   3 data records unloaded.

    o  [NO]FILENAME_ONLY

       When the qualifier Record_Definition=Format:CONTROL is used,
       the name of the created unload file is written to the control
       file (.CTL). When the keyword FILENAME_ONLY is specified, RMU
       Unload will prune the output file specification to show only
       the file name and type. The default is NOFILENAME_ONLY.

       $RMU/UNLOAD/REC=(FILE=TT:,FORMAT=CONTROL) SQL$DATABASE WORK_STATUS WS/DEBUG=
       FILENAME
       --
       -- SQL*Loader Control File
       --   Generated by: RMU/UNLOAD
       --   Version:      Oracle Rdb X7.2-00
       --   On:           23-APR-2009 11:12:46.29
       --
       LOAD DATA
       INFILE 'WS.UNL'
       APPEND
       INTO TABLE "WORK_STATUS"
       (
        STATUS_CODE                     POSITION(1:1) CHAR NULLIF (RDB$UL_NB1 = '1')
       ,STATUS_NAME                     POSITION(2:9) CHAR NULLIF (RDB$UL_NB2 = '1')
       ,STATUS_TYPE                     POSITION(10:23) CHAR NULLIF (RDB$UL_NB3 = '1')
       -- NULL indicators
       ,RDB$UL_NB1               FILLER POSITION(24:24) CHAR -- indicator for
       STATUS_CODE
       ,RDB$UL_NB2               FILLER POSITION(25:25) CHAR -- indicator for
       STATUS_NAME
       ,RDB$UL_NB3               FILLER POSITION(26:26) CHAR -- indicator for
       STATUS_TYPE
       )
       %RMU-I-DATRECUNL,   3 data records unloaded.

    o  [NO]HEADER

       This keyword controls the output of the header in the control
       file. To suppress the header use NOHEADER. The default is
       HEADER.

    o  APPEND, INSERT, REPLACE, TRUNCATE

       These keywords control the text that is output prior to the
       INTO TABLE clause in the control file. The default is APPEND,
       and only one of these options can be specified.
Close Help