-348 sequence-expression CANNOT BE SPECIFIED IN THIS CONTEXT
Explanation
The statement contains a NEXT VALUE expression or PREVIOUS VALUE expression in an invalid context.
The NEXT VALUE expression or PREVIOUS VALUE expression cannot be specified in the following contexts:
- Join condition of a full outer join
- DEFAULT value for a column in a CREATE TABLE or ALTER TABLE statement
- Column definition that is generated in a CREATE TABLE or ALTER TABLE statement
- Materialized query table definition in a CREATE TABLE or ALTER TABLE statement
- An as-result-table clause of a CREATE TABLE or DECLARED GLOBAL TEMPORARY TABLE statement.
- Condition of a CHECK constraint
- Input value-specification for LOAD
- CREATE VIEW statement
- Key-expression of an index definition.
- The SELECT list of a subselect that contains a NOT ATOMIC data change statement.
- An expression that generates the value of an index for an array.
The NEXT VALUE expressions cannot be specified in the following contexts:
- CASE expression
- Parameter list of an aggregate function
- Subquery in a context in which it is not otherwise allowed
- SELECT statement for which the outer SELECT contains a DISTINCT operator or a GROUP BY clause
- SELECT statement for which the outer SELECT is combined with another SELECT statement using a set operator such as UNION, EXCEPT, or INTERSECT
- Join condition of a join
- Nested table expression
- Parameter list of a table function
- SELECT clause of the fullselect of an expression in the SET clause of an UPDATE statement
- ORDER BY clause in the SELECT statement
- ORDER BY clause in an OLAP specification
- IF, WHILE, DO ... UNTIL, or CASE statement in an SQL routine
- Key-expression of an index definition.
- The select list of a subselect that contains a NOT ATOMIC data change statement.
- The select list of a fullselect that contains an OFFSET clause.
System action
The statement cannot be processed.
Programmer response
Remove the reference to the sequence expression and resubmit the statement.
SQLSTATE
428F9