Filter
Top Products
column reference is prohibited because either 1) the GROUP BY clause has been
specified, 2) the HAVING clause has been specified, or 3) at least one aggregate
function is present.
System Action: The SQL query is terminated.
User Response: None.
ANR2939E The reference ’reference’ is an unknown SQL table name.
Explanation: The specified table reference is not one of the base tables defined by
the server’s database. The rows of the table SYSCAT.TABLES can be selected to
obtain a list of all of the valid base tables.
System Action: The SQL query is terminated.
User Response: None.
ANR2940E The reference ’reference’ is an unknown SQL column name.
Explanation: The specified column reference is not one of the base table columns
defined by the server’s database. The rows of the table SYSCAT.COLUMNS can be
selected to obtain a list of all of the valid base table columns. If a two-part
(compound) column reference such as X.Y is specified, then the correlation name X
must be one of the active correlation names for the query.
System Action: The SQL query is terminated.
User Response: None.
ANR2941E The column reference ’column reference’ matches more than one SQL column
name.
Explanation: The specified column reference is ambiguous because it matches the
columns associated with multiple tables.
System Action: The SQL query is terminated.
User Response: None.
ANR2942E The column reference ’column reference’ is not allowed in this context because it
is part of an outer SQL query expression.
Explanation: The specified column reference is not allowed because it names a
columns of some outer query expression. Such references are not allowed when
contained within the expressions of the HAVING and SELECT clauses.
System Action: The SQL query is terminated.
User Response: None.
422
Version 3 Release 7