What are Sequence object maximum values within RC/Update.

Products

• RC/Update for DB2 for z/OS

Issue/Introduction

There are 3 possible data types for SEQUENCE objects; decimal, integer, smallint and bigint, what are the MAXVALUES for those data types
within RC/Update for Db2 for z/OS (RCU)?

Resolution

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.