Release 10.1A: OpenEdge Getting Started:
New and Revised Features

> ## SQL

> OpenEdge Release 10.1A includes the following SQL enhancements:

> - Support for auditing, including the:

> - Addition of `AUDIT INSERT` and `AUDIT SET` statements.
> - Ability to grant and revoke audit privileges.
> - The ability to set Progress 4GL table and column attributes using `ALTER TABLE`, `CREATE TABLE`, and `CREATE INDEX`.

> - The ability to create active indexes using the `CREATE INDEX` statement.

> - The ability to run the following statements against an online database:

> - `ALTER TABLE ADD COLUMN`
> - `CREATE VIEW`
> - `CREATE PROCEDURE`
> - `CREATE TRIGGER`
> - `SET PRO_SERVER LOG` and `SET PRO_CONNECT LOG`, which allow you to control logging for SQL Servers.

> - The removal of the `SQL_WIDTH` limitation on the `SUBSTR` and `SUBSTRING` functions.

> - Support for the `ARRAY` data type.

> - The `VARARRAY` data type, which allows its elements’ values to exceed the declared size while the total size is limited by `SQL_WIDTH`.

> - Support for the Java Transaction API (JTA), which allows applications to perform distributed transactions.

> - ODBC driver with Unicode support.

> - Type 4 JDBC driver.

> For more information, see:

> Manuals: | OpenEdge Data Management: SQL Development OpenEdge Data Management: SQL Reference

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095