Kbase P114730: SQL: What are the new SQL features in OpenEdge 10.1A?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/3/2008 |
|
Status: Verified
GOAL:
SQL: What are the new SQL features in OpenEdge 10.1A?
GOAL:
What are the new SQL enhancements introduced in OpenEdge 10.1A?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1A
FIX:
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.
Ability to set Progress 4GL table and column attributes with ALTER TABLE, CREATE TABLE, and CREATE INDEX.
Ability to create active indexes using the CREATE INDEX statement.
Ability to run the following statements against an online database:
-ALTER TABLE ADD COLUMN
-CREATE VIEW
-CREATE PROCEDURE
-CREATE TRIGGER
Ability to control logging for SQL Servers using SET PRO_SERVER LOG and SET PRO_CONNECT LOG.
Removal of the SQL_WIDTH limitation on the SUBSTR and SUBSTRING functions.
Support for the ARRAY data type.
Ability to define VARARRAY data type, which allows its elements' values to exceed the declared size while the total size is limited by SQL_WIDTH.