-1007 Invalid IBM DATE format - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 (SPP Prefix) Messages

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Preprocessor2 for Embedded SQL
Release Number
15.xx, 16.xx, 17.xx, 20.xx
Published
June 2020
Language
English (United States)
Last Update
2023-11-20
lifecycle
Latest
Product Category
Teradata Tools and Utilities

-1007 Invalid IBM DATE format

Possible Cause

The data type of an input host variable indicates an IBM style date, but the value is not in a valid IBM date format. This error occurs only if the SQLDA is constructed by the application. The precompiler will not generate code using this data type.

Possible Solution

If the application must use an IBM date data type for input, verify the value is in one of the following formats: USA - MM/DD/YYYY; ISO/JIS - YYYY-MM-DD; EUR - DD.MM.YYYY.