BTEQ - Single 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 single statement processing.

Since the semicolon is put at the end of each statement, BTEQ will execute each statement before executing the next one.
BTEQ submits the above statements to the Teradata RDBMS as three single statement requests.