Informix ODBC Driver Database Error

説明

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 xpa/eDeveloper and 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 xpa/eDeveloper program窶冱 Preload view task property is set to No.

注意: The xpa/eDeveloper connection to Informix is done using a third party ODBC driver for the Informix RDBMS.

Cause of Error

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.

対応

1. In the Informix database窶冱 Database Properties dialog box, click the SQL tab.

2. 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.