VMS Help  —  RMU72  Load  Database  Command Qualifiers, Trigger Relations
    Trigger_Relations[=(table-name-list)]
    NoTrigger_Relations

    You can use the Trigger_Relations qualifier in three ways:

    o  Trigger_Relations=(table-name-list)

       Specifies the tables to be reserved for update. Using this
       qualifier, you can explicitly lock tables that are updated
       by triggers in store operations. If you list multiple tables,
       separate the table names with a comma, and enclose the list of
       table names within parentheses.

    o  Trigger_Relations

       If you omit the list of table names, the tables updated by
       triggers are locked automatically as required. This is the
       default.

    o  NoTrigger_Relations

       Disables triggers on the target table. This option requires
       DROP privilege on the table being loaded. You cannot specify a
       list of table names with this option.

    If you specify a parallel load operation (with the Parallel
    qualifier), and triggers are defined on the table you are
    loading, Oracle Corporation recommends that you specify the
    Shared share mode or drop the triggers prior to starting a
    parallel load operation. See the Usage Notes for details.

    The Trigger_Relations qualifier can be used with indirect file
    references. See the Indirect-Command-Files help entry for more
    information.
Close Help