Hi!
I found this forum when I was browsing the net for answers to the following problem:
I'm using Impromptu v. 6.0.631.0 on a machine running Win2000. I'm trying to use the to_date function to convert a string in an informix database (IDS 7.3 I think) to the datetime format. The string is defined as char(10) in the database. When I attempt the following calculation:
to_date (date_field; 'yymmddhhmm')
I get this error message:
Error number -9:
DMS-E-GENERAL, A general exception has occurred during operation 'fetch'.
[Informix][Informix ODBC Driver][Informix]Input does not match format specification.
[Informix][Informix ODBC Driver]Error in row.
The actual error message is longer but it starts repeating itself after this. Does anyone know what might be going wrong? I'm accessing the database via ODBC using IBM's Informix Client SDK v.2.81 and ODBC Driver v.3.82. Any help would be appreciated.
Regards,
Christian
I found this forum when I was browsing the net for answers to the following problem:
I'm using Impromptu v. 6.0.631.0 on a machine running Win2000. I'm trying to use the to_date function to convert a string in an informix database (IDS 7.3 I think) to the datetime format. The string is defined as char(10) in the database. When I attempt the following calculation:
to_date (date_field; 'yymmddhhmm')
I get this error message:
Error number -9:
DMS-E-GENERAL, A general exception has occurred during operation 'fetch'.
[Informix][Informix ODBC Driver][Informix]Input does not match format specification.
[Informix][Informix ODBC Driver]Error in row.
The actual error message is longer but it starts repeating itself after this. Does anyone know what might be going wrong? I'm accessing the database via ODBC using IBM's Informix Client SDK v.2.81 and ODBC Driver v.3.82. Any help would be appreciated.
Regards,
Christian