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-21
SQLSTATE Values
0181L 4057 Correlation name name conflicts with qualified identifier of
table name.
0181N 4059 The first operand of function name must be numeric.
0181O 4060 Reading from and inserting into, or updating in, or deleting
from the same table, name, is not currently supported. name is
contained by view(s) name.
0181P 4061 Rows cannot be inserted into, or updated in, an individual
table partition.
0181Q 4062 The preceding error actually occurred in function name.
0181R 4063 The operands of function name must be comparable character
data types (that is, of the same character set and collation).
0181S 4064 The operands of function name must be compatible character
data types (that is, of the same character set).
0181U 4066 The operands of a UNION must be of equal degree.
0181V 4067 The operands of function name must be character data types.
0181W 4068 The operand of function name must contain an even number
of characters.
0181X 4069 Column name uses an unsupported collation, name.
0181Y 4070 The operand of function name must be exact numeric.
0181Z 4071 The first operand of function name must be a datetime.
01820 4072 The operand of function name must be a datetime containing a
name.
01821 4073 The COLLATE clause might appear only after an expression of
character data type, not name.
01822 4074 CONTROL QUERY successful.
01823 4075 Division by zero in constant expression name.
01824 4076 Overflow in constant expression name.
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.
Table 20-1. SQLSTATE Values (page 20 of 85)
SQLSTATE SQLCODE Error Text