RELEASE NOTES FOR
Informix ESQL/C Programmer's Manual
DATE 10/17/00
Version 9.50
Table of Contents
I.Overview
II.New Features
A. Syntax changes in SQL to support Latest 9.x product
B. Syntax changes in SQL to support 8.31 product
III.Fixed Problems
I.OVERVIEW
=============
The purpose of these release notes is to make you aware of any special
actions required to configure and use Informix ESQL/C on your computer.
This file also describes new features and feature differences from earlier
versions of this product and other Informix products, and how these
differences affect current products. In addition, this file contains
information about known bugs and their workarounds.
This release notes document is not intended to be all-inclusive; it should
be used as an addendum to the Informix ESQL/C Programmer's Manual, which
provides thorough information about product features and behavior.
These release notes are written for the following audience
o System administrators who install Informix database servers
o Database administrators who control access to Informix databases
o Developers who write applications using Informix ESQL/C
Version 9.50 of Informix ESQL/C has been tested with the following
database server configurations
o Informix Dynamic Server, Version 5.10
o Informix Dynamic Server, Versions 7.24 and 7.3x
o Informix Dynamic Server with Advanced Decision Support and Extended
Parallel Options, Version 8.21 and Extended Parallel Server, Version
8.3x
o Informix Dynamic Server with Universal Data Option, Version 9.2x
(Windows NT) and Informix Dynamic Server 2000, Version 9.2x (UNIX)
o Informix SE 7.24
Informix ESQL/C includes source code files for many of the examples in the
Informix ESQL/C Programmer's Manual. The installation process copies these
source code files into the following directory $INFORMIXDIR/demo/esql
For more information about the example files for Informix ESQL/C, see the
Introduction to the Informix ESQL/C Programmer's Manual.
II.NEW FEATURES
=================
A. Syntax changes in SQL to support latest 9.x product
The following are syntax changes in SQL to support new features in the
latest 9.x product. Refer to ESQL/C doc notes for more details.
Feature 1. ISTAR Changes
Feature 2. Sequences
Feature 3. Configurable default Lock Mode
Feature 4. Display All Query Plans
Feature 5. EXPLAIN with NOEXECUTE
Feature 6. Implicit Transactions
Feature 7. NULL within SQL statements
Feature 8. Optional from in delete
Feature 9. Order by on expressions
Feature 10. Truncate Table
Feature 11. Revoke As
B. Syntax changes in SQL to support 8.31 product
Refer to ESQL/C doc notes for more details.
Feature 12. Duplicate table to address the XPS server.
III.FIXED PROBLEMS
===================
The following problems pertaining to ESQL/C have been fixed in CSDK 2.60
release.
---------------------------------------------------------------------------
| number | problem |
|-------------------------------------------------------------------------|
| 131096 | COMPILATION OF .EC FILE PRODUCES EXTRA MESSAGES WHEN |
| | SYNTAX ERROR OCCURS |
---------------------------------------------------------------------------
| 132428 | FE CLIENT DOES INFINITE LOOP IN _IWRITE FUNCTION WHEN |
| | REMOTE ENGINE IS SHUTDOWN AND THEN CLIENT ESQLC |
| | SHUTDOWN AND THEN CLIENT ESQLC PROGRAM ISSUES AN |
| | EXECUTE DOING BLOB INSERT |
---------------------------------------------------------------------------
| 131207 | ESQL/C DOESN'T SUPPORT PASSING AN ARGUMENT TO |
| | SQLBREAKCALLBACK() FUNCTION |
---------------------------------------------------------------------------
| 131652 | SQLIPRINT OUTPUTS INCORRECT ERROR MESSAGE WHEN TESTING|
| | WITH OPTMSG AND OPTOFC ENVIRONMENT VARIABLES |
---------------------------------------------------------------------------
| 103627 | ERROR INVALID MSG TYPE 0 RESET MESSAGE TO SKIP |
| | FORWARD TO NEXT PACKET, ERROR DIR EXPECTED |
---------------------------------------------------------------------------
| 132182 | ESQL -V GIVES [1]+DONE(139) ESQL -V SEGMENTATION |
| | VIOLATION ESQL ALONG WITH THE PROPER VERSION (SEEN |
| | ONLY ON WIN2K AND NOT ON WIN-NT) |
---------------------------------------------------------------------------
| 127731 | INSERT USING ARITHMATIC EXPRESSION FAILS |
---------------------------------------------------------------------------
| 132391 | SQLI CODE DOES NOT SUPPORT 8.31 SERVER FOR XA CODE |
---------------------------------------------------------------------------
| 131702 | WHEN A SELECT STATEMENT HAS A VARIABLE OF TYPE VARCHAR|
| | IN ITS WHERE CLAUSE, A CORE DUMP OCCURS |
---------------------------------------------------------------------------
| 132036 | THE FUNCTION RFMTNUM() DUMPS CORE WITH FORMAT-STRING. |
---------------------------------------------------------------------------
| 130081 | SQLIPRINT REPORTS ERROR INVALID MSG TYPE 0 (0X0). |
| | HAPPENS ONLY ON 9.3 |
---------------------------------------------------------------------------
| 119441 | BUS ERROR IN ESQLC/DML/SRC/MIS009A.JOB |
---------------------------------------------------------------------------
| 125112 | INSERTING VARCHAR DATA MORE THAN DECLARED SIZE CAUSES |
| | SERVER TO CRASH |
---------------------------------------------------------------------------
| 120240 | ESQL/C PREPROCESSOR DOES NOT CORRECTLY INTERPRET |
| | QUOTED STRING PASSED THROUGH COMMAND LINE OPTION -ED |
| | ON WINDOWS NT |
---------------------------------------------------------------------------
| 132001 | PREPARE STATEMENT FAILS WITH ASIAN CHARACTERS. ERROR |
| | RETURNED = -202 |
---------------------------------------------------------------------------