Empress Software V8.62 Version Notes
Empress v8.62
May 2006

© 1983, 2006 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.

05/06

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