**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.