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 coding an SQL statement and use a colon (:) when identifying
an Informix table,
use quote marks to separate the Informix identifier from the rest of
the statement, as in these examples:
INSERT INTO "myDB:myTable"
(myColumn) values (:myField)
INSERT INTO "myDB@myServer:myTable"
(myColumn) values (:myField)
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, you must set a special preference,
as described in Setting preferences for SQL retrieve.