Resolution:
Description:
============
What is the difference between ANSI mode and Teradata mode?

Environment:
===========
All

Resolution:
==========
ANSI mode Teradata Adapter will commit the request manually. It means when Adapter sends a request to Teradata, if result is successful, adapter should send a commit command to Teradata to execute the request, otherwise adapter will send a rollback command to Teradata. This is done by hardcode in adapter internally.

Once you enable the debug level log, you will see the commit statement in the log messages.

While in Teradata mode, adapter just sends the request to Teradata and then check the result, no explicit commit command will be sent. The Teradata database will automatically commit or rollback the request depending on the result.