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

    COMMIT EVERY TABLE | COMMIT EVERY n ROWS

    Specifies whether the IMPORT statement commits entire tables, or
    commits a certain number of rows at regular intervals. If you use
    the COMMIT EVERY n ROWS clause, you can supply a value from 1 to
    2147483647 for n.

    The default is COMMIT EVERY TABLE. If you use the COMMIT EVERY n
    ROWS clause, the table will be left with a partial set of rows if
    the IMPORT process fails.

                                   NOTE

       If the table being imported includes a storage map with the
       PLACEMENT VIA INDEX clause, then the COMMIT EVERY clause
       is ignored for that table. A message is displayed to inform
       the database administrator of the tables that did not have
       COMMIT EVERY applied. This condition is shown in Example 6.
Close Help