IBM Informix Embedded SQLJ RELEASE NOTES

## RELEASE NOTES

## FOR

## IBM Informix Embedded SQLJ 1.01.JC2

## DATE: December 2001

## Table of Contents

I. OVERVIEW OF RELEASE NOTES
II. SQLJ REFERENCE IMPLEMENTATION
III. SUPPORTED PLATFORMS
IV. INFORMIX SERVER COMPATIBILITY
V. SUPPORTED FEATURES
VI. ON-LINE USER'S GUIDE
VII. SAMPLE PROGRAMS
VIII. KNOWN PROBLEMS
IX. FIXED PROBLEMS

## I. OVERVIEW OF RELEASE NOTES

The purpose of these release notes is to make you aware of any special actions required to configure and use IBM Informix Embedded SQLJ on your computer. This file also 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 IBM Informix Embedded SQLJ User's Guide, which provides thorough information about product features and behavior.
These release notes are written for the following audience:

- System administrators who install IBM Informix Embedded SQLJ
- Database administrators who control access to IBM Informix Dynamic Server databases
- Developers who write applications using IBM Informix Embedded SQLJ

## II. SQLJ REFERENCE IMPLEMENTATION

Version 1.01.JC2 of IBM Informix Embedded SQLJ is based on the SQLJ Reference Implementation Version 1.0.1.1. See the SQLJ Web site, www.sqlj.org, for standard specifications, documentation, tutorials, the Reference Implementation software, and many other resources.

## III. SUPPORTED PLATFORMS

Version 1.01.JC2 of IBM Informix Embedded SQLJ has been tested on Solaris and Windows 2000, working with the Type 4 IBM Informix JDBC Driver, Version 2.x, using JDK1.2 or later.

## IV. INFORMIX SERVER COMPATIBILITY

Your IBM Informix Embedded SQLJ programs use IBM Informix JDBC Driver to access Informix database servers. The following versions of Informix database servers are compatible with IBM Informix JDBC Driver:

- IBM Informix Dynamic Server, Version 7.x
- IBM Informix Dynamic Server, Workgroup and Developer Editions, Version 7.x
- IBM Informix Dynamic Server with Advanced Decision Support and Extended Parallel Options, Version 8.x
- IBM Informix Dynamic Server with Universal Data Option, Version 9.x
- IBM Informix-OnLine Dynamic Server, Version 5.x

If you are using a Version 5.x server, specify the environment variable USEV5SERVER=YES in the database URL or property list when you make a connection to a database.

## V. SUPPORTED FEATURES

JDBC 1.2 features are supported in this release. JDBC 2.0 features are not supported.

## VI. ON-LINE USER'S GUIDE

A PDF version of the IBM Informix Embedded SQLJ User's Guide is included in the product distribution in the following location:

> $IFXJHOME/doc/release/sqlj/sqlj.pdf

$IFXJHOME refers to your IBM Informix Embedded SQLJ and IBM Informix JDBC Driver installation directory.

## VII. SAMPLE PROGRAMS

IBM Informix Embedded SQLJ includes sample on-line programs in the $IFXJHOME/demo/sqlj directory. The README file in this directory briefly explains what each of the programs demonstrates and how to set up, compile, and run the programs. The programs also enable you to verify that IBM Informix Embedded SQLJ and IBM Informix JDBC Driver are correctly installed. These sample programs are modified and updated versions of the examples included in the IBM Informix Embedded SQLJ User's Guide.

## VIII. KNOWN PROBLEMS

This section describes known problems with this release of IBM Informix Embedded SQLJ and shows how to work around these problems.
KBP001
In your path, you must place your JDK/bin directory before any other directory that might contain a directory named "java".
This is because the IBM Informix Embedded SQLJ tools (ifxsqlj, ifxsqljc, ifxprofp) use java.lang.Runtime.exec("java ...") to execute the underlying Reference Implementation tools. This method searches your PATH to find a Java virtual machine, "java".
If, in your PATH, any directory containing a "java" directory exists before the intended JDK/bin directory, the method picks up the wrong "java" directory and returns the following error: java.lang.IOException:java:cannot execute.

## IX. FIXED PROBLEMS

148095

119172

Use the following syntax to execute functions :

> #sql { EXECUTE FUNCTION <function name>() INTO :<hostvar> };