EGL Reference Guide for iSeries
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, you must 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
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.