Neoview Messages Manual (Volume 2) (R2.5)

Table 3-3 SQLSTATE Values Beginning 01800 (continued)
Error TextSQLCODESQLSTATE
Embedded UPDATE/DELETE statements are not supported within an IF statement.42100185U
table name cannot be used to satisfy order requirement on the stream because it is
partitioned.
42120185W
Use of rowsets in a predicate with embedded UPDATE/DELETE not supported.42130185X
The SET ON ROLLBACK clause is not allowed on a non-audited table. Table: name.
42140185Y
Stream access is not allowed on a nonaudited table. Table: name.
42150185Z
The FIRST/ANY n syntax cannot be used with an embedded update or embedded
DELETE statement.
421601860
text
421701861
Invalid usage of procedure procedure-name - A UDR was invoked within a trigger.
43000188C
Procedure procedure-name expects value1 parameters but was called with value2
parameters.
43020188E
The supplied type for parameter value of routine routine-name was type-name1
which is not compatible with the expected type type-name2.
43030188F
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.
43040188G
Parameter value for used defined routine routine-name is an OUT or INOUT
parameter and must be a host variable or a dynamic parameter.
43050188H
A CALL statement is not allowed within a compound statement.43060188I
Rowset parameters are not allowed in a CALL statement.43070188J
Internal error: unsupported SQL data type value specified for a CALL statement
parameter.
43080188K
Internal error in the query normalizer.500001900
Table 3-4 SQLSTATE Values Beginning 01I01
Error TextSQLCODESQLSTATE
Internal error in the query optimizer.600001I00
DISTINCT aggregates can be computed only for one column per table expression.600101I01
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.
600201I02
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.
600701I07
Internal error in the code generator in file name at line num: text.
700001J00
Invalid default value name for column name.
700101J01
A plan using cluster sampling could not be produced for this query.700301J03
Internal executor error.800101K01
The current nowaited operation is not complete.800201K02
The descriptor is locked by another nowaited operation.800301K03
Trying to open a statement or cursor that is not in the closed state.800401K04
Trying to fetch from a cursor that is not in the open state.800501K05
118 SQLSTATE Values Returned by the Neoview Database