Cancel a Parallel Load Operation

You can cancel and cleanly stop all threads that are performing a parallel load operation with either the SQLCancel(hstmt) ODBC function (this applies for ODBC 2.5 and ODBC 3.5) or by pressing Ctrl-C in the ttIsql utility.

See TimesTen ODBC Support in the Oracle TimesTen In-Memory Database C Developer's Guide and unresolvable-reference.html in this book.

A parallel load operation periodically commits, so any successful operations are not rolled back. When you issue the cancel command, TimesTen performs the cancel operation:

• Before insert threads are spawned.

• After an insert batch commit (every 256 rows)

• After the main thread completes a fetch from the Oracle database.

To retry a cancelled parallel load operation, delete previously inserted rows from the TimesTen database to avoid duplicate rows.