Kbase P188872: What version of OpenEdge SQL92 allows online schema changes?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/06/2011 |
|
Status: Unverified
GOAL:
What version of OpenEdge SQL92 allows online schema changes?
GOAL:
What is the earliest version where online schema changes can be made with OpenEdge SQL?
GOAL:
What is the earliest version where online schema changes can be made with OE SQL?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.0A
OpenEdge 10.1x
OpenEdge 10.2x
FIX:
Beginning in OpenEdge 10.0A some DDL (example: alter table rename table) functions were modified to allow online schema changes.
In 10.1A changes were made to the locking algorithm to allow more DDL (Data Definition Language) changes (i.e. schema changes) to be made online.
These statements: ALTER TABLE ADD COLUMN, GRANT, and most of the CREATE statements, with the exception of CREATE SYNONYM should all be online capable in 10.1A on.
Not all functions of the DDL are possible while the database is online.