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

ALTER DATABASE SET PRO_ENABLE_64BIT_SEQUENCES 'Y'

This statement is used to enable large index keys in a database.

Syntax

ALTER DATABASE SET PRO_ENABLE_64BIT_SEQUENCES 'Y'

Notes

*You must have SQL DBA privileges to enable 64-bit sequences.
*As of OpenEdge Release 10.1B, OpenEdge databases support sequences with 64-bit maximums for positive and negative numbers.
*In releases 10.1B and later, this feature is enabled by default. However, in Releases 10.1A and earlier, this specific ALTER DATABASE statement must be used to enable 64-bit sequences.
*If 64-bit sequences are already enabled, an error message indicating such will be returned when you use the statement.