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.
  • OpenEdge databases support sequences with 64-bit maximums for positive and negative numbers.
  • 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.