SQL$HELP72.HLB  —  SET_TRANSACTION, Arguments  BATCH_UPDATE
    Specifies the batch-update mode to reduce overhead in large-
    load operations. To speed update operations, Oracle Rdb does not
    write to snapshot or recovery-unit journal files in a batch-
    update transaction. For more information about batch-update
    transactions, see the Oracle Rdb Guide to SQL Programming and
    the Oracle Rdb SQL Reference Manual.

                                 CAUTION

       Before you begin a batch-update transaction in your
       programs, you should create a backup copy of the database
       using the RMU Backup command. If an error occurs in your
       program that would normally result in a rollback of the
       transaction, Oracle Rdb marks the database as corrupt.
       To recover from a corrupt database, you must create the
       database again from the backup copy of the database. After
       correcting the error condition, you can restart the program
       from the beginning. You should back up the database after
       completing a batch-update transaction as well.
Close Help