SQL/MX 3.2.1 Messages Manual (H06.26+, J06.15+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Release 3.2.1 Messages Manual—691121-002
22-19
SQLSTATE Values
01801 4001 Column name is not found. Tables in scope: name. Default
schema: name.
01802 4002 Column name is not found. Table name not exposed. Tables in
scope: name. Default schema: name.
01803 4003 Column name is not a column in table name, or, after a
NATURAL JOIN or JOIN USING, is no longer allowed to be
specified with a table correlation name.
01804 4004 Column name name is ambiguous. Tables in scope: name.
Default schema: name.
01805 4005 Column reference name must be a grouping column or be
specified within an aggregate.
01806 4006 Within an aggregate, all column references must come from
the same scope.
01807 4007 The select list index num is out of range. It must be between 1
and the number of select expressions, which in this case is
num.
01808 4008 A subquery is not allowed inside an aggregate function.
01809 4009 An aggregate is not allowed inside an aggregate function.
0180A 4010 There are no columns with the correlation name name.
0180B 4011 Ambiguous star column reference name.
0180C 4012 Column reference name must be a grouping column or be
specified within an aggregate. On this grouped table a star
reference is not allowed.
0180D 4013 Column name is a system column and cannot be updated or
inserted into.
0180E 4014 The operands of an INTERSECT must be of equal degree.
0180F 4015 Aggregate functions placed incorrectly: name.
0180G 4016 The number of derived columns (num) must equal the degree
of the derived table (num).
0180H 4017 Derived column name name was specified more than once.
0180I 4018 Rows cannot be deleted from an entry-sequenced table.
0180J 4019 The select list of a subquery in a select list must be scalar
(degree of one).
0180K 4020 Arithmetic operations on row value constructors are not
allowed.
0180L 4021 The select list contains a nongrouping non-aggregated
column, name.
0180M 4022 Target column name was specified more than once.
Table 22-1. SQLSTATE Values (page 18 of 84)
SQLSTATE SQLCODE Error Text