Every LOAD session is operated with the lock mode NORMAL (see the Reference manual); i.e., any locks that may be required are set implicitly.
Load Statements:
In the case of DATALOAD and DATAUPDATE, LOAD concludes the current transaction after a certain number of rows has been inserted or updated; then it opens a new transaction.
The transaction size currently set (default is 100 rows per transaction) can be displayed and modified using the SET command.
Extract Statements:
For a syntax check, a SELECT statement is created from the DATAEXTRACT statement and executed. If result sets were generated, the current transaction is concluded and a new one started. If DATAEXTRACT WITH LOCK has been specified, all tables from which selections are to be made are read-locked.
During extraction, the table rows are read from the unnamed result table which was created by the SELECT statement. If the locks are no longer required (at the latest, at the end of the extract run), they are released by concluding the transaction.
In AUTOCOMMIT mode, each SQL statement is implicitly concluded with COMMIT. With the AUTOCOMMIT mode, an interactive user is prevented from unvoluntarily holding locks, thus hindering other users. In command files, this mode can be disabled by using AUTOCOMMIT OFF if a group of SQL statements is to be executed within a transaction and rolled back, if necessary.