What are Sequence object maximum values?

Document ID : KB000023900
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

There are 3 possible data types for SEQUENCE objects; decimal, integer, smallint and bigint, what are the MAXVALUES for those data types?

Answer:

When creating a SEQUENCE object in RC/Update, the valid MAXVALUES are as follows:

MAXVALUE Specifies the maximum value that is generated for the sequence. The  value can be any positive or negative value (including zero) that 
is greater than or equal to MINVALUE and that can be assigned to its data type, as follows:

DECIMAL - any positive or negative value within the scope of the number's defined precision, or NO. For example, if the precision is 6,
the smallest value is -999999 and the largest value 999999. (If a decimal point is included, it and any digits to its right are
discarded and the value is redisplayed without the decimal point or trailing digits.)

SMALLINT - smallest value: -32768
largest value : 32767
or, NO.

INTEGER - smallest value: -2147483648
largest value : 2147483647
or, NO.

BIGINT - smallest value: -9223372036854775808
largest value : 9223372036854775807
or, NO.