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.
System Action: The SQL query is terminated.
User Response: None.
ANR2930E A subquery used in an SQL expression must specify a single result column.
Explanation: A subquery used in an expression can not specify multiple result
columns. For example, the expression X > (select A,B from T) is invalid because it
specifies two result columns (A and B).
System Action: The SQL query is terminated.
User Response: None.
ANR2931E A subquery expression may not contain a reference to a column name that is
contained in an outer query expression.
Explanation: A subquery contains a reference to a column name in an outer query
expression.
System Action: The SQL query is terminated.
User Response: None.
ANR2932E The maximum nesting depth for subquery expressions has been exceeded.
Explanation: Too many nested subqueries were specified.
System Action: 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.
System Action: The SQL query is terminated.
User Response: None.
420
Version 3 Release 7