Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL Data Definition Language : Using Data Definition Language statements : Working with sequences : Enabling 64-bit sequences
 
Enabling 64-bit sequences
You can enable 64-bit sequences in a database by using the following online statement:
ALTER DATABASE SET PRO_ENABLE_64BIT_SEQUENCES 'Y'
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. You must have SQL DBA privileges to use this command.