| V8.62 Version Notes Empress v8.62 January 2003
--- | ---

  © 1983, 2003 Empress Software Inc.

  All rights reserved. Reproduction of this document in whole or part, by electronic or any other means, is prohibited without written consent from Empress Software Inc.

  RESTRICTED RIGHTS LEGEND

  Use, duplication, or disclosure by the Government is subject to restrictions as set forth in
  subparagraph (c) (1) (ii) of the Rights in Technical Data and Computer Software clause at 52.227-7013.

  09/02

  Part #: 002-02-V1-100

  This document provides information on the latest features, enhancements and the compatibilities of the new release for both software and the documentation.

  ## Table of Contents

  ### CHAPTER 1: Overview

  ### CHAPTER 2: Product New Features and Enhancements

  | 2.1 | Case Insensitivity Support
  | 2.2 | Using Empress Dynamic/Embedded SQL in Persistent Stored Modules
  2.2.1 | How To Compile PSM Routines Written By DSQL/ESQL
  2.2.2 | New Reserved Cursor Names Used in Triggers
  2.2.3 | ABORT TRIGGER
  2.2.4 | Memory Allocation
  2.2.5 | INIT and EXIT
  | 2.3 | Empress Performance Improvement
  | 2.4 | Database Roles
  | 2.5 | SQL Extension
  | 2.6 | Data Type Conversion Improvement For SET Operation
  | 2.7 | New Variables
  | 2.8 | User Defined Lock Granularity
  | 2.9 | Triggers On Select Statements
  | 2.10 | Multi-Threaded Clients
  | 2.11 | Empress JAVA Interactive SQL
  | 2.12 | Support for ANSI SQL-99 SET Operations
  | 2.13 | Support for ANSI SQL-99 Outer Joins
  | 2.14 | Empress Import Utility Enhancement
  | 2.15 | Reserved Keywords
  | 2.16 | Support for Java Data Sources and JNDI
  | 2.17 | ODBC Interface
  2.17.1 | ODBC Local Access via ODBC Manager
  2.17.2 | Multiple Connections in Local Access Mode
  2.17.3 | Empress ODBC Data Source Name Setup Improvement
  2.17.4 | Providing standard (default) labels for ODBC Drivers in Data Sources
  2.17.5 | Compliance to Microsoft .NET Technologies
  | 2.18 | Scrollable Cursor Functionality

  ### CHAPTER 3: Compatibility

  | 3.1 | Syntax Compatibility

  ### CHAPTER 4: Packaging and Installation