SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—523730-004
20-19
SQLSTATE Values
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.
0180N 4023 The degree of each row value constructor (num) must equal
the degree of the target table column list (num).
0180O 4024 Column name has no default value, so must be explicitly
specified in the insert column list.
0180P 4025 Error while preparing constraint name on table name.
0180Q 4026 Reading from and inserting into, or updating in, or deleting
from the same table, name, is not currently supported.
0180R 4027 Table name is not insertable.
0180S 4028 Table name is not updateable.
0180U 4030 Column name is an invalid combination of datetime fields
(num, num, num).
Table 20-1. SQLSTATE Values (page 18 of 85)
SQLSTATE SQLCODE Error Text