Specifies the type of protocol to be used with the Teradata Database for SQL statements.

Data Type

string

Default Value

""

Remarks

Options are: TYPE=DEFAULT directs the Teradata JDBC Driver to use the standard protocol for all SQL statements TYPE=FASTLOAD directs the Teradata JDBC Driver to use the FastLoad protocol for FastLoad-capable SQL INSERT statements and the standard protocol for all other SQL statements TYPE=FASTLOADCSV directs the Teradata JDBC Driver to use the FastLoad protocol for FastLoadCSV-capable SQL INSERT statements. Other SQL statements are not supported by this type of connection. This feature is available beginning with Teradata JDBC Driver 13.00.00.26. TYPE=FASTEXPORT directs the Teradata JDBC Driver to use the FastExport protocol for FastExport-capable SQL SELECT statements and the standard protocol for all other SQL statements TYPE=RAW constructs a Raw Connection that is equivalent to CLI's Buffer Mode, in which the application takes responsibility for composing messages sent to the Teradata Database and parsing messages received from the Teradata Database.