SQL/MX 3.2.1 Messages Manual (H06.26+, J06.15+)

Data Definition Language (DDL) Messages (1000
through 1999)
HP NonStop SQL/MX Release 3.2.1 Messages Manual—691121-002
3-80
Cause. You specified a precision value greater than the maximum supported by the
sequence generator.
Effect. The statement fails to execute.
Recovery. Resubmit the statement with the precision value lesser than or equal to the
maximum supported precision value.
SQL 1622
Where seq-name is the ANSI name of the sequence generator.
Cause. The combination of INCREMENT BY, MINVALUE, and MAXVALUE settings
results in the sequence generator generating only a single value per cycle.
Effect. The statement fails to execute.
Recovery. Specify INCREMENT BY, MINVALUE, and MAXVALUE settings so that the
sequence generator can generate at least two values per cycle.
SQL 1623
Cause. The user specified value for resetting the CURRENT_VALUE is lesser than
the MINVALUE of the sequence generator.
Effect. The statement fails to execute.
Recovery. Increase the RESTART WITH value to a number greater than or equal to
MINVALUE.
SQL 1624
Cause. The user specified value for resetting the CURRENT_VALUE is greater than
the MAXVALUE of the sequence generator.
Effect. The statement fails to execute.
Recovery. Decrease the RESTART WITH value to a number lesser than or equal to
MAXVALUE.
1622 INCREMENT BY value is inconsistent with MAXVALUE and
MINVALUE settings for seq-name.
1623 The RESTART WITH value should be equal to or greater
than the MINVALUE of the sequence generator.
1624 The RESTART WITH value should be equal to or less than
the MAXVALUE of the sequence generator.