Consultor Eletrônico



Kbase P7170: Which are the Maximum and Minimum values for a sequence ?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   7/22/2009
Status: Verified

GOAL:

Which is the maximum value for a sequence ?

GOAL:

What is the maximal value for a sequence?

FACT(s) (Environment):

All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x

FIX:

In versions of the Progress RDBMS prior to OpenEdge 10.1.B, an incrementing sequence had a maximum of 2^31 or 2,147,483,648 and a decrementing sequence had a minumum value of -2,147,483,647.
Extending to 64-bits, starting on OpenEdge 10.1.B the maximum value of an incrementing sequence to be 2^63 or 9,223,372,036,854,775,808 and the min value of a decrementing sequence to be 9,223,372,036,854,775,807.