Transaction isolation levels

The SQL import agent will run all of its queries in a single transaction using a configurable isolation level. Refer to the following table for additional information about the supported values:

Name	Numeric value	Additional notes
DEFAULT	0	Uses the server-side default isolation level; the agent always uses this value for connections with IBM Db2 and Oracle Database instances
READ_UNCOMMITTED	1
READ_COMMITTED	2
REPEATABLE_READ	4
SNAPSHOT	5	The agent uses this value by default for connections with Microsoft SQL Server instances
SERIALIZABLE	6	The agent uses this value by default for connections with MySQL instances