SQL$HELP72.HLB  —  IMPORT  Arguments  BATCH_UPDATE
    Syntax options:

    BATCH UPDATE | NO BATCH UPDATE

    Specifies whether the IMPORT statement stores user data and
    indexes using batch-update transactions (BATCH UPDATE) or
    read/write transactions for each table (NO BATCH UPDATE). The
    NO BATCH UPDATE option is the default.

    A batch-update transaction is faster but does not perform
    recovery-unit journaling, which means you cannot recover the
    database in the event of a failure during the IMPORT operation.
    With the NO BATCH UPDATE option, you can recover the database.

    For more information about batch-update transactions, see the
    SET_TRANSACTION statement.
Close Help