Kbase P119519: Can a 64-bit sequence value be assigned to a 32-bit field in 10.1B?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/06/2009 |
|
Status: Verified
GOAL:
Can a 64-bit sequence value be assigned to a 32-bit field in 10.1B?
GOAL:
Can a 64-bit sequence value be assigned to a 32-bit field?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
FIX:
Yes, 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.
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. See the ?PROUTIL ENABLESEQ64 qualifier? section on page 20?35 for details.
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.