logo  
Google
 

DB2 SQL-Error: -348

SQLState: 428F9

Short Description: CANNOT BE SPECIFIED IN THIS CONTEXT

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: v Join condition of a full outer join v DEFAULT value for a column in a CREATE TABLE or ALTER TABLE statement v Column definition that is generated in a CREATE TABLE or ALTER TABLE statement v Materialized query table definition in a CREATE TABLE or ALTER TABLE statement v Condition of a CHECK constraint v Input value-specification for LOAD v CREATE VIEW statementNEXT VALUE expressions cannot be specified in the following contexts: v CASE expression v Parameter list of an aggregate function v Subquery in a context in which it is not otherwise allowed v SELECT statement for which the outer SELECT contains a DISTINCT operator or a GROUP BY clause v SELECT statement for which the outer SELECT is combined with another SELECT statement using the UNION set operator v Join condition of a join v Nested table expression v Parameter list of a table function v SELECT clause of the fullselect of an expression in the SET clause of an UPDATE statement v ORDER BY clause of the outer-most SELECT statement v IF, WHILE, DO ... UNTIL, or CASE statement in an SQL routineSystem action: The statement cannot be executed. Programmer response: Remove the reference to the sequence expression and resubmit the statement.

 <-  BACK TO INDEX