Message Reference

Class Code 01 Warning

Table 3. Class Code 01: Warning

SQLSTATE Value
Meaning
01002 A DISCONNECT error occurred.
01003 Null values were eliminated from the argument of a column function.
01004 The value of a string was truncated when assigned to a host variable.
01005 Insufficient number of entries in an SQLDA.
01007 A privilege was not granted.
0100E The procedure generated more than the maximum allowed number of result sets. Only the first integer result sets have been returned to the caller.
01503 The number of result columns is larger than the number of host variables provided.
01504 The UPDATE or DELETE statement does not include a WHERE clause.
01506 An adjustment was made to a DATE or TIMESTAMP value to correct an invalid date resulting from an arithmetic operation.
01509 Blocking was cancelled for a cursor because there is insufficient storage in the user virtual machine.
01515 The null value has been assigned to a host variable, because the non-null value of the column is not within the range of the host variable.
01516 An inapplicable WITH GRANT OPTION has been ignored.
01517 A character that could not be converted was replaced with a substitute character.
01519 The null value has been assigned to a host variable, because a numeric value is out of range.
01524 The result of a column function does not include the null values that were caused by evaluating an arithmetic expression.
01526 Isolation level has been escalated.
01539 Connection is successful but only SBCS characters should be used.
01543 A duplicate constraint has been ignored.
01545 An unqualified column name has been interpreted as a correlated reference.
01550 The index was not created, because an index with the specified description already exists.
01560 A redundant GRANT has been ignored.
01562 The new path to the log (newlogpath) in the database configuration file is invalid.
01563 The current path to the log file (logpath) is invalid. The log file path is reset to the default.
01564 The null value has been assigned to a host variable, because division by zero occurred.
01586 Setting OFF the constraints for a parent table in a referential structure has resulted in one or more descendent tables being automatically placed into a check-pending state
01589 A statement contains redundant specifications.
01592 In a CREATE FUNCTION statement that references a SOURCE function, either:

an input parameter has a larger length, precision, or scale than that of the corresponding parameter of the source function; or
the RETURNS or CAST FROM parameter has a smaller length, precision, or scale than that of the source function; or
the CAST FROM parameter in the CREATE FUNCTION statement has a larger length, precision, or scale than that of the RETURNS parameter.
time).
01594 Insufficient number of entries in an SQLDA for ALL information (i.e. not enough descriptors to return the distinct name).
01595 The view has replaced an existing, invalidated view.
01596 Comparison functions were not created for a distinct type based on a long string data type.
01598 An attempt has been made to activate an active event monitor or deactivate an inactive event monitor.
01599 Bind options were ignored on REBIND.
01602 The optimization level has been reduced.
01603 CHECK DATA processing found constraint violations and moved them to exception tables.
01604 The SQL statement was explained and not executed.
01605 A recursive common table expression may contain an infinite loop.
01606 The node or system database directory is empty.
01607 The difference between the times on nodes in a read-only transactions exceed the defined threshold.
01609 The procedure generated more than the maximum allowed number of result sets. Only the first integer result sets have been returned to the caller.
01610 One or more ad hoc result sets were returned from the procedure.
01611 The cursor that was closed has been re-opened on the next result set within the chain.
01616 The estimated CPU cost exceeds the resource limit.
01618 Redistribute nodegroup is required to change data partitioning.
01620 Some base tables of UNION ALL may be the same table.
01621 The retrieved LOB value may have been changed.
01622 Statement completed successfully but a system error occurred after the statement completed.
01623 Value of DEGREE is ignored.
01626 The database has only one active bufferpool.
01627 The DATALINK value may not be valid because the table is in reconcile pending or reconcile is not possible state.
01632 The number of concurrent connections has exceeded the defined entitlement for the product.
01633 The summary table may not be used to optimize the processing of queries.
01636 Integrity of non-incremental data remains unverified by the database manager.
01637 Debugging is not enabled.
01HXX Valid warning SQLSTATEs returned by a user-defined function or external procedure CALL.

SQLSTATE Value	Meaning
01002	A DISCONNECT error occurred.
01003	Null values were eliminated from the argument of a column function.
01004	The value of a string was truncated when assigned to a host variable.
01005	Insufficient number of entries in an SQLDA.
01007	A privilege was not granted.
0100E	The procedure generated more than the maximum allowed number of result sets. Only the first integer result sets have been returned to the caller.
01503	The number of result columns is larger than the number of host variables provided.
01504	The UPDATE or DELETE statement does not include a WHERE clause.
01506	An adjustment was made to a DATE or TIMESTAMP value to correct an invalid date resulting from an arithmetic operation.
01509	Blocking was cancelled for a cursor because there is insufficient storage in the user virtual machine.
01515	The null value has been assigned to a host variable, because the non-null value of the column is not within the range of the host variable.
01516	An inapplicable WITH GRANT OPTION has been ignored.
01517	A character that could not be converted was replaced with a substitute character.
01519	The null value has been assigned to a host variable, because a numeric value is out of range.
01524	The result of a column function does not include the null values that were caused by evaluating an arithmetic expression.
01526	Isolation level has been escalated.
01539	Connection is successful but only SBCS characters should be used.
01543	A duplicate constraint has been ignored.
01545	An unqualified column name has been interpreted as a correlated reference.
01550	The index was not created, because an index with the specified description already exists.
01560	A redundant GRANT has been ignored.
01562	The new path to the log (newlogpath) in the database configuration file is invalid.
01563	The current path to the log file (logpath) is invalid. The log file path is reset to the default.
01564	The null value has been assigned to a host variable, because division by zero occurred.
01586	Setting OFF the constraints for a parent table in a referential structure has resulted in one or more descendent tables being automatically placed into a check-pending state
01589	A statement contains redundant specifications.
01592	In a CREATE FUNCTION statement that references a SOURCE function, either: an input parameter has a larger length, precision, or scale than that of the corresponding parameter of the source function; or the RETURNS or CAST FROM parameter has a smaller length, precision, or scale than that of the source function; or the CAST FROM parameter in the CREATE FUNCTION statement has a larger length, precision, or scale than that of the RETURNS parameter. time).
01594	Insufficient number of entries in an SQLDA for ALL information (i.e. not enough descriptors to return the distinct name).
01595	The view has replaced an existing, invalidated view.
01596	Comparison functions were not created for a distinct type based on a long string data type.
01598	An attempt has been made to activate an active event monitor or deactivate an inactive event monitor.
01599	Bind options were ignored on REBIND.
01602	The optimization level has been reduced.
01603	CHECK DATA processing found constraint violations and moved them to exception tables.
01604	The SQL statement was explained and not executed.
01605	A recursive common table expression may contain an infinite loop.
01606	The node or system database directory is empty.
01607	The difference between the times on nodes in a read-only transactions exceed the defined threshold.
01609	The procedure generated more than the maximum allowed number of result sets. Only the first integer result sets have been returned to the caller.
01610	One or more ad hoc result sets were returned from the procedure.
01611	The cursor that was closed has been re-opened on the next result set within the chain.
01616	The estimated CPU cost exceeds the resource limit.
01618	Redistribute nodegroup is required to change data partitioning.
01620	Some base tables of UNION ALL may be the same table.
01621	The retrieved LOB value may have been changed.
01622	Statement completed successfully but a system error occurred after the statement completed.
01623	Value of DEGREE is ignored.
01626	The database has only one active bufferpool.
01627	The DATALINK value may not be valid because the table is in reconcile pending or reconcile is not possible state.
01632	The number of concurrent connections has exceeded the defined entitlement for the product.
01633	The summary table may not be used to optimize the processing of queries.
01636	Integrity of non-incremental data remains unverified by the database manager.
01637	Debugging is not enabled.
01HXX	Valid warning SQLSTATEs returned by a user-defined function or external procedure CALL.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]