Informix ODBC Driver Database Error (Magic xpa 3.x)
This Technical Note describes how to resolve the following database error:
[Informix][Informix ODBC Driver][Informix]Routine (greaterthanorequal) can not be resolved.
This database error may appear while working with the Informix database, but only in a specific situation. The error only occurs when the Informix table contains a Boolean column or segment as part of a Unique index and the program’s Preload view task property is set to No.
Note: The connection to Informix is done using a third party ODBC driver for the Informix RDBMS.
The error is due to a limitation of the Informix ODBC driver.
Paging down in ODBC causes repositioning, and since the ODBC driver does not allow ranges on Boolean columns, the error is issued.
If the Preload View property is set to Yes, then records are all cached and no repositioning is required; in this case, the error is not issued.
-
In the Informix database’s Database Properties dialog box, click the SQL tab.
-
In the Database Information field, enter the following flag:
SQL_STARTPOS=N
The SQL_STARTPOS flag prevents the error from appearing when the implementation of the Range operation is only to build a data view.
