Producer Operator Support - Parallel Transporter

Teradata® Parallel Transporter User Guide - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Parallel Transporter
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-08-25
dita:mapPath
uzp1645128359760.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
Product Category
Teradata Tools and Utilities

The producer operator is responsible for reformatting the DateTime data that is associated with VARDATE columns before sending the data records to the data stream. The DataConnector and ODBC operators are the only producer operators that support this functionality. If any other producer operator is associated with a TPT schema object that includes VARDATE columns, reformatting will not occur. In this case, VARDATE columns are equivalent to VARCHAR columns of the same size.

VARDATE formatting does not affect consumer operators.

Aside from those cases discussed in the Usability Features section, all columns of incoming data with type VARDATE must conform to the format specified by the FORMATIN string of that column. If the formatting of a given row differs significantly from the specified FORMATIN string, or if the desired conversion from FORMATIN to FORMATOUT is unsuccessful due to a lack of data, a conversion failure occurs.