Informix and EGL

The following rules are specific to Informix databases and EGL:

• An Informix database that is accessed by EGL or by an EGL-generated program must have transactions enabled.

• If you are using the SQL retrieve feature of EGL to access data from a non-ANSI Informix database, make sure that any database column of type DECIMAL includes a scale value. Instead of defining a column as DECIMAL (4), for example, define the column as DECIMAL (4,0).

• If you intend to use the SQL retrieve feature to retrieve data from a table that is part of an Informix system schema, set a special preference, as described in Setting preferences for SQL retrieve.

Related concepts
SQL support

Related tasks
Retrieving SQL table data
Setting preferences for SQL retrieve