Neoview Messages Manual (Volume 1) (R2.5)

If a column is part of a JOIN operation, you no longer qualify its name with its original table
name2.
Effect The operation fails.
Recovery Correct the syntax and resubmit. If the column is part of a JOIN, remove the table
qualifier and use only the column name.
SQL 4004
4004 Column name name1 is ambiguous. Tables in scope: names. Default
schema: name2.
Cause You referenced column name1, whose parent table is ambiguous. The table names
or tables in the scope of the column reference and default schema name2 appear.
Effect The operation fails.
Recovery Correct the syntax so that the table's parent table is clear, and resubmit.
SQL 4005
4005 Column reference name must be a grouping column or be specified
within an aggregate.
Cause You referenced column name, which is not a grouping column or is not specified
within an aggregate, which is not supported.
Effect The operation fails.
Recovery Correct the column reference and resubmit.
SQL 4006
4006 Within an aggregate, all column references must come from the same
scope.
Cause You referred to columns that do not come from the same scope.
Effect The operation fails.
Recovery Correct the column references and resubmit.
SQL 4007
4007 The select list index value1 is out of range. It must be between
1 and the number of select expressions, which in this case is value2.
Cause You specified an index value1 that is out of the range of between 1 and the value2
of SELECT expressions.
Effect The operation fails.
Recovery Correct the index and resubmit.
SQL 4008
4008 A subquery is not allowed inside an aggregate function.
Cause You specified a subquery within an aggregate function, which is not supported.
Effect The operation fails.
Recovery Correct the syntax and resubmit.
SQL 4009
4009 An aggregate is not allowed inside an aggregate function.
Cause You specified an aggregate inside an aggregate function.
Effect The operation fails.
132 Binder and Compilation Messages (4000 Through 4999)