HP NonStop SQL/MX - Page 709

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—640324-001
21-57
SQLSTATE Values
42000 -3181 Invalid logical name, a three part logical name is required.
42000 -3187 Not supported: SET STREAM TIMEOUT per a specific
stream.
42000 -3189 cannot set lock timeout on a view.
42000 -4001 Column name is not found. Tables in scope: name. Default
schema: name.
42000 -4002 Column name is not found. Table name not exposed. Tables in
scope: name. Default schema: name.
42000 -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.
42000 -4004 Column name name is ambiguous. Tables in scope: name.
Default schema: name.
42000 -4005 Column reference name must be a grouping column or be
specified within an aggregate.
42000 -4006 Within an aggregate, all column references must come from
the same scope.
42000 -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.
42000 -4008 A subquery is not allowed inside an aggregate function.
42000 -4009 An aggregate is not allowed inside an aggregate function.
42000 -4010 There are no columns with the correlation name name.
42000 -4011 Ambiguous star column reference name.
42000 -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.
42000 -4013 Column name is a system column and cannot be updated or
inserted into.
42000 -4014 The operands of an INTERSECT must be of equal degree.
42000 -4010 There are no columns with the correlation name name.
42000 -4011 Ambiguous star column reference name.
42000 -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.
42000 -4013 Column name is a system column and cannot be updated or
inserted into.
42000 -4014 The operands of an INTERSECT must be of equal degree.
42000 -4015 Aggregate functions placed incorrectly: name.
Table 21-1. SQLSTATE Values (page 56 of 84)
SQLSTATE SQLCODE Error Text