Informix - Problem description
Problem IT29118 | Status: Closed |
RUNNING A QUERY USING A SYNONYM FAILS WITH ERROR -1218 IF DBDATEOF LOCAL AND REMOTE INSTANCE DOES NOT MATCH | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
Running a query against a synonym created on a remote table fails with error -1218 if DBDATE of local and remote instance does not match If a local instance is started with DBDATE set to 'DMY4/' and a remote synonym to a local table is created with same DBDATE in a remote instance but later it is executed with DBDATE set to a different format like 'Y4MD-' or the instance is restarted with DBDATE set to 'Y4MD-' the query against the synonym fails with error -1218. Database selected. (expression) (expression) 5 2019-01-04 1 row(s) retrieved. 1218: String to date conversion error Error in line 2 Near character position 1 Database closed. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS versions prior to 12.10.xC14. * **************************************************************** * PROBLEM DESCRIPTION: * * Running a query against a synonym created on a remote table * * fails with error -1218 if DBDATE of local and remote * * instance does not match. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.05.2019 24.09.2019 24.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14 | |
Problem solved according to the fixlist(s) of the following version(s) |