COMMIT Statement

Issues a commit or saves rows after a specified number of inserts

Default:	1000
Requirement:	The commit-frequency argument must be a nonnegative integer.
Interaction:	If you omit the COMMIT statement, a commit is issued or a group of rows is saved after each 1,000 rows are inserted and after the last row is inserted.
Note:	The COMMIT statement issues a commit (generates a DBMS-specific SQL COMMIT statement) after the specified number of rows has been inserted.
Tip:	Using this statement might improve performance by releasing DBMS resources each time the specified number of rows has been inserted.