Try OpenEdge Now
skip to main content
New Information
OpenEdge SQL
 

OpenEdge SQL

The OpenEdge Release 11.7.2 Service Pack includes the following updates for OpenEdge SQL:
*ALTER TABLE table_name ALTER COLUMN column_name set PRO_SQL_WIDTH new_column_width—You can execute this command against an online database.
*Grant and Revoke—You can perform regular operations concurrently as these statements take more granular locks. For example, if you submit Grant or Revoke in a session, then users connected to other sessions can perform any other operations (Read/Write). This change removes all impact on ABL operations caused by Grant and Revoke SQL statements.