![HP NonStop SQL/MX Messages Manual Download Page 674](http://html.mh-extra.com/html/hp/nonstop-sql-mx/nonstop-sql-mx_messages-manual_165150674.webp)
SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual — 640324-001
21 -22
SQLSTATE Values
01825
4077
Function
name
accepts only one or two operands.
01826
4078
Function
name
does not accept a weight operand.
01827
4079
The operands of function
name
must be numeric.
01828
4080
SQL/MP error:
num
num
.
01829
4081
SQL/MP error:
error
0182A
4082
Table
name
does not exist or is inaccessible.
0182B
4083
SQL/MP DDL operation failed.
0182C
4084
SQL object
name
is corrupt.
0182D
4085
File organization
type
of object
name
is not supported.
0182E
4086
Environment variable or define
name
does not exist.
0182F
4087
Prototype value '
name
' is not a valid qualified name.
0182G
4088
The number of values in each TRANSPOSE item of a
TRANSPOSE set must be equal.
0182H
4089
Check constraint
name
contains a subquery, which is not yet
supported.
0182L
4093
The number of output dynamic parameters (
num
) must equal
the number of selected values (
num
).
0182M
4094
The number of output host variables (
num
) must equal the
number of selected values (
num
).
0182N
4095
A DEFAULT whose value is NULL is not allowed in
name
.
0182O
4096
A DEFAULT specification is currently allowed only when
simply contained in the VALUES list of an INSERT.
0182P
4097
A NULL operand is not allowed in function
name
.
0182Q
4098
A NULL operand is not allowed in operation
name
.
0182R
4099
A NULL operand is not allowed in predicate
name
.
0182S
4100
A NULL value is not allowed in a select list unless it is CAST
to some data type.
0182T
4101
If
name
is intended to be a further table reference in the FROM
clause, the preceding join search condition must be enclosed
in parentheses.
0182U
4102
The
FIRST/ANY n
syntax cannot be used with in an
outermost SELECT statement.
0182W
4104
If a character literal was intended, you must use the single
quote delimiter instead of the double:
name
instead of
name
.
0182X
4105
Unknown translation.
0182Y
4106
The character set for the operand of function
name
must be
name
.
Table 21-1. SQLSTATE Values (page 21 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 ...