=================================
DOCUMENTATION NOTES
FOR
HCL Informix Enterprise Gateway Manager User Manual 7.31.UD4
DATE: March 2026
=================================
Table of Contents
I. Overview of EGMDOC_7.3
II. INFORMIX-Enterprise Gateway Manager User Manual
A. Limitation on Amount of Blob Data Returned to Client
B. Set the INFORMIXSERVER Environment Variable if
Using the Informix ODBC Driver
=================================
I. OVERVIEW OF EGMDOC_7.3
EGMDOC_7.3 describes feature and performance topics not covered
in the manual or modified since publication. Please examine this
file. It contains vital information about applicatio
=================================
RELEASE NOTES
FOR
HCL Informix Enterprise Gateway Manager (EGM) 7.31.UD4
DATE: February 2026
=================================
TABLE OF CONTENTS
I. OVERVIEW OF THESE NOTES
II. NEW FEATURES IN v7.31.UD4
III. PRODUCTS INCLUDED IN THIS RELEASE
IV. PRODUCTS TESTED WITH EGM
V. CUSTOMER-REPORTED DEFECTS FIXED IN THIS RELEASE
VI. CUSTOMER-REPORTED KNOWN DEFECT IN THIS RELEASE
VII. KNOWN ISSUE
VIII. NOTICES
I. OVERVIEW OF THESE NOTES
These release notes contain additional information not found in the
product manuals or machine notes that are included with the product.
EGM v7.31.UD4 documentation is available on the HCL® Informix®
Products documentation site located at:
https://help.hcl-software.com/hclinformix/15.0/index.html
For platform-specific information about this release, see the
machine notes included in this product.
II. NEW FEATURES IN v7.31.UD4
EGM no longer bundles Progress DataDirect Connect for ODBC.
Connectivity now relies on unixODBC together with the ODBC driver supplied by your database vendor.
III. PRODUCTS INCLUDED IN THIS RELEASE
o HCL Informix 4GL v7.51.xC2
o HCL Informix C-ISAM v7.26.xC3
o HCL Informix GLS v6.00.xC6
IV. PRODUCTS TESTED WITH EGM
A. Informix database servers
o Informix v12.10
o Informix v14.10
B. Non-IBM Servers/Clients
o Oracle Server v12c
o Microsoft® SQL Server 2022
C. ODBC drivers
o DB2, v7.1
o Oracle, v12.2.0.1.0
o FreeTDS SQL Server, v1.4.12
o Sybase, v7.1
V. CUSTOMER-REPORTED DEFECTS FIXED IN THIS RELEASE
IC80549
-------
EGM might return wrong values for Oracle data type DECIMAL(p)
IC88175
-------
Query using enterprise gateway manager gives error -1290
environment variable too long
0096334
-------
Corrupted data when reading from an Oracle varchar2 column.
0248610
-------
EGM coredumps when adding tables to the catalog on a hp/ux 64-bit
0506754
-------
The non-legacy (new) sql server odbc driver was not included in EGM
IC58379
-------
Receiving error -270 when querying an oracle table with a
long column.
IC63344
-------
CANNOT SELECT RECORDS FROM REMOTE (DB2-UDB) DATABASE
IC66982
-------
DB2 error -104 (syntax error) thrown on EGM connection to
DB2 z/OS when using SQL funct ions or expressions such as
CASE, UPPER, LOWER, TRIM, CAST, etc
IC68861
-------
EGM on Itanium does not convert TODAY function to host
server syntax.
IC69086
-------
EGM parameter GWDEBUG value 123 does not work on Itanium platform.
VI. CUSTOMER-REPORTED KNOWN DEFECT IN THIS RELEASE
IC68805
=======
EGM still issues a "select count(*)" on target table after
SQLStatistics is called with GWCATALOG setting of STAT=3.
Reason-SQLStatistics provided by the ODBC driver is unable
to return the rows count.
VII. KNOWN ISSUE
Invoking the egmdba command may return an error message
such as "Library not found."
To prevent this error message, set the SHLIB_PATH configuration
parameter to the following value:
$INFORMIXDIR/egm/odbc/lib:/usr/lib:$INFORMIXDIR/lib:
$INFORMIXDIR/lib/tools:$INFORMIXDIR/lib/esql
VIII. NOTICES
This information was developed for products and services offered in the U.S.A.
HCL may not offer the products, services, or features discussed in this document in other countries. Consult your local HCL representative for information on the products and services currently available in your area. Any reference to an HCL product, program, or service is not intended to state or imply that only that HCL product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any HCL intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-HCL product, program, or service.
HCL may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not grant you any license to these patents. You can send license inquiries, in writing, to:
HCL Director of Licensing
HCL Corporation
North Castle Drive
Armonk, NY 10504-1785
U.S.A.
For license inquiries regarding double-byte (DBCS) information, contact the HCL Intellectual Property Department in your country or send inquiries, in writing, to:
Intellectual Property Licensing
Legal and Intellectual Property Law
HCL Japan Ltd.
1623-14, Shimotsuruma, Yamato-shi
Kanagawa 242-8502 Japan
The following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you.
This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. HCL may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice.
Any references in this information to non-HCL websites are provided for convenience only and do not in any manner serve as an endorsement of those websites. The materials at those websites are not part of the materials for this HCL product and use of those websites is at your own risk.
HCL may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you.
Licensees of this program who wish to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact:
HCL Corporation
J46A/G4
555 Bailey Avenue
San Jose, CA 95141-1003
U.S.A.
Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee.
The licensed program described in this document and all licensed material available for it are provided by HCL under terms of the HCL Customer Agreement, HCL International Program License Agreement or any equivalent agreement between us.
Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurements may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment.
Information concerning non-HCL products was obtained from the suppliers of those products, their published announcements or other publicly available sources. HCL has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-HCL products. Questions on the capabilities of non-HCL products should be addressed to the suppliers of those products.
All statements regarding HCL's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.
All HCL prices shown are HCL's suggested retail prices, are current and are subject to change without notice. Dealer prices may vary.
This information is for planning purposes only. The information herein is subject to change before the products described become available.
This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.
COPYRIGHT LICENSE:
This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to HCL, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. HCL, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. The sample programs are provided "AS IS", without warranty of any kind. HCL shall not be liable for any damages arising out of your use of the sample programs.
Each copy or any portion of these sample programs or any derivative work, must include a copyright notice as follows:
© (your company name) (year). Portions of this code are derived from HCL Corp. Sample Programs.
© Copyright HCL Corp. _enter the year or years_. All rights reserved.
If you are viewing this information softcopy, the photographs and color illustrations may not appear.
Trademarks
-----------
HCL, the HCL logo, and ibm.com? are trademarks or registered trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of HCL or other companies. A current list of HCL trademarks is available on the web at "Copyright and trademark information" at http://www.ibm.com/legal/copytrade.shtml.
Adobe, the Adobe logo, and PostScript are either registered trademarks or trademarks of Adobe Systems Incorporated in the United States, and/or other countries.
Intel, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries.
Java and all Java-based trademarks and logos are trademarks or registered trademarks of Oracle and/or its affiliates.
Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both.
Microsoft, Windows, and Windows NT are trademarks of Microsoft Corporation in the United States, other countries, or both.
UNIX is a registered trademark of The Open Group in the United States and other countries.
Other company, product, or service names may be trademarks or service marks of others.
Contact support: https://support.hcltechsw.com/csm
© Copyright HCL Technologies Ltd. 2017, 2026. All Rights Reserved.
n and
performance issues.
II. INFORMIX-Enterprise Gateway Manager User Manual
A. Limitation on Amount of Blob Data per Set of Rows
that is Returned to the Client
The information in this section supplements the discussion
of "Blob Data Type Support Considerations" on page 5-82.
In distributed-access mode, or when processing a singleton
SELECT or singleton EXECUTE PROCEDURE statement, the Gateway
Manager buffers all the blob data returned in each set of rows
in a single temporary file.
A single file can contain 2 gigabytes of data. In rare cases,
this temporary file might not be big enough because a single
blob can contain 2 gigabytes of data. If the total amount of
blob data in a set of rows exceeds 2 gigabytes, the Gateway
Manager returns an error to the application.
File size is not a limitation in direct-access mode with a
non-singleton SQL statement because the Gateway Manager does
not buffer the blob data in a file.
If this 2-gigabyte limitation is a problem, do the following:
- In direct-access mode, do not use a singleton SELECT or
singleton EXECUTE PROCEDURE statement. Instead, declare and
use a cursor.
- In distributed-access mode, set the FET_BUF_SIZE environment
variable to reduce the size of the set of rows for the query.
Also, if necessary, replace your query with a set of queries,
where each query selects exactly one row and only one blob
column per row.
B. Set the INFORMIXSERVER Environment Variable if Using
the Informix ODBC Driver
The information in this section supplements the discussion
of "Using the Informix ODBC Driver with the Gateway Manager"
on page 3-34. It is step 4.
1. Set the INFORMIXSERVER environment variable to the Gateway
Manager server name before starting the Gateway daemon.
If you do not do this, you will get the following error at
connection time:
-29080: Target DBMS Error ([-25560 S1000 :00.00.0000]
Environment variable INFORMIXSERVER must be set.
=================================
(c) Copyright IBM Corp. 2002, 2017
(c) Copyright HCL Technologies Ltd. 2017, 2026. All Rights Reserved.
