About the Load Data Wizard and JDBC - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hop1484765174877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.