About the Load Data Wizard and JDBC | Teradata Studio/Studio Express - About the Load Data Wizard and JDBC - Teradata Studio

Teradata® Studio™ Express User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
ztp1648839236373.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
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.