===============================================
                               RELEASE NOTES
                                    FOR
                    INFORMIX-SE 7.24.UC5 PRODUCT RELEASE
		               DATE: 10 July 1998
               ===============================================


TABLE OF CONTENTS

I.    OVERVIEW OF RELEASE NOTES

II.   PRODUCTS CONTAINED IN THE 7.2 STANDARD ENGINE & EMBEDDED PRODUCTS

III.  LIMITS IN INFORMIX-SE

IV.   INFORMIX-ESQL/C
     
V.    SYSTEM COMMANDS IN STORED PROCEDURES

VI.   KNOW PRODUCT DEFICIENCIES

VII.  FIXED CUSTOMER-REPORTED PROBLEMS


======================================
I.    OVERVIEW OF RELEASE NOTES

The purpose of these release notes is to make the user aware of changes
in products that might affect existing applications. The release notes
contain information on changes from previous versions, known bugs, and
workarounds. Bug numbers are assigned to known defects to assist you in
identifying the defects to Customer Services personnel.

The release notes document is not intended to be all-inclusive; it is a
tool to assist you in the update process. Please consult Informix product
manuals for additional information on product features and for clarification
of product behavior.


======================================
II.   PRODUCTS CONTAINED IN THE 7.2 STANDARD ENGINE & EMBEDDED PRODUCTS

-----------------
INFORMIX PRODUCTS
-----------------
The following products are contained in the 7.2x servers and connectivity
products:

Product Name                Generic Name
----------------------      ---------------------------------
INFORMIX-ESQL/C             SQL Application Program Interface

INFORMIX-Connect            Runtime Facility
   (formerly known as
   INFORMIX-ESQL
   Runtime Facility)

INFORMIX-SE                 Database Server Product

------------
NEW FEATURES
------------
The following major features have been introduced in the 7.2x servers,
connectivity, and embedded products releases:

INFORMIX-ESQL/C Features
------------------------

   - OPTOFC environment variable
   - OPTMSG feature
   - Array Fetch feature
   - Deferred Prepare feature
   - Multiplexed connections


Multiplexing Connections
------------------------
The database server handles a large number of connected clients more
efficiently, because ODS 7.24.UC4 provides:

   - Multiplexed connections
   - Networking system call optimizations

Multiplexed Connections

The OnLine 7.23.UC4 multiplexed connection facility provides the ability for
one network connection in the database server to handle multiple database
connections from an ESQL/C application to this database server. Non-threaded
client applications can realize an improvement in response time when
using multiplexed connections.

For more information, see the documentation notes in the ESQLCDOC_7.2 file
provided with this release.

Networking System Call Optimizations

7.23.UC4 provides an overall system performance improvement due to some
networking system call optimizations.


======================================
III.    LIMITS IN INFORMIX-SE

	Number of indexes................................no logical limit
	Max Bytes per index...........................................120
	Max number of columns in composite index........................8
	Number of tables.................................no logical limit
	Row size...................................................32,511
	Maximum number of rows.........................................2g
	Maximum table size.............................................2g


======================================
IV.     INFORMIX-ESQL/C

------
LIMITS
------

	Size of host object name................................132 chars
	Size of host object subscript...........................132 chars
	Size of indicator object name...........................132 chars
	Size of value for fetch relative........................132 chars
	Size of SQL identifier (table name, etc)................132 chars
	Size of number constant.................................132 chars
	Size of macro name......................................132 chars
	Size of macro value.....................................132 chars
	Size of statement name..................................132 chars
	Size of quoted string literal..........................1024 chars
	Number of statement_ids..........................machine specific
	Number of levels of host-language block nesting................32
	Number of levels of include-file nesting..................dynamic
	Length of line..........................................512 chars
	Size of statement label.................................132 chars
	Number of nested records.......................................16

-------------------------------------------
COMPILING AND UPGRADING ESQL/C APPLICATIONS
-------------------------------------------
The esql command executes a script that ensures appropriate libraries are
linked into the resulting program. The libraries referenced by the esql
script may change across versions of ESQL/C. If makefiles are used for
compiling an application, it is recommended that the makefile references
the esql script directly. This supported compilation practice prevents
difficulties that could otherwise be encountered during an upgrade.

You do not need to relink an existing ESQL/C application (versions before
7.23.UC4) to enable it to communicate with a 7.23.UC4 multiplexing database
server. However, the application continues to use normal connections, not
multiplexed connections.

To use multiplexed connections, you must relink an ESQL/C application.
Once you relink the application with the 7.23.UC4 ESQL/C libraries, it
can use multiplexed connections when it connects to a 7.23.UC4 database
server. Only the 7.23.UC4 version database servers support multiplexed
connections. Therefore, if a 7.23.UC4 ESQL/C application connects to a
database server that is not version 7.23.UC4, it establishes normal connections.


======================================
V.  SYSTEM COMMANDS IN STORED PROCEDURES

System() commands in stored procedure are executed only if the current
user executing the stored procedure has logged on using a password.

When you execute a system() command in a stored procedure, the database
server waits for the outcome of the execution of the system command. The
client application can hang if the system() command never completes or
never returns.


======================================
VI.   KNOWN PRODUCT DEFICIENCIES

The following defects are known to exist in the current release of
INFORMIX-Standard Engine 7.24. The defects are listed by PTS (Problem
Tracking System) number followed by a brief description.


---------- PRODUCT: BACKEND ----------

68654   CREATE VIEW WITH SELECT COUNT CAUSES ASSERT FAIL

75144   LOCKS RELEASED FOR CONSTRAINTS ON A MASTER TABLE WHEN AN INSERT
IS PERFORMED ON A DETAIL TABLE.

75157   SE CRASHES WITH -25587 OR -457 IF WE DO AN SELECT WITH ""
(EMPTY STRING) AND A GROUP BY OR ORDER BY CLAUSE.

75422   PERFORMANCE OF STANDARD ENGINE 7.X IS SLOWER THAN 4.1X.

78322   UPDATE STATISTICS MEDIUM DOES NOT ACCEPT GLS SPECIFIC DECIMAL
SEPARATOR IN THE RESOLUTION CLAUSE, ".

78927   GETTING ISAM ERROR -100 DUPLICATE VALUE FOR A RECORD WHEN
TAKING A DBSCHEMA OVER AN ALTERED TABLE. THIS IS AN INTERMITTENT PROBLEM.


---------- PRODUCT: DBACCESS ----------

55694   LOAD/DBLOAD WILL RESULT IN A CORE DUMP AT EXIT OF DBACCESS WHEN
INSERTING GREATER THAN 32767 CHARACTERS INTO COLUMN DEFINED AS CHAR 32767.

57428   PIPING INPUT TO DBACCESS AND THEN PIPING OUTPUT TO MORE WILL
RESULT IN MANY 25587 ERRORS AND MULTIPLE SESSIONS IN ONLINE WHEN INTERRUPTED
(CTRL^C).

71555   DBACCESS CORE DUMPS ON CTRL-C INTERRUPT: "SENDSIG:CAN'T GROW
STACK, PID <>, PROC DBACCESS, SIG 11, PC 0X3FF804BD7A.

71988   CHARACTER STRINGS CONTAINING ASCII-0 ARE TRUNCATED IN SELECT
STATEMENT.

74346   DBACCESS: STATUS ON TABLE WHERE QUOTED NAME != UNQUOTED NAME FAILS.

74599   ADDING A COLUMN IN DBACCESS SE 5.08 THROUGH ALTER TABLE GIVES
INCORRECT -253 ERROR.

75140   THERE SHOULD BE A WAY TO KEEP A USER IN A ROLE FROM SETTING THE
ROLE MANUALLY IN DBACCESS OR ISQL.

75154   DBACCESS-QUERY LANGUAGE-USE EDITOR DOES NOT WORK IF THE
ENVIRONMENT VARIABLE DBEDIT IS SET TO THE PATH TO THE EDITOR
(/USR/BIN/VI).

79959   DBACCESS, TABLE, ALTER RESULTS IN ERROR -586, IF ANSI DATABASE
CONTAINS MORE THAN ONE CONSTRAINT.

80214   DBACCESS/DBEXPORT: FLOAT OR DOUBLE PRECISION COLUMNS ARE LOSING
DIGITS IF VALUES ARE <1E-125 OR >1E125 WHEN UNLOADED (DBACCESS)
OR EXPORTED (DBEXPORT).


---------- PRODUCT: DBATOOLS ----------

54311   DBIMPORT WITH BLOCKSIZE OF 32 AND TAPESIZE OF 2097151 CAUSES
READ TAPE FAILED MESSAGE AT END OF FIRST TAPE.

55221   PREPARE SQLOBJ ERROR W/ 229 ON LARGE DBIMPORT.

57200   DBIMPORT OF A TRIGGER WITH MANY PARTS CAUSES STACK OVERFLOW
-762 ERROR.

69632   CREATE TABLE FAILS WITH -204 ERROR ON A FLOAT COLUMN WITH LARGE
DEFAULT VALUE THAT HAS BEEN EXPANDED BY DBEXPORT OR DBSCHEMA.

69890   CUSTOMER WANTS DBIMPORT/DBEXPORT TO STORE FILL FACTOR INFO.

71695   UNLOAD DOESN'T POPULATE FIELDS FOR COLUMNS DEFINED AS DATE IF
DBDATE IS SET TO NULL OR TO AN INVALID VALUE.

73869   DBSCHEMA/DBEXPORT BUS ERROR (CORE) - DBSCHEMA -F ALL -D DATABASE
NAME AND DBEXPORT -T TABLE NAME -D DATABASE NAME RESULT IN CORE DUMP/BUS ERROR.

75531   DBSCHEMA ON STANDARD ENGINE 7 TAKES LONGER THAN DBSCHEMA ON
STANDARD ENGINE5...USING TRANSACTION LOGGING.

76967   DBSCHEMA CREATES WRONG SQL STATEMENT IF IN A VIEW THE KEYWORD
INTERVAL IS USED.

78323   ERROR -740 IN DBIMPORT, DBEXPORT GENERATES SYNTAX ERROR IN .SQL FILE
WHEN DECIMAL SEPARATOR IS NOT "." (E.G. DBMONEY=, OR
CLIENT_LOCALE=DE_DE.8859-1).

78622   UNLOADING ZERO-LENGTH VARCHAR STRINGS CREATES NULL STRINGS IN
UNLOAD FILE WHICH RESULTS IN NULL VALUES WHEN RELOADING THIS FILE!

78163   DBIMPORT REPORTS ERROR " IMPORT DATA IS CORRUPTED! " EXECUTING
CREATE VIEW STATEMENT,IF USING KANJI(MULTI BYTE)NAME AS COLUMN
NAME OF VIEW.


---------- PRODUCT: ESQL/C ----------

42204   DISCONNECT STATEMENT DOESN'T WORK WITH INFORMIX 5 ENGINES.

55739   ESQL/C GENERATED CODE CANNOT BE COMPILED BY C++ COMPILERS.

66712   ESQLDEMO7 IN DEMO1.EC,DEMO2.EC,DEMO3.EC,DEMO4.EC, STORES7:
CUSTOMER FETCH ERROR (SQLSTATE AFTER FETCH IS 01004).

69621   SOLARIS 2.5 7.20UC2 ESQL/C /W MALLOC() OVER 9MB CAUSES -25588 ERROR.

70127   IN ESQLC, IF YOU USE THE SQLEXIT FUNCTION AFTER A CLOSE DATABASE
STATEMENT AND YOUR LOCAL INFORMIX SERVER IS SHM IT WILL USE MORE THAN ONE
CONNECTION.

72277   SQLCA.SQLWARN.SQLWARN1 IS SET TO 'W' ON FETCH IF
CLIENT_LOCALE=JA_JP.SJIS-S & DB_LOCALE=JA_JP.UJIS.

74204   FINDERR DOES NOT GIVE ANY DESCRIPTION FOR ERROR MESSAGES 1826
AND 1827.

74362   DECFCVT FUNCTION GIVES WRONG RESULTS WITH ESQL/C D.

77096   7.21.UD1 - LIBINFXXA.SO NOT BUNDLED IN RUN-TIME I-CONNECT.

77240   GET DIAGNOSTICS STATEMENT CORE DUMPS WHEN USING AN ERROR
GENERATED FROM RAISE EXCEPTION.

77938   ESQL/C REPORTS WRONG LINE NUMBER ERROR IF ERROR IS AFTER A
MULTI-LINE ESQL/C COMMAND SUCH AS "EXECUTE PREPARED_STMT INTO
:HOSTVAR1..."

78284   FETARRSIZE RETURNS WRONG VALUES FOR CHARACTER COLUMNS.

79088   ESQL/C COMPILE TIME ERROR WHEN PREPARE STATEMENT IS A CERTAIN
LENGTH AND A $DEFINE AND $STRUCT ARE ALSO PRESENT.

79155   -404 ON AN OPEN CURSOR IF RDS CUSTOM RUNNER IS MADE USING 6.X RDS
AND 7.X ESQL/C.

79967   INCLUDING WRONG HEADER FILES CAN CAUSE 482 ERROR ON SECOND FETCH OF
CURSOR.

80132   ESQL/C MEMORY LEAKS.


---------- PRODUCT: SE     COMPONENT: ASF ----------

72414   ONLINE FAST SUCCESSIVE TCP/IP CONNECT REQUESTS RETURN 908 TO
APPLICATION.

72995   25588 ERROR WHEN RUNNING COBOL JOB ON 7.22.UC2 ON SOLARIS 2.5/2.5.1.

74414   ONLINE WON'T COME UP IF THE ENGINE WAS ABORTED ABNORMALY AND
IPCSTR IS CONFIGURED. IT FAILS WITH ERROR 25572 AND SYSTEM ERROR 226.

75527   EVEN WHEN SYSTEM IS CONFIGURED TO USE NIS FIRST, ONLINE WILL
STILL USE DNS, AND ONLY DNS, UNDER HP-UX 9.0X, EVEN WITH THE HP-UX PATCHES
INSTALLED.

76959   SELECT PRIVILEGE IN A SELECT * FROM DB@REMOTE_SERVER:TABLE FOR
A USER SPECIFIED IN .NETRC ON CLIENT MACHINE IS NOT EVALUATED CORRECTLY.

77445   IF YOU TELNET TO THE PORT THE LISTENER THREAD IS USING YOU
MIGHT CAUSE THE LISTENER THREAD TO SEGV.

77521   CUSTOMER RUNS VISUAL BASIC APPLICATION WHICH CAUSES RALLOC STACK TO
OVERFLOW, RESULTING IN ENGINE CRASH.

78606   A USER CAN LOG INTO A SERVER AS ANY USER THAT IS TRUSTED ON THAT
MACHINE BY PUTTING AN ENTRY IN THEIR .NETRC WITH THE USER NAME BUT NO PASSWORD.


---------- PRODUCT: ONLINE     COMPONENT: EX ----------

58130   SEGV OR "CONDITION HAS WAITING THREADS" WITH XCHG JOINS.

50858   AFTER "SET EXPLAIN ON", EXECUTING "SELECT * FROM TABLE" CLASS
THIS OCCURRED "ASSERT FAILED: INTERNAL ERROR - SEGMENTATION VIOLATION".

53991   DEFINING A COLUMN OF TYPE MONEY CONTAINING A NEGATIVE VALUE
SHOWS NEGATIVE SIGN AFTER THE VALUE IN DBACCESS AND IN DBIMPORT UNLOAD FILE.

57522   INCONSISENT  FORMATTING OF 0.00 ON DIFFERENT PLATFORMS USING
UNLOAD SQL STATEMENT AND COLUMN TYPE FLOAT.

60150   EVEN WITH DBCENTURY SET "02/29/00" IS TREATED AS AN INVALID DATE.

64109   THE UNLOAD CANNOT EXPORT (OR IMPORT) FLOAT COLUMNS WHICH ARE
EQUAL TO 0.

68864   ONLINE GOT ASSERT FAILED IF THERE ARE "SET DEBUG FILE" AND
"TRACE ON" STATEMENT ON STORED PROCEDURE.

77470   DBAPICODE AND CHARACTER CONVERSION DOES NOT WORK PROPERLY,
FOUR RELATED PROBLEMS.

77782   "SET EXPLAIN ON" CAUSESE ASSERT FAILED: INTERNAL ERROR -
SEGMENTATION VIOLATION.

78594   COMPARING DATE TO EMPTY STRING RETURNS NO VALUES.



---------- PRODUCT: SE     COMPONENT: SQL ----------

56931   ENGINE CRASHES WITH ARITHMETIC EXCEPTION IN RELEASE_CACHE WHEN
DS_POOLSIZE SET TO 0.

60531   QUERY TO GROUP NAME INSTEAD OF DBSERVER NAME HANGS.

67022   OPTIMIZER CHOOSES SEQUENTIAL SCAN FOR COMPLEX OR-CONDITIONS.

69952   CURRHEAP POINTER MIGHT BE NULL, BUT THERE IS A DEREFERENCE IN
RUALLOC(): GENLIB/RALLOC.C THAT SENT SERVER DONE.

72444   STORED PROCEDURE THAT USES UNIQUE OR DISTINCT CLAUSE AND
PDQPRIORITY WILL CAUSE MEMORY LEAK AND PERFORMANCE DEGRADATION.

73439   FRAGMENTING A TABLE BY A DATE COLUMN GIVES INSERT ERRORS
(271/833) AND WRONG QUERY PLANS LEADING TO LONG QUERIES AND WRONG RESULTS.

74455   SELECT SUM() IN STORED PROCEDURE WITH PDQ SET LEAKS RALLOC MEMORY.

76958   UPDATE STATISTICS ON A NON-LOGGED DATABASE WITH MANY STORED
PROCEDURES CAN CAUSE ASSERT FAILURE IF DBDATE DOES NOT MATCH THE DATES
IN THE PROCEDURES.

76963   SEGV/SIGBUS ENGINE CRASH RUNNING QUERY WITH LIKE/MATCHES AND
ESCAPE CLAUSE.  ALSO INCORRECT QUERY RESULT WITH SAME QUERY.

77393   PTS BUG 41667 REAPPEARS IN 7.22 DUE TO A CHANGE DONE TO SUPPORT CDR.

77594   ADD CONSTRAINT FOREIGN NOT PARALLEL IN VERSION 7.

77685   4GL RETURNS -750 IF RUN WHEN UPDATE STATISTICS IS RUN AGAINST
TABLE USED.

77767   GET ERROR 23114, SELECT VARCHAR COL WHICH HAS HANKAKU-KATAKANA
JAPAN CHAR.

78013   AN "OR" OF TWO "WHERE" CLAUSES WHICH SEPERATELY USE INDICES
PRODUCES A QUERY PLAN USING SEQUENTIAL SCAN WHEN TOGETHER.

78315   SELECTING FROM REMOTE DATABASE LEAVES SHARED LOCK ON DATABASE.

78328   UPDATE STATISTICS HIGH RETURNS -243/-103 IF ONE INDEX OF TAB IS
DISABLED.

78676   CANNOT SELECT THE ROW WHICH DATA HAS "5C" CODE CHARACTER WITH
OPTCOMPIND=0.

78924   PREPARE ON UPDATE STMT GIVES -710 ON TABLE THAT IS REFERENCED
VIA FOREIGN KEY W/ ON CASCADE DELETE AFTER SECOND INDEX WAS DROPPED AND
RECREATED.

78956   ASSERT FAILED: READ_RECORD: DELETED ROWID = X PARTNUM = Y;
RECORD NOT READ IF MULTIPLE INSTANCES OF SAME PROGRAM IS RUN WHICH SELECTS
AND DELETES.

79006   WANT SUB SELECT AVAILABILITY.

79090   SELECT MAX (COL) FROM TABLE WHERE COL < CURRENT - 20 UNITS MINUTE
QUERY RUNS VERY SLOWLY IN OPTIMISED ENVIRONMENT 7.

79110   ASSERT FAILURE: ARITHMETIC EXCEPTION IN ONLINE.LOG, -847 FLOATING
POINT EXCEPTION FROM SQL ON SCO.

79210   NO LOGGING DATABASE WITH A SELECT AND AN UPDATE CURSOR DOES NOT
FREES LOCKS AFTER FREEING UPDATE CURSOR.

79452   CUSTOMER IS SEEING A MEMORY LEAK WHEN USING SUBSCRIPTING WITHIN
A FOREACH STATEMENT OF A STORED PROCEDURE.

79489   -1213 CHARACTER TO NUMERIC CONVERSION ERROR WHEN DOING SIMPLE
SELECT OF A MONEY TYPE FIELD WITH WHERE CLAUSE FROM ONLINE 7.x TO ONLINE 5.x
ENVIRONMENT.

79577   ONLY WRONG NUMBER OF ROWS RETURNED IN SELECT STMT WITH OUTER JOIN
AND DISTINCT AND SUBSTRING.

79641   SELECT STMT WITH SUB QUERY IN SELECT LIST AND OUTER JOIN ON REMOTE
TABLE INTO TEMP WILL SEG V IN OPBLDREMOTE.

79701   A SELECT ON A SUBSTRING WITHIN A VIEW BETWEEN 2 TABLES RETURNS
NO ROWS.

79834   INCONSISTENT ENFORCEMENT OF PRIMARY CONSTRAINT.

79902   ON VERSION 7.22 SETTING DBMONEY AS "," AND DOING A DBEXPORT, THE
.UNL FILE WILL CONTAIN "." AS THE DECIMAL POINT.

80146   ASSERT FAILED IF YOU SELECT DATA FROM A TABLE HIERARCHY WITH A
SIMPLE OUTER JOIN.

80165   CUSTOMER RUNNING TWO INSTANCES ON DIFFERENT SERVERS, GOT ERROR
201 WHEN EXECUTED TRIGGER.


---------- PRODUCT: UTIL ----------

36570   DBEXPORT -Q DB GIVES "DBEXPORT COMPLETED" ALSO WHEN THE COMMAND
FAIL BECAUSE THE SYSTEM IS FULL.

53418   DBLOAD HAS MEMORY ALLOCATION ERROR IF USING LARGE -N VALUES AND
LOADING MANY TABLES FROM A SINGLE COMMANDFILE.

65099   DBSCHEMA -D DBNAME -T * ZEROES OUT ALL THE FILES IN YOUR CURRENT
DIRECTORY.

79536   ERROR "CANNOT LOCK TABLE (USER.TB1) IN REQUESTED MODE" IF YOU
LOAD DATA WITHIN A LOOP IN A DATABASE WITH LOGGING AND A TABLE
WITH A PRIMARY KEY.


---------- PRODUCT: UTIL       COMPONENT: GLS ----------

66347   UNDER THE CLIENT_LOCALE UJIS AND DB_LOCALE SJIS (CODE
CONVERSIO ON), THE DBLOAD UTILITY COULD NOT TO SUPPORT HANKAKU-KANA
STRINGS IN LOAD FILE.

71077   UNDER THE CLIENT_LOCALE JA_JP.UJIS AND DB_LOCALE JA_JP.SJIS.
AFTER DBEXPORT, THE HANKAU-KATAKANA-DATA (CODE OF EUC) IS TRUNCATED IN
UNLOAD FILE.


======================================
VII.     FIXED CUSTOMER-REPORTED PROBLEMS

This is the first release of INFORMIX-SE and ESQL/C products on Linux.
If you have used INFORMIX-SE or ESQL/C on other UNIX platforms, please
refer to the release notes for INFORMIX-SE and ESQL/C 7.24.UC5 on that
platform for details on historical bugs fixed in this release.