ANR2929E The expression ’expression’is not an integer constant.
Explanation: An integer constant such as 1 or -9 is expected. For example, the
DECIMAL function requires that the precision and scale operands be integer
constants.A decimal constant such as 1.67 is not valid.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2930E Asubquery used in an SQL expression must specify a single result column.
Explanation: Asubquery used in an expression can not specify multiple result
columns. For example, the expression X > (selectA,B from T) is invalid because it
specifies two result columns (Aand B).
SystemAction: The SQL query is terminated.
User Response: None.
ANR2931E Asubquery expression may not contain a reference to a column name that is
contained in an outer query expression.
Explanation: Asubquery contains a reference to a column name in an outer query
expression.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2932E The maximum nesting depth for subquery expressions has been exceeded.
Explanation: Toomany nested subqueries were specified.
SystemAction: The SQL query is terminated.
User Response: None.
ANR2933E The WHERE clause must not contain an aggregate function.
Explanation: The use of the aggregate functions COUNT,MAX, MIN, SUM,
AVG,VARIANCE, or STDDEV in the WHERE clause is not allowed.
SystemAction: The SQL query is terminated.
User Response: None.
420
Version 3 Release 7