Salesforce

Can a 64-bit sequence value be assigned to a 32-bit field in 10.1B?

« Go Back

Information

 
TitleCan a 64-bit sequence value be assigned to a 32-bit field in 10.1B?
URL NameP119519
Article Number000140114
EnvironmentProduct: OpenEdge
Version: 10.1B and later
OS: All supported platforms
Question/Problem Description
Can a 64-bit Sequence value be assigned to a 32-bit field in OpenEdge 10.1B and later?
Can a 64-bit Sequence value be assigned to a 32-bit field?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
A 64-bit Sequence can be assigned to a 32-bit (INT) field. As long as the value of the 64-bit sequence is within the 32-bit address range (up to 2 billion) the value of the sequence can be stored in a 32-bit integer field.

Once the value of the 64-bit sequence exceeds the 32-bit limits an error will be generated when attempting to populate the field. Existing sequences with the upper limit specified as the Unknown value (?) were bounded by the maximum of a signed 32-bit integer in prior releases. When 64-bit sequences are enabled, they are bounded by the maximum of a signed 64-bit integer.

Databases created with OpenEdge Release 10.1B and later have 64-bit sequences. Databases migrated from a previous release, can enable support for 64-bit sequences with the PROUTIL ENABLESEQ64 command.  
Workaround
Notes
References to Written Documentation:

OpenEdge® Data Management:Database Administration, "OpenEdge RDBMS Limits"

Progress Articles:

How many sequences can a database hold?   
How does the -noint64 client session startup parameter work?   
What's the quickest way to convert an INTEGER field to INT64 ?   

 
Keyword Phrase
Last Modified Date3/29/2022 4:19 PM

Powered by