BTEQ - Multiple statement processing in Teradata

BTEQ will execute the commands to the Teradata RDBMS by watching where the semicolons used in the requested query.

Example:
INSERT tbl_employee('rrrrrrrrrrrrrrrrr',123,111)
;INSERT tbl_employee('rrrrrrrrrrrrrrrrr',123,111)
;INSERT tbl_employee('rrrrrrrrrrrrrrrrr',123,111);

The above example illustrates the multiple statement processing.

Since the semicolon is put at the beginning of each statement, BTEQ will execute all the statements at once.
BTEQ submits the above statements to the Teradata RDBMS as single statement request since it starts to submit the SQL only after seeing the semicolon at the third statement.