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