16.10 - About the Load Data Wizard and JDBC - Teradata Studio

Teradata Studio Express User Guide

Teradata Studio
June 2017
User Guide

The JDBC Driver returns SQL warnings if it determines that a FastLoad operation is not possible. This might be due to incompatible column data types; for example, CLOB or BLOB data types. If this occurs, the JDBC Driver processes the batch insert in a non-FastLoad mode.

The JDBC Driver feature is not applicable for Aster data transfers.
When loading data, not all data type conversions supported by the Teradata JDBC Driver are supported by JDBC FastLoad or JDBC addBatch. This is an issue related to Date, Time, and Timestamp data types. Teradata recommends that when you load data for these data types, use the following JDBC escape formats:
  • JDBC Date escape format is: yyyy-mm-dd.
  • JDBC Time escape format is: hh:mm:ss.
  • JDBC Timestamp escape format is: yyyy-mm-dd hh:mm:ss.ffffff.