Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Statements : ALTER DATABASE SET PRO_ENABLE_LARGE_KEYS 'Y'
 

ALTER DATABASE SET PRO_ENABLE_LARGE_KEYS 'Y'

This statement is used to enable large index database keys of up to 2,000 bytes.

Syntax

ALTER DATABASE SET PRO_ENABLE_LARGE_KEYS 'Y'

Notes

*You must have SQL DBA privileges to enable large keys.
*As of OpenEdge Release 10.1B, large index keys are supported for databases with 4,000 and 8,000 byte block sizes and are enabled by default.
*In Releases 10.1B and later, large index key sizes are enabled by default. However, in Releases 10.1A and earlier, this statement must be used to enable large keys.
*If large keys are already enabled, an error message indicating such will be returned when you use the statement.