-845   A PREVIOUS VALUE EXPRESSION CANNOT BE USED BEFORE THE NEXT VALUE EXPRESSION GENERATES A VALUE IN THE CURRENT APPLICATION PROCESS FOR SEQUENCE sequence-name

Explanation

A PREVIOUS VALUE expression specified sequence sequence-name, but a value has not yet been generated for this sequence. A NEXT VALUE expression must be issued in this application process to generate a value for this sequence before a PREVIOUS VALUE expression for the sequence can be issued.

This error can also occur after a sequence has been dropped, and the DROP statement is rolled back.

System action

The statement cannot be processed.

Programmer response

Issue at least one NEXT VALUE expression for a sequence before issuing any PREVIOUS VALUE expression for the same sequence in a connection.

SQLSTATE

51035