Kbase P133234: Query fails with a syntax error when date field is used in a WHERE clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/13/2009 |
|
Status: Unverified
SYMPTOM(s):
Query fails with a syntax error when date field is used in a WHERE clause
Driver reports Native Error Code: -180
[Data Direct][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]STRING REPRESENTATION OF DATETIME VALUE HAS INVALID SYNTAX. 1 *N
The joblog of the DDM server job on AS/400 (QRWTSRVR) contains messages CPD4374 and SQL0180
CPD4374: Field HVR0001 and value 1 not compatible. Reason 13.
Reason 13: The syntax of the value for the variable field is not valid for a date, time, or timestamp.
SQL0180: Syntax of date, time, or timestamp value not valid.
FACT(s) (Environment):
IBM AS/400 (RISC)
OpenEdge 10.x
ODBC DataServer
OS/400 V5R4
OS/400 V5R3
CAUSE:
The problem is caused by bugs in SQL Query Engine on the server side.
IBM APAR numbers: SE31258 and SE31056
FIX:
Contact IBM to obtain relevant PTFs and install them:
1. V5R3: SI29963 and SI29964
2. V5R4: SI29961 and SI29962