Data Mover DATETIME Field Export Failure (INFORMIX)
I hope this is the correct forum.
I have an INFORMIX table which has one key and two other fields. One of the non-key fields is called DATETIME. When this field is used in any table and a datamover export script is used to export data, then export script receives the following error:
File: Data MoverSQL error. Stmt #: 0 Error Position: 44 Return: -201 - Informix Error [-201] ISAM Error [0] A syntax error has occurred.
Failed SQL stmt:SELECT PROCESS_INSTANCE,TESTFIELD,DATETIME FROM PS_TEST_TB
I know DATETIME is the problem field in my table but this is a field name which is delivered by PeopleSoft. Datamover scripts are failing because of the use of the DATETIME field name. Has anyone experienced this before and what was your work around? I know I can change the name of the field in the tables to something else but this would require unit and system testing of objects that already work.
File: Data MoverSQL error. Stmt #: 0 Error Position: 44 Return: -201 - Informix Error [-201] ISAM Error [0] A syntax error has occurred.
Failed SQL stmt:SELECT PROCESS_INSTANCE,TESTFIELD,DATETIME FROM PS_TEST_TB
I know DATETIME is the problem field in my table but this is a field name which is delivered by PeopleSoft. Datamover scripts are failing because of the use of the DATETIME field name. Has anyone experienced this before and what was your work around? I know I can change the name of the field in the tables to something else but this would require unit and system testing of objects that already work.
0