SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
22-24
SQLSTATE Values
01846 4150 Primary key of table expression name must be used for join
with embedded name expression. Tables in scope: name.
01847 4151 Stream access only supported on updateable views name.
01848 4152 Table name cannot be both read and updated.
01849 4153 Statement might not compile due to an order requirement on
stream expression.
0184A 4154 Statement might not compile due to an order requirement on
embedded name expression.
0184D 4157 Inner relation of left join cannot be stream expression. Tables
in scope: name.
0184E 4158 Join of stream expressions not supported. Tables in scope:
name.
0184F 4159 Intersection of stream expressions not supported. Tables in
scope: name.
0184G 4160 Intersection between embedded name expression and
embedded name expression not supported. Tables in scope:
name, name.
0184H 4161 Union between embedded name expression and embedded
name expression not supported. Tables in scope: name, name.
0184I 4162 Groupby not supported for stream expression. Tables in
scope: name.
0184J 4163 Groupby not supported for embedded name expression.
Tables in scope: name.
0184K 4164 Outer relation of right join cannot be embedded name
expression. Tables in scope: name.
0184L 4165 Outer relation of right join cannot be stream expression.
Tables in scope: name.
0184M 4166 ORDER BY clause not supported in UNION of two streams.
Tables in scope: name, name.
0184N 4167 Embedded name statements not supported in subqueries.
0184O 4168 Stream expressions not supported in subqueries.
0184P 4169 Embedded DELETE statements not allowed when using
DECLARE ... FOR UPDATE clause.
0184Q 4170 Stream expressions not supported for insert statements.
0184R 4171 Embedded name statements not supported in INSERT
statements.
0184T 4173 Stream expression not supported for top level UPDATE
statements.
Table 22-1. SQLSTATE Values (page 23 of 84)
SQLSTATE SQLCODE Error Text










