Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL Data Definition Language : Using Data Definition Language statements : Working with sequences : Working with existing 32-bit sequences
 
Working with existing 32-bit sequences
In OpenEdge Releases 10.1B and later, you may convert previously created 32-bit sequences to 64-bit sequences using a command line utility. When the utility is executed, all sequences in a database convert from 32-bit to 64-bit. The utility, which can be executed online or offline, does not provide you with the ability to selectively convert sequences. All sequences are converted and once the utility is executed, it cannot be reversed. The conversion utility has the following syntax:
proutil database_name -C enableseq64
Once the conversion has been performed, the sequence is capable of returning values in the 64-bit range. However, the schema properties set during the sequence creation time remain unchanged. Therefore, to change the schema properties, such as minimum and maximum values within the 64-bit BIGINT value range, you must drop the sequence and then create a new sequence with the new 64-bit value range.