Usando valores do SQLSTATE

Os valores do SQLSTATE são devolvidos à aplicação nos últimos cinco bytes do SQLCA. Cada valor de cinco caráter é um código de retorno que indica o resultado da declaração de SQL mais recentemente executada

Tabela 7. Class Code 01: Warning
SQLSTATE	Significado
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.
0100C	One or more ad hoc result sets were returned from the procedure.
0100E	The procedure returned too many result sets.
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.
01505	The statement was not executed because it is unacceptable in this environment.
01506	An adjustment was made to a DATE or TIMESTAMP value to correct an invalid date resulting from an arithmetic operation.
01507	One or more non-zero digits were eliminated from the fractional part of a number used as the operand of a multiply or divide operation.
01514	The tablespace has been placed in the check-pending state.
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.
01518	The definition of the table has been changed to incomplete.
01519	The null value has been assigned to a host variable, because a numeric value is out of range.
01520	The null value has been assigned to a host variable, because the characters cannot be converted.
01521	A specified server-name is undefined but is not needed until the statement is executed or the alias is used.
01522	The local table or view name used in the CREATE ALIAS statement is undefined.
01523	ALL was interpreted to exclude ALTER, INDEX, REFERENCES, and TRIGGER, because these privileges cannot be granted to a remote user.
01524	The result of a column function does not include the null values that were caused by evaluating the arithmetic expression implied by the column of the view.
01525	The number of INSERT values is not the same as the number of columns.
01527	A SET statement references a special register that does not exist at the AS.
01528	WHERE NOT NULL is ignored, because the index key cannot contain null values.
01529	As a result of the DROP INDEX, the UNIQUE constraint is no longer enforced.
01530	Definition change may require a corresponding change on the read-only systems.
01532	An undefined object name was detected.
01533	An undefined column name was detected.
01537	An SQL statement cannot be EXPLAINed, because it references a remote object.
01538	The table cannot be subsequently defined as a dependent, because it has the maximum number of columns.
01539	Connection is successful but only SBCS characters should be used.
01540	A limit key has been truncated to 40 bytes.
01542	Authorization ID does not have the privilege to perform the operation as specified.
01543	A duplicate constraint has been ignored.
01545	An unqualified column name has been interpreted as a correlated reference.
01546	A column of the explanation table is improperly defined.
01548	The authorization ID does not have the privilege to perform the specified operation on the identified object.
01551	A table in a partitioned tablespace is not available, because its partitioned index has not been created.
01552	An ambiguous qualified column name was resolved to the first of the duplicate names in the FROM clause.
01553	Isolation level RR conflicts with a tablespace locksize of page.
01554	Decimal multiplication may cause overflow.
01558	A distribution protocol has been violated.
01560	A redundant GRANT has been ignored.
01561	An update to a data capture table was not signaled to the originating subsystem.
01566	The index has been placed in a recover-pending state.
01568	The dynamic SQL statement ends with a semicolon.
01569	The statement will be executed at a DB2 system that does not support character conversion.
01590	Type 2 indexes do not have subpages.
01591	The result of the positioned UPDATE or DELETE may depend on the order of the rows.
01594	Insufficient number of entries in an SQLDA for ALL information (i.e. not enough descriptors to return the distinct name).
01596	Comparison functions were not created for a distinct type based on a long string data type.
01597	Specific and non-specific volume IDs are not allowed in a storage group.
01602	The optimization level has been reduced.
01608	An unsupported value has been replaced.
01612	The part clause of a LOCK TABLE statement is not valid.
01614	There are fewer locators than the number of result sets.
01616	The estimated CPU cost exceeds the resource limit.
01624	The GBPCACHE specification is ignored because the bufferpool does not allow caching.
01625	The schema name appears more than once in the CURRENT PATH.
01628	The user-specified access path hints are invalid. The access path hints are ignored.
01629	User-specified access path hints were used during access path selection.
01635	Statements in the same program have duplicate QUERYNOs.
01638	SUBPAGES greater than one are not supported for Type 1 indexes in a data sharing environment.
01Hxx	Valid warning SQLSTATEs returned by a user-defined function or external procedure CALL.

Tabela 25. Class Code 42: Syntax Error or Access Rule Violation
SQLSTATE	Significado
42501	The authorization ID does not have the privilege to perform the specified operation on the identified object.
42502	The authorization ID does not have the privilege to perform the operation as specified.
42503	The authorization ID specified in SET CURRENT SQLID is not one of the authorization IDs of the application process.
42504	A specified privilege cannot be revoked from a specified authorization-name.
42505	Connection authorization failure occurred.
42506	Owner authorization failure occurred.
42509	SQL statement is not authorized, because of the DYNAMICRULES option.
42510	The authorization ID does not have the privilege to create functions or procedures in the WLM environment.
42601	A character, token, or clause is invalid or missing.
42602	A character that is invalid in a name has been detected.
42603	An unterminated string constant has been detected.
42604	An invalid numeric or string constant has been detected.
42605	The number of arguments specified for a scalar function is invalid.
42606	An invalid hexadecimal constant has been detected.
42607	An operand of a column function is invalid.
42609	All operands of an operator or predicate are parameter markers.
42610	A parameter marker is not allowed.
42611	The column or argument definition is invalid.
42612	The statement string is an SQL statement that is not acceptable in the context in which it is presented.
42613	Clauses are mutually exclusive.
42614	A duplicate keyword is invalid.
42615	An invalid alternative was detected.
42617	The statement string is blank or empty.
42618	A host variable is not allowed.
42621	The check constraint is invalid.
42622	A name or label is too long.
42625	A CASE expression is invalid.
42626	A column specification is not allowed for a CREATE INDEX that is built on an auxiliary table.
42701	A duplicate column name in an INSERT or UPDATE statement was detected.
42702	A column reference is ambiguous, because of duplicate names.
42703	An undefined column or parameter name was detected.
42704	An undefined object or constraint name was detected.
42705	An undefined server-name was detected.
42707	A column name in ORDER BY does not identify a column of the result table.
42708	The locale specified in a SET LOCALE or locale sensitive function was not found.
42709	A duplicate column name in a PRIMARY, UNIQUE, or FOREIGN KEY clause was detected.
42710	A duplicate object or constraint name was detected.
42711	A duplicate column name was detected in the object definition or ALTER TABLE statement.
42712	A duplicate table designator was detected in the FROM clause. or REFERENCING clause of a CREATE TRIGGER statement.
42714	A host variable can be defined only once.
42718	The local server name is not defined.
42721	The special register name is unknown at the server.
42723	A function with the same signature already exists in the schema.
42724	Unable to access an external program used for a user-defined function or a procedure.
42725	A function was referenced directly (not by either signature or by specific instance name), but there is more than one specific instance of that function.
42734	A duplicate parameter-name was detected.
42801	Isolation level UR is invalid, because the result table is not read-only.
42802	The number of insert or update values is not the same as the number of columns.
42803	A column reference in the SELECT or HAVING clause is invalid, because it is not a grouping column; or a column reference in the GROUP BY clause is invalid.
42804	The result expressions in a CASE expression are not compatible.
42805	An integer in the ORDER BY clause does not identify a column of the result table.
42806	A value cannot be assigned to a host variable, because the data types are not compatible.
42807	The INSERT, UPDATE, or DELETE is not permitted on this object.
42808	A column identified in the INSERT or UPDATE statement is not updateable.
42809	The identified object is not the type of object to which the statement applies.
42810	A view is identified in a FOREIGN KEY clause.
42811	The number of columns specified is not the same as the number of columns in the SELECT clause.
42813	WITH CHECK OPTION cannot be used for the specified view.
42815	The data type, length, scale, value, or CCSID is invalid.
42816	A datetime value or duration in an expression is invalid.
42818	The operands of an operator or function are not compatible.
42819	An operand of an arithmetic operation or an operand of a function that requires a number is not a number.
42820	A numeric constant is too long, or it has a value that is not within the range of its data type.
42821	A data type for an assignment to a column is not compatible with the column data type.
42822	An expression in the ORDER BY clause or GROUP BY clause is not valid.
42823	The SELECT clause of a subquery specifies multiple columns.
42824	An operand of LIKE is not a string, or the first operand is not a column.
42825	The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have compatible columns.
42826	The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have the same number of columns.
42827	The table identified in the UPDATE or DELETE is not the same table designated by the cursor.
42828	The table designated by the cursor of the UPDATE or DELETE statement cannot be modified, or the cursor is read-only.
42829	FOR UPDATE OF is invalid, because the result table designated by the cursor cannot be modified.
42830	The foreign key does not conform to the description of the parent key.
42831	A column of a primary or unique key cannot allow null values.
42832	The operation is not allowed on system objects.
42834	SET NULL cannot be specified, because the foreign key does not allow null values.
42837	The column cannot be altered, because its attributes are not compatible with the current column attributes.
42842	A column definition is invalid, because a specified option is inconsistent with the column description.
42846	Cast from source type to target type is not supported.
42849	The specified option is not supported for external functions.
42852	The privileges specified in GRANT or REVOKE are invalid or inconsistent. (For example, GRANT ALTER on a view.)
42855	The assignment of the LOB to this host variable is not allowed. The target host variable for all fetches of this LOB value for this cursor must be a locator or LOB variable.
42856	The alter of a CCSID to the specified CCSID is not valid.
42866	The data type in either the RETURNS clause or the CAST FROM clause in the CREATE FUNCTION statement is not appropriate for the data type returned from the sourced function or RETURN statement in the function body.
42877	The column name cannot be qualified.
42878	An invalid function or procedure name was used with the EXTERNAL keyword.
42879	The data type of one or more input parameters in the CREATE FUNCTION statement is not appropriate for the corresponding data type in the source function.
42880	The CAST TO and CAST FROM data types are incompatible, or would always result in truncation of a fixed string.
42882	The specific instance name qualifier is not equal to the function name qualifier.
42883	No function was found with a matching signature.
42884	No function or procedure was found with the specified name and compatible arguments.
42885	The number of input parameters specified on a CREATE FUNCTION statement does not match the number provided by the function named in the SOURCE clause.
42886	The IN, OUT, or INOUT parameter attributes do not match.
42887	The function is not valid in the context where it occurs.
42888	The table does not have a primary key.
42889	The table already has a primary key.
42890	A column list was specified in the references clause, but the identified parent table does not have a unique constraint with the specified column names.
42893	The object or constraint cannot be dropped or authoritites cannot be revoked from the object, because other objects are dependent on it.
42894	The DEFAULT value is invalid.
42895	For static SQL, an input host variable cannot be used, because its data type is not compatible with the parameter of a procedure or user-defined function.
42898	An invalid correlated reference or transition table was detected in a trigger.
42899	Correlated references and column names are not allowed for triggered actions with the FOR EACH STATEMENT clause.
428B3	An invalid SQLSTATE was specified on RAISE_ERROR.
428B4	The part clause of a LOCK TABLE statement is not valid.
428C1	Only one ROWID column can be specified for a table.
428C7	A ROWID or reference column specification is not valid.
428C9	A ROWID column cannot be specified as the target column of an INSERT or UPDATE.
428D2	AS LOCATOR cannot be specified for a non-LOB parameter.
428D3	GENERATED was specified with a data type that is not a ROWID or a distinct type based on a ROWID.
42901	A column function does not include a column name.
42902	The object of the INSERT, UPDATE, or DELETE is also identified (possibly implicitly through a view) in a FROM clause.
42903	A WHERE, VALUES, GROUP BY, HAVING, or SET clause includes an invalid reference, such as a column or OLAP function.
42905	DISTINCT is specified more than once in a subselect.
42906	A column function in a subquery of a HAVING clause includes an expression that applies an operator to a correlated reference.
42907	The string is too long.
42908	The statement does not include a required column list.
42909	CREATE VIEW includes an operator or operand that is not valid for views. For example, UNION or UNION ALL.
42911	A decimal divide operation is invalid, because the result would have a negative scale.
42912	A column cannot be updated, because it is not identified in the UPDATE clause of the select-statement of the cursor.
42914	The DELETE is invalid, because a table referenced in a subquery can be affected by the operation.
42915	An invalid referential constraint has been detected.
42917	The object cannot be explicitly dropped.
42918	A user-defined data type cannot be created with a system-defined data type name (for example, INTEGER).
42920	A GROUP BY or HAVING clause is implicitly or explicitly specified in a SELECT INTO or a subquery of a basic predicate.
42924	An alias resolved to another alias rather than a table or view at the remote location.
42927	The function cannot be altered to NOT DETERMINISTIC or EXTERNAL ACTION because it is referenced by one or more existing views.
42932	The program preparation assumptions are incorrect.
42939	The object cannot be created, because the specified identifier is reserved for system use.
42945	ALTER CCSID is not allowed on a tablespace or database that contains a view.
42961	The server name specified does not match the current server.
42962	A long column, LOB column, structured type column or datalink column cannot be used in an index, a key, or a constraint.
42969	The package was not created and the current unit of work was rolled back, because of internal limitations or an invalid section number.
42972	An expression in a join-condition references columns in more than one of the operand tables.
42986	The source table in a RENAME TABLE statement is referenced in a view, trigger, or constraint.
42987	The statement is not allowed in a trigger.
42988	The operation is not allowed with mixed ASCII data.
42993	The column, as defined, is too large to be logged.
42995	The requested function does not apply to global temporary tables.
429B1	A stored procedure specifying COMMIT ON RETURN cannot be the target of a nested CALL statement.

Tabela 31. Class Code 56: Miscellaneous SQL or Product Error
SQLSTATE	Significado
56010	The subtype of a string variable is not the same as the subtype at bind time, and the difference cannot be resolved by character conversion.
56016	The partitioning keys are not specified in ascending or descending order.
56018	A column cannot be added to the table, because it has an edit procedure.
56023	An invalid reference to a remote object has been detected.
56025	An invalid use of AT ALL LOCATIONS in GRANT or REVOKE has been detected.
56027	A nullable column of a foreign key with a delete rule of SET NULL cannot be part of the key of a partitioned index.
56031	The clause or scalar function is invalid, because mixed and DBCS data are not supported on this system.
56036	Specific and non-specific volume IDs are not allowed in a storage group.
56038	The requested feature is not supported in this environment.
56040	CURRENT SQLID cannot be used in a statement that references remote objects.
56045	The application must issue a rollback operation to back out the change that was made at the read-only application server.
56052	The remote requester tried to bind, rebind, or free a trigger package.
56053	The parent of a table in a read-only shared database must also be a table in a read-only shared database.
56054	User-defined datasets for objects in a shared database must be defined with SHAREOPTIONS(1,3).
56055	The database is defined as SHARE READ, but the tablespace or indexspace has not been defined on the owning system.
56056	The description of an object in a SHARE READ database must be consistent with its description in the OWNER system.
56057	A database cannot be altered from SHARE READ to SHARE OWNER.
56059	An error occured when binding a triggered SQL statement.
56060	An LE function failed.
56062	A distributed operation is invalid, because the unit of work was started before DDF.
56064	The bind operation is disallowed, because the program depends on functions of a release from which fallback has occurred.
56065	The bind operation is disallowed, because the DBRM has been modified or was created for a different release.
56066	The rebind operation is disallowed, because the plan or package depends on functions of a release from which fallback has occurred.
56067	The rebind operation is disallowed, because the value of SYSPACKAGE.IBMREQD is invalid.
56080	The data type is not allowed in DB2 private protocol processing.
56082	The statement cannot be executed, because it identifies a DB2 system that does not support character conversion.
56084	The data type is not supported.
56088	ALTER FUNCTION failed because functions cannot modify data when they are processed in parallel.
56089	Specified option requires type 2 indexes.
56090	The type of the index cannot be changed.
56095	A bind option is invalid.
56096	Bind options are incompatible.
560A1	The tablespace name is not valid.
560A2	A LOB table and its associated base table space must be in the same database.
560A3	The table is not compatible with the database.
560A4	The operation is not allowed on an auxiliary table.
560A5	An auxiliary table already exists for the specified column or partition.
560A7	GBPCACHE NONE cannot be specified for a tablespace or index in GRECP.
560A8	An 8K or 16K bufferpool pagesize is invalid for a WORKFILE object.
560A9	An unsupported option was specified.

Tabela 5. SQLSTATE Class Codes
Class Code	Significado	For subcodes, refer to...
00	Unqualified Successful Completion	Tabela 6
01	Warning	Tabela 7
02	No Data	Tabela 8
07	Dynamic SQL Error	Tabela 9
08	Connection Exception	Tabela 10
09	Triggered Action Exception	Tabela 11
0A	Feature Not Supported	Tabela 12
0F	Invalid Token	Tabela 13
21	Cardinality Violation	Tabela 14
22	Data Exception	Tabela 15
23	Constraint Violation	Tabela 16
24	Invalid Cursor State	Tabela 17
25	Invalid Transaction State	Tabela 18
26	Invalid SQL Statement Identifier	Tabela 19
2D	Invalid Transaction Termination	Tabela 20
34	Invalid Cursor Name	Tabela 21
38	External Function Exception	Tabela 22
39	External Function Call Exception	Tabela 23
40	Transaction Rollback	Tabela 24
42	Syntax Error or Access Rule Violation	Tabela 25
44	WITH CHECK OPTION Violation	Tabela 26
51	Invalid Application State	Tabela 27
53	Invalid Operand or Inconsistent Specification	Tabela 28
54	SQL or Product Limit Exceeded	Tabela 29
55	Object Not in Prerequisite State	Tabela 30
56	Miscellaneous SQL or Product Error	Tabela 31
57	Resource Not Available or OperatorIntervention	Tabela 32
58	System Error	Tabela 33

Tabela 6. Class Code 00: Unqualified Successful Completion
SQLSTATE	Significado
00000	Execution of the SQL statement was successful and did not result in any type of warning or exception condition.

Tabela 8. Class Code 02: No Data
SQLSTATE	Significado
02000	One of the following exceptions occurred: ° The result of the SELECT INTO statement or the subselect of the INSERT statement was an empty table. ° The number of rows identified in the searched UPDATE or DELETE statement was zero. ° The position of the cursor referenced in the FETCH statement was after the last row of the result table.

Tabela 9. Class Code 07: Dynamic SQL Error
SQLSTATE	Significado
07001	The number of host variables is not the same as the number of parameter markers.
07002	The call parameter list or control block is invalid.
07003	The statement identified in the EXECUTE statement is a select-statement, or is not in a prepared state.
07005	The statement name of the cursor identifies a prepared statement that cannot be associated with a cursor.

Tabela 10. Class Code 08: Connection Exception
SQLSTATE	Significado
08001	The application requester is unable to establish the connection.
08002	The connection already exists.
08003	The connection does not exist.
08004	The application server rejected establishment of the connection.

Tabela 11. Class Code 09: Triggered Action Exception
SQLSTATE	Significado
09000	A triggered SQL statement failed.

Tabela 12. Class Code 0A: Feature Not Supported
SQLSTATE	Significado
0A001	The CONNECT statement is invalid, because the process is not in the connectable state.

Tabela 13. Class Code 0F: Invalid Token
SQLSTATE	Significado
0F001	The locator value does not currently represent any value.

Tabela 14. Class Code 21: Cardinality Violation
SQLSTATE	Significado
21000	The result of a SELECT INTO is a result table of more than one row, or the result of the subquery of a basic predicate is more than one value.
21501	A multiple-row INSERT into a self-referencing table is invalid.
21502	A multiple-row UPDATE of a primary key is invalid.

Tabela 15. Class Code 22: Data Exception
SQLSTATE	Significado
22001	Character data, right truncation occurred; for example, an update or insert value is a string that is too long for the column, or a datetime value cannot be assigned to a host variable, because it is too small.
22002	A null value, or the absence of an indicator parameter was detected; for example, the null value cannot be assigned to a host variable, because no indicator variable is specified.
22003	A numeric value is out of range.
22007	An invalid datetime format was detected; that is, an invalid string representation or value was specified.
22008	Datetime field overflow occurred; for example, an arithmetic operation on a date or timestamp has a result that is not within the valid range of dates.
22011	A substring error occurred; for example, an argument of SUBSTR is out of range.
22012	Division by zero is invalid.
22018	The character value for the CAST, DECIMAL, FLOAT, or INTEGER scalar function is invalid.
22019	The LIKE predicate has an invalid escape character.
22021	A character is not in the coded character set.
22023	A parameter or host variable value is invalid.
22024	A NUL-terminated input host variable or parameter did not contain a NUL.
22025	The LIKE predicate string pattern contains an invalid occurrence of an escape character.
22501	The length control field of a variable length string is negative or greater than the maximum.
22503	The string representation of a name is invalid.
22504	A mixed data value is invalid.
22505	The local date or time length has been increased, but the executing program relies on the old length.
22506	A reference to a datetime special register is invalid, because the TOD clock is malfunctioning or the operating system timezone parameter is out of range.
22508	CURRENT PACKAGESET is blank.
22511	ADT length exceeds maximum column length. The value for a ROWID or reference column is not valid.
22512	A host variable in a predicate is invalid, because its indicator variable is negative.
22522	A CCSID value is not valid at all, not valid for the data type or subtype, or not valid for the encoding scheme.
22525	Partitioning key value is not valid.

Tabela 16. Class Code 23: Constraint Violation
SQLSTATE	Significado
23502	An insert or update value is null, but the column cannot contain null values.
23503	The insert or update value of a foreign key is invalid.
23504	The update or delete of a parent key is prevented by a NO ACTION update or delete rule.
23505	A violation of the constraint imposed by a unique index or a unique constraint occurred.
23506	A violation of a constraint imposed by an edit or validation procedure occurred.
23507	A violation of a constraint imposed by a field procedure occurred.
23508	A violation of a constraint imposed by the DDL Registration Facility occurred.
23509	The owner of the package has constrained its use to environments which do not include that of the application process.
23510	A violation of a constraint on the use of the command imposed by the RLST table occurred.
23511	A parent row cannot be deleted, because the check constraint restricts the deletion.
23512	The check constraint cannot be added, because the table contains rows that do not satisfy the constraint definition.
23513	The resulting row of the INSERT or UPDATE does not conform to the check constraint definition.
23515	The unique index could not be created or unique constraint added, because the table contains duplicate values of the specified key.
23522	The range of an identity column has been exhausted.

Tabela 17. Class Code 24: Invalid Cursor State
SQLSTATE	Significado
24501	The identified cursor is not open.
24502	The cursor identified in an OPEN statement is already open.
24504	The cursor identified in the UPDATE, DELETE, SET, or GET statement is not positioned on a row.
24506	The statement identified in the PREPARE is the statement of an open cursor.
24516	A cursor has already been assigned to a result set.
24517	A cursor was left open by an external function.

Tabela 18. Class Code 25: Invalid Transaction State
SQLSTATE	Significado
25000	An update operation is invalid for the application execution environment.

Tabela 19. Class Code 26: Invalid SQL Statement Identifier
SQLSTATE	Significado
26501	The statement identified does not exist.

Tabela 20. Class Code 2D: Invalid Transaction Termination
SQLSTATE	Significado
2D521	SQL COMMIT or ROLLBACK are invalid in the current operating environment.
2D528	Dynamic COMMIT or COMMIT ON RETURN procedure is invalid for the application execution environment
2D529	Dynamic ROLLBACK is invalid for the application execution environment.

Tabela 21. Class Code 34: Invalid Cursor Name
SQLSTATE	Significado
34000	Cursor name is invalid.

Tabela 22. Class Code 38: External Function Exception
SQLSTATE	Significado
38xxx	Valid error SQLSTATEs returned by a user-defined function, external procedure, or trigger.
38001	The external routine is not allowed to execute SQL statements.
38002	The external routine attempted to modify data, but the routine was not defined as MODIFIES SQL DATA.
38003	The statement is not allowed in a routine.
38004	The external routine attempted to read data, but the routine was not defined as READS SQL DATA.
38503	A user-defined function or procedure has abnormally terminated (abend).
38505	An SQL statement is not allowed in user-defined function on a FINAL CALL.

Tabela 23. Class Code 39: External Function Call Exception
SQLSTATE	Significado
39001	A user-defined function has returned an invalid SQLSTATE.
39004	A null value is not allowed for an IN or INOUT argument when using PARAMETER STYLE GENERAL.
39501	An output argument value returned from a function or a procedure was too long.

Tabela 24. Class Code 40: Transaction Rollback
SQLSTATE	Significado
40001	Deadlock or timeout with automatic rollback occurred.

Tabela 26. Class Code 44: WITH CHECK OPTION Violation
SQLSTATE	Significado
44000	The INSERT or UPDATE is not allowed, because a resulting row does not satisfy the view definition.

Tabela 27. Class Code 51: Invalid Application State
SQLSTATE	Significado
51002	The package corresponding to an SQL statement execution request was not found.
51003	Consistency tokens do not match.
51004	An address in the SQLDA is invalid.
51005	The previous system error has disabled this function.
51006	A valid connection has not been established.
51015	An attempt was made to execute a section that was found to be in error at bind time.
51021	SQL statements cannot be executed until the application process executes a rollback operation.
51030	The procedure referenced in a DESCRIBE PROCEDURE statement or an ALLOCATE CURSOR statement has not yet been called within the application process.
51032	A valid ASCII CCSID has not yet been specified for this DB2 UDB for OS/390 subsystem.
51033	The operation is not allowed because it operates on a result set that was not created by the current server.
51034	The function contains an insert, update, or delete which is not valid in the context in which it is invoked.

Tabela 28. Class Code 53: Invalid Operand or Inconsistent Specification
SQLSTATE	Significado
53001	A clause is invalid, because the tablespace is a workfile.
53004	DSNDB07 is the implicit workfile database.
53014	The specified OBID is invalid.
53035	Key limits must be specified in the CREATE INDEX statement.
53036	The number of PART specifications is not the same as the number of partitions.
53037	A partitioned index cannot be created on a table in a non-partitioned tablespace.
53038	The number of key limit values is zero or greater than the number of columns in the key.
53039	The PART clause of the ALTER statement is omitted or invalid.
53040	The bufferpool cannot be changed to BP32K.
53041	BP32K cannot be used for an index.
53043	Columns with different field procedures cannot be compared.
53044	The columns have a field procedure, but the field types are not compatible.
53045	The data type of the key limit constant is not the same as the data type of the column.
53046	The index space is not valid.
53088	LOCKMAX is inconsistent with the specified LOCKSIZE.
53089	The number of host variable parameters for a stored procedure is not equal to the number of expected host variable parameters.
53090	Both ASCII and EBCDIC data cannot be referenced in the same SQL statement.
53091	The encoding scheme specified is not the same as the encoding scheme currently in use for the containing tablespace.
53092	Type 1 index cannot be created for a table using the ASCII encoding scheme.
53093	The FOR ASCII clause is not supported for this database or tablespace.
53094	The PLAN_TABLE cannot be created with the FOR ASCII clause.
53095	A system tablespace cannot be created with an explicit ASCII or EBCDIC clause.
53096	The PART clause was specified on CREATE AUXILIARY TABLE, but the base table isnot partitioned.
53097	LOBs cannot be specified as parameters when the NO WLM ENVIRONMENT is specified.
53098	The auxiliary table cannot be created because a column was specified that is not a LOB column.
53099	A WLM ENVIRONMENT name must be specified on the CREATE FUNCTION statement.

Tabela 29. Class Code 54: SQL or Product Limit Exceeded
SQLSTATE	Significado
54001	The statement is too long or too complex.
54002	A string constant is too long.
54004	The statement has too many table names or too many items in a SELECT or INSERT list.
54005	The sort key is too long, or has too many columns.
54006	The result of concatenation is too long.
54008	The key is too long, a column of the key is too long, or the key many columns.
54010	The record length of the table is too long.
54011	Too many columns were specified for a table or view.
54012	The FIELDPROC literal list is too long.
54021	Too many constraints, or the size of the constraint is too large.
54024	The check constraint is too long.
54025	The table description exceeds the maximum size of the object descriptor.
54027	The catalog has the maximum number of user-defined indexes.
54035	An internal object limit exceeded.
54038	Maximum depth of cascaded triggers exceeeded.
54041	Only 32767 OBIDs are allowed.
54042	Only one index is allowed on an auxiliary table.

Tabela 30. Class Code 55: Object Not in Prerequisite State
SQLSTATE	Significado
55002	The explanation table is not defined properly.
55003	The DDL registration table is not defined properly.
55004	The database cannot be accessed, because it is no longer a shared database.
55006	The object cannot be dropped, because it is currently in use by the same application process.
55011	The operation is disallowed, because the workfile database is not in the stopped state.
55012	A clustering index already exists on the table.
55014	The table does not have an index to enforce the uniqueness of the primary key.
55015	The ALTER statement cannot be executed, because the pageset is not in the stopped state.
55016	The ALTER statement is invalid, because the pageset has user-managed data sets.
55017	The table cannot be created in the tablespace, because it already contains a table.
55020	A work file database is already defined for the member.
55023	An error occurred calling a procedure.
55030	A package specified in a remote BIND REPLACE operation must not have a system list.
55035	The table cannot be dropped, because it is protected.

Tabela 32. Class Code 57: Resource Not Available or Operator Intervention
SQLSTATE	Significado
57001	The table is unavailable, because it does not have a primary index.
57002	GRANT and REVOKE are invalid, because authorization has been disabled.
57003	The specified bufferpool has not been activated.
57004	The table is unavailable, because it lacks a partitioned index.
57005	The statement cannot be executed, because a utility or a governor time limit was exceeded.
57006	The object cannot be created, because a DROP or CREATE is pending.
57007	The object cannot be used, because a DROP or ALTER is pending.
57008	The date or time local format exit has not been installed.
57010	A field procedure could not be loaded.
57011	Virtual storage or database resource is not available.
57012	A non-database resource is not available. This will not affect the successful execution of subsequent statements.
57013	A non-database resource is not available. This will affect the successful execution of subsequent statements.
57014	Processing was canceled as requested.
57015	Connection to the local DB2 not established.
57017	Character conversion is not defined.
57018	A DDL registration table or its unique index does not exist.
57023	The DDL statement cannot be executed, because a DROP is pending of a DDL registration table.
57033	Deadlock or timeout occurred without automatic rollback.
57051	The estimated CPU cost exceeds the resource limit.
57054	A table is not available until the auxiliary tables and indexes for its externally stored columns have been created.
57057	The SQL statement cannot be executed due to a prior contition in a DRDA chain of SQL statements.

Tabela 33. Class Code 58: System Error
SQLSTATE	Significado
58001	The database cannot be created, because the assigned DBID is a duplicate.
58002	An exit has returned an error or invalid data.
58003	An invalid section number was detected.
58004	A system error (that does not necessarily preclude the successful execution of subsequent SQL statements) occurred.
58005	A system error (that prevents the successful execution of subsequent SQL statements) occurred.
58006	A system error occurred during connection.
58008	Execution failed due to a distribution protocol error that will not affect the successful execution of subsequent DDM commands or SQL statements.
58009	Execution failed due to a distribution protocol error that caused deallocation of the conversation.
58010	Execution failed due to a distribution protocol error that will affect the successful execution of subsequent DDM commands or SQL statements.
58011	The DDM command is invalid while the bind process in progress.
58012	The bind process with the specified package name and consistency token is not active.
58013	The SQLCODE is inconsistent with the reply message.
58014	The DDM command is not supported.
58015	The DDM object is not supported.
58016	The DDM parameter is not supported.
58017	The DDM parameter value is not supported.
58018	The DDM reply message is not supported.
58026	The number of host variables in the statement is not equal to the number of host variables in SQLSTTVRB.