BTEQ - REPEAT in ANSI mode in Teradata

In ANSI mode, a session opens its transaction by its first SQL statement. The transaction is closed completely by sending either a COMMIT or ROLLBACK statement on the session. If the .SESSION and .REPEAT commands are used in ANSI mode, the COMMIT statement has to be sent along with the repeated SQL statement as one request.

.SESSION trans ansi
.import data file = <data file name>
.repeat *
using i(integer), j(integer)
insert into <table name> (col1, col2)
values (:i,:j); COMMIT WORK;

If the repeated request is sent without the COMMIT statement, sooner or later, one of the requests will be blocked by other sessions, and gradually the job will hang due to a deadlock.