K kutti New Member Oct 15, 2007 #1 Hi All, Can some one tell me what is the maximum limit that progress 10.0B version allows to set as the maximum value of a sequence... Thanks, Kutti
Hi All, Can some one tell me what is the maximum limit that progress 10.0B version allows to set as the maximum value of a sequence... Thanks, Kutti
R RKR Member Oct 15, 2007 #2 kutti said: Hi All, Can some one tell me what is the maximum limit that progress 10.0B version allows to set as the maximum value of a sequence... Thanks, Kutti Click to expand... In 10.0B sequences are integers, 32bits signed. so the max value = (2 ^ 31) - 1 = 2147483647. In 10.1B sequences are of datatype INT64 so a little bit more :lol:
kutti said: Hi All, Can some one tell me what is the maximum limit that progress 10.0B version allows to set as the maximum value of a sequence... Thanks, Kutti Click to expand... In 10.0B sequences are integers, 32bits signed. so the max value = (2 ^ 31) - 1 = 2147483647. In 10.1B sequences are of datatype INT64 so a little bit more :lol:
D.Cook Member Jul 22, 2012 #3 For reference, the maximum value of INT64 (signed 64-bit integer) is: (2 ^ 63) - 1 = 9,223,372,036,854,775,807. All databases created with OE 10.1B+, or migrated to OE 10.1B+ and have executed PROUTIL ENABLESEQ64, will have INT64 sequences.
For reference, the maximum value of INT64 (signed 64-bit integer) is: (2 ^ 63) - 1 = 9,223,372,036,854,775,807. All databases created with OE 10.1B+, or migrated to OE 10.1B+ and have executed PROUTIL ENABLESEQ64, will have INT64 sequences.
