-20142 SEQUENCE sequence-name CANNOT BE USED AS SPECIFIED
Explanation
The sequence was referenced in a context in which it cannot be used.
- sequence-name
- The name of the sequence.
The sequence was an invalid reference to a system-generated sequence object. The sequence was generated by the system for one of the following column types: catalog, identity, or DB2_GENERATED_DOCID_FOR_XML. These sequences cannot be referenced in:
- An ALTER SEQUENCE statement
- A DROP SEQUENCE statement
- A COMMENT statement to specify a comment for a sequence
- A GRANT or REVOKE statement that references the sequence
- A NEXT VALUE or PREVIOUS VALUE expression.
System action
The statement cannot be processed.
Programmer response
Specify the name of a user-defined sequence object in this context.
SQLSTATE
428FB