![HP NonStop SQL/MX Messages Manual Download Page 678](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150678.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -26
SQLSTATE Values
0185Z
4215
Stream access is not allowed on a nonaudited table. Table:
name
.
01860
4216
The
FIRST/ANY n
syntax cannot be used with an embedded
update or embedded DELETE statement.
01861
4217
text
0188C
4300
Invalid usage of procedure
procedure-name
- A UDR was
invoked within a trigger.
0188E
4302
Procedure
procedure-name
expects
value1
parameters
but was called with
value2
parameters.
0188F
4303
The supplied type for parameter
value
of routine
routine-
name
was
type-name1
which is not compatible with the
expected type
type-name2
.
0188G
4304
Host variable or dynamic parameter
parameter-name
is
used in more than one OUT or INOUT parameter for routine
routine-name
. Results might be unpredictable.
0188H
4305
Parameter
value
for used defined routine
routine-name
is
an OUT or INOUT parameter and must be a host variable or a
dynamic parameter.
0188I
4306
A CALL statement is not allowed within a compound
statement.
0188J
4307
Rowset parameters are not allowed in a CALL statement.
0188K
4308
Internal error: unsupported SQL data type
value
specified for
a CALL statement parameter.
01900
5000
Internal error in the query normalizer.
01I00
6000
Internal error in the query optimizer.
01I01
6001
DISTINCT aggregates can be computed only for one column
per table expression.
01I02
6002
The metadata table HISTOGRAMS or
HISTOGRAM_INTERVALS contains invalid values. If you
have manually modified the metadata table, then you should
undo your changes using the CLEAR option in UPDATE
STATISTICS.
01I07
6007
Multi-column statistics for columns
name
from table
name
were
not available; as a result, the access path chosen might not be
the best possible.
01I08
6008
Statistics for column
name
were not available; as a result, the
access path chosen might not be the best possible.
01J00
7000
Internal error in the code generator in file
name
at line
num
:
text
.
01J01
7001
Invalid default value
name
for column
name
.
Table 21-1. SQLSTATE Values (page 25 of 84)
SQLSTATE
SQLCODE
Error Text
Summary of Contents for NonStop SQL/MX
Page 4: ......
Page 8: ...Contents HP NonStop SQL MX Messages Manual 640324 001 iv ...
Page 26: ...General Messages 0 through 999 HP NonStop SQL MX Messages Manual 640324 001 2 2 ...
Page 130: ...SQL MX MXCMP Messages 2000 through 2999 HP NonStop SQL MX Messages Manual 640324 001 4 34 ...
Page 242: ...Normalizer Messages 5000 through 5999 HP NonStop SQL MX Messages Manual 640324 001 7 2 ...
Page 246: ...Optimizer Messages 6000 through 6999 HP NonStop SQL MX Messages Manual 640324 001 8 4 ...
Page 248: ...Generator Messages 7000 through 7999 HP NonStop SQL MX Messages Manual 640324 001 9 2 ...
Page 614: ...Utility Messages 20000 through 23099 HP NonStop SQL MX Messages Manual 640324 001 18 138 ...
Page 752: ...Non SQLCODE Error Messages HP NonStop SQL MX Messages Manual 640324 001 A 14 MXGNAMES Utility ...