-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.

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.

System action

The statement cannot be processed.

Programmer response

Remove the reference to the sequence expression and resubmit the statement.

SQLSTATE

428F9