Table 8-1 Classes of SQLSTATE returned by HiRDB and their explanations

Class	Explanation	Reference
00	Terminated normally.	Table 8-2
01	A warning was issued.	Table 8-3
02	There is no data.	Table 8-4
07	An error occurred on a dynamic SQL statement.	Table 8-5
08	A connection violation occurred.	Table 8-6
0A	The facility is not supported.	Table 8-7
0F	A locator exception occurred.	Table 8-8
0K	RESIGNAL was executed while the handler was disabled.	Table 8-9
21	A base violation occurred.	Table 8-10
22	A data exception occurred.	Table 8-11
23	An integrity constraint violation occurred.	Table 8-12
24	The cursor status is invalid.	Table 8-13
25	The transaction status is invalid.	Table 8-14
26	The SQL statement name is invalid.	Table 8-15
28	The specified authorization identifier is invalid.	Table 8-16
2C	The character set name is invalid.	Table 8-17
2F	An SQL routine exception occurred.	Table 8-18
33	The SQL descriptor name is invalid.	Table 8-19
34	The cursor name is invalid.	Table 8-20
37	A syntax error or access rule violation was detected in a dynamic SQL statement.	Table 8-21
38	An external routine exception occurred.	Table 8-22
40	The transaction rolled back.	Table 8-23
42	A syntax error or access rule violation was detected.	Table 8-24
45	An unprocessed user definition exception occurred.	Table 8-25
51	An error related to a specific SQL facility occurred (error caused by a nonstandard specific SQL facility).	Table 8-26
52	The environment is not ready for SQL execution (this status occurs when the environment refuses to execute SQL statements. The environment status much be changed).	Table 8-27
53	The system resource status does not allow SQL execution (this status occurs when SQL execution is refused due to the system status, owing to a problem such as a shortage of memory or resources. The user might need to take some action on the system).	Table 8-28
54	The application program status is invalid (error caused by application program settings, details of processing, attributes, status, etc.).	Table 8-29
55	An error occurred on the remote system (such as an OS error or a communication error).	Table 8-30
56	The maximum or limit value was reached (error based on the maximum or minimum value permitted by the processors or system).	Table 8-31
57	The status of an SQL execution procedure object is invalid (error related to an SQL object, routine object, or SQL pool object).	Table 8-32
58	The RDAREA specification or RDAREA status is invalid (error caused by the specification, status, and type of RDAREA).	Table 8-33
59	The abstract data type or plug-in status is invalid (error caused by the abstract data type or plug-in registration status).	Table 8-34
5A	The list name or list status is invalid.	Table 8-35
5B	Processing was canceled by a user request (such as an interrupt).	Table 8-36
5C	A system error other than those described above or below occurred.	Table 8-37
5E	The view object status is invalid.	Table 8-38
IZ	An error specific to a utility or non-SQLAPI occurred.	Table 8-39
R2	There is no data.	Table 8-40

Table 8-2 SQLSTATE class 00

SQLSTATE	Explanation	SQLCODE
00000	Terminated normally.	0

Table 8-3 SQLSTATE class 01

SQLSTATE	Explanation	SQLCODE
01000	Terminated normally with a warning.	0
0100C	A dynamic results set was returned.	+120
0100D	Another result set was returned.	+121
0100E	An attempt was made to return too many result sets.	+120
01R00	Terminated normally with a warning.	Positive number other than 100 or 110

Table 8-4 SQLSTATE class 02

SQLSTATE	Explanation	SQLCODE
02000	There is no data.	100
02001	There is no other result set to be returned.	100

Table 8-5 SQLSTATE class 07

SQLSTATE	Explanation	SQLCODE
07001	One of the following errors is present: The data type or data length of an input variable set in the SQL descriptor area is invalid. For details, refer to the KFPA11311-E message. The number of ? parameters in the SQL statement does not match the number specified in SQLD in the SQL descriptor area. For details, refer to the KFPA11313-E message.	-311 -313
07002	The data type or data length of an output variable set in the SQL descriptor area is invalid. For details, refer to the KFPA11311-E message.	-311
07003	Refer to the KFPA11506-E message.	-506
07005	Refer to the KFPA11507-E message.	-507
07006	One of the following errors is present: The data type of the input variable cannot be converted, or the structure of the input variable does not match. For details, refer to the KFPA11301-E message The data type of the input variable cannot be converted, or the structure of the input variable does not match. For details, refer to the KFPA11303-E message.	-301 -303
07008	Refer to the KFPA11310-E message.	-310
07501	Refer to the KFPA11308-E message.	-308
07502	Refer to the KFPA11340-E message.	-340
07503	Refer to the KFPA11901-E message.	-901

Table 8-6 SQLSTATE class 08

SQLSTATE	Explanation	SQLCODE
08000	The authorization identifier is invalid. For details, refer to the KFPA11564-E message.	-564
08002	Refer to the KFPA11752-E message.	-752
08007	Refer to the KFPA11966-E message.	-966
08603	Refer to the KFPA11940-E message.	-940
08605	Refer to the KFPA11990-E message.	-990
08606	Refer to the KFPA19632-E message.	-1632
08620	Refer to the KFPA11932-E message.	-932
08621	Refer to the KFPA19521-E message.	-1521
08622	Refer to the KFPA11930-E message.	-930

Table 8-7 SQLSTATE class 0A

SQLSTATE	Explanation	SQLCODE
0A503	Refer to the KFPA11948-E message.	-948
0A504	Refer to the KFPA11950-E message.	-950
0A505	Refer to the KFPA11988-E message.	-988
0A507	Refer to the KFPA11899 message.	-899

Table 8-8 SQLSTATE class 0F

SQLSTATE	Explanation	SQLCODE
0F001	Refer to the KFPA11364-E message.	-364

Table 8-9 SQLSTATE class 0K

SQLSTATE	Explanation	SQLCODE
0K000	Refer to the KFPA19403-E message.	-1403

Table 8-10 SQLSTATE class 21

SQLSTATE	Explanation	SQLCODE
21501	Refer to the KFPA11449-E message.	-449
21502	Refer to the KFPA11450-E message.	-450

Table 8-11 SQLSTATE class 22

SQLSTATE	Explanation	SQLCODE
22001	One of the following errors is present: An input data or a function argument is too long. For details, refer to the KFPA11404-E message. The length of a character string data item falls beyond the permitted value range. For details, refer to the KFPA11420-E message. Character truncation occurred. For details, refer to the KFPA11453-E message. Data in the RETURN statement is longer than the return value. For details, refer to the KFPA11469-E message.	-404 -420 -453 -469
22002	A data value assigned to the locator is the null value, but no indicator variable is specified. For details, refer to the KFPA11305-E and KFPA11366-E messages.	-305 -366
22003	One of the following errors is present: Input data falls beyond the permitted value range. For details, refer to the KFPA11302-E message. The ength of data to be output exceeds the variable attribute. For details, refer to the KFPA11304-E message. An input variable falls beyond the permitted value range. For details, refer to the KFPA11326-E message. The source data falls beyond the convertible range. For details, refer to the KFPA11453-E or KFPA19345-E message. The operation resulted in an overflow because the value fell beyond the permitted range for the data type. For details, refer to the KFPA11801-E message. An overflow occurred during set function processing. For details, refer to the KFPA11802-E message.	-302 -304 -326 -453 -801 -802 -1345
22004	One of the following errors is present: The null value was specified for a column for which the null value is not permitted. For details, refer to the KFPA11212-E message. The null value was specified as a signal value. For details, refer to the KFPA19294-E message.	-212 -1294
22007	The operation resulted in an overflow because the specified date representation is invalid. For details, refer to the KFPA11801-E message.	-801
22008	One of the following errors is present: The value in the date field falls beyond the permitted range. For details, refer to the KFPA11326-E message. The character string representation is invalid in the date field. For details, refer to the KFPA11416-E message. A date field operation resulted in an overflow. For details, refer to the KFPA11801-E message.	-326 -416 -801
2200A	Refer to the KFPA11938-E message.	-938
22011	In the SUBSTR scalar function, the end location falls before the start location. For details, refer to the KFPA11427-E message.	-427
22012	A division by zero error occurred during an arithmetic operation. For details, refer to the KFPA11800-E and KFPA19326-E messages.	-800 -1326
22014	Refer to the KFPA11367-E message.	-367
22015	The value of the time interval field falls beyond the permitted range. For details, refer to the KFPA11326-E message.	-326
22018	The format of a character-string literal in the conversion source data or the value of the conversion source data is invalid. For details, refer to the KFPA11453-E message.	-453
22019	The length of the escape character specified in the LIKE, XLIKE, or SIMILAR predicate is not one character. For details, refer to the KFPA11424-E message.	-424
22025	An invalid method was used to specify the escape character or pattern character string in the LIKE, XLIKE, or SIMILAR predicate. For details, refer to the KFPA11424-E message.	-424
22027	The length of the TRIM character is not one character. For details, refer to the KFPA11425-E message.	-425
2202F	The number of elements in the input data is greater than the maximum number of elements for a repetition column. For details, refer to the KFPA11302-E message.	-302
22501	The number of elements in the input data does not match the number of elements in the array. For details, refer to the KFPA11302-E message.	-302
22503	Refer to the KFPA11306-E message.	-306
22504	Refer to the KFPA11310-E message.	-310
22505	Data in the input variable contradicts the information specified in the embedded variable, parameter variable declaration, or SQL descriptor area. (If the input variable is variable-length data, the input variable length exceeds the maximum value or is less than 0). For details, refer to the KFPA11326-E message.	-326
22506	Data in the input variable contradicts the information specified in the embedded variable, parameter variable declaration, or SQL descriptor area. (If the input variable is LOB data, the input variable length exceeds the maximum value or is less than 0). For details, refer to the KFPA11326-E message.	-326
22507	Data in the input variable contradicts the information specified in the embedded variable, parameter variable declaration, or SQL descriptor area. (If the input variable is a repetition column, the current number of elements for the input variable exceeds the maximum number of elements or is less than 0). For details, refer to the KFPA11326-E message.	-326
22508	Refer to the KFPA11170-E message.	-170
22509	Refer to the KFPA11223-E message.	-223
2250G	One of the following errors is present: The format specified in the scalar function is invalid. For details, refer to the KFPA11360-E message. A scalar function's representation using a character string does not match the specified format. For details, refer to the KFPA11361-E message. A required format element is missing in the format specified by the scalar function. For details, refer to the KFPA11362-E message.	-360 -361 -362
2250J	Refer to the KFPA11316-E message.	-316
22510	Refer to the KFPA11381-E message.	-381
22511	Refer to the KFPA11430-E message.	-430
22512	Refer to the KFPA11993-E message.	-993
22513	Refer to the KFPA19183-E message.	-1183
22514	Refer to the KFPA19320-E message.	-1320
22515	Refer to the KFPA19325-E message.	-1325
22516	Refer to the KFPA19801-E message.	-1801
22520	A key value cannot be generated for the data type from the substructure value specified in the definition of substructure index. For details, refer to the KFPA19311-E message.	-1311
22521	Refer to the KFPA19346-E message.	-1346
22522	Refer to the KFPA19347-E message.	-1347
22523	Refer to the KFPA19348-E message.	-1348
22524	Refer to the KFPA19349-E message.	-1349
22525	Refer to the KFPA19350-E message.	-1350
22526	Refer to the KFPA19351-E message.	-1351
22527	Refer to the KFPA19352-E message.	-1352
22528	Refer to the KFPA19353-E message.	-1353
22529	Refer to the KFPA19354-E message.	-1354

Table 8-12 SQLSTATE class 23

SQLSTATE	Explanation	SQLCODE
23001	A RESTRICT violation occurred. For details, refer to the KFPA11451-E message.	-451
23502	A NOT NULL constraint violation occurred. For details, refer to the KFPA11210-E message.	-210
23503	A violation of a referential constraint occurred. Refer to the KFPA11451-E message.	-451
23505	One of the following errors is present: An attempt was made to create an index with UNIQUE specified, but the table data contains duplicate column values. For details, refer to the KFPA11603-E message. An attempt was made to add a duplicate column value to an index with UNIQUE specified, or to the primary key. Alternatively, an attempt was made to update a column value to a duplicate value. For details, refer to the KFPA11803-E message.	-603 -803
23506	Refer to the KFPA19582-E message.	-1582
23507	Refer to the KFPA19717-E message.	-1717
23514	A violation of a check constraint occurred. For details, refer to the KFPA11451-E message.	-451

Table 8-13 SQLSTATE class 24

SQLSTATE	Explanation	SQLCODE
24000	This cursor cannot be used to update or delete rows due to one of the following errors: The cursor is not open. The row has not been fetched. All rows at the cursor have already been searched. An error occurred while a row was being fetched. For details, refer to the KFPA11330-E and KFPA11332-E messages.	-330 -332
24501	Refer to the KFPA11500-E message.	-500
24502	Refer to the KFPA11711-E message.	-711
24504	Refer to the KFPA11501-E message.	-501
24505	Refer to the KFPA11502-E message.	-502
24506	Refer to the KFPA11505-E message.	-505
24507	Refer to the KFPA11994-E message.	-994
24509	Refer to the KFPA19508-E message.	-1508
24510	Refer to the KFPA19509-E message.	-1509

Table 8-14 SQLSTATE class 25

SQLSTATE	Explanation	SQLCODE
25501	Refer to the KFPA11980-E message.	-980
25502	Refer to the KFPA11998-E message.	-998
25503	Refer to the KFPA19703-E message.	-1703

Table 8-15 SQLSTATE class 26

SQLSTATE	Explanation	SQLCODE
26000	Refer to the KFPA11512-E message.	-512

Table 8-16 SQLSTATE class 28

SQLSTATE	Explanation	SQLCODE
28501	Refer to the KFPA11560-E message.	-560
28502	Refer to the KFPA11561-E message.	-561

Table 8-17 SQLSTATE class 2C

SQLSTATE	Explanation	SQLCODE
2C000	Refer to the KFPA19104-E message.	-1104

Table 8-18 SQLSTATE class 2F

SQLSTATE	Explanation	SQLCODE
2F002	Refer to the KFPA11495-E message.	-495

Table 8-19 SQLSTATE class 33

SQLSTATE	Explanation	SQLCODE
33501	Refer to the KFPA19506-E message.	-1506
33502	Refer to the KFPA19507-E message.	-1507

Table 8-20 SQLSTATE class 34

SQLSTATE	Explanation	SQLCODE
34501	Refer to the KFPA11233-E message.	-233

Table 8-21 SQLSTATE class 37

SQLSTATE	Explanation	SQLCODE
37901	Refer to the KFPA11331-E message.	-331

Table 8-22 SQLSTATE class 38

SQLSTATE	Explanation	SQLCODE
38501	Refer to the KFPA11245-E message.	-245
38502	Refer to the KFPA11246-E message.	-246
38503	Refer to the KFPA11247-E message.	-247
38504	Refer to the KFPA11248-E message.	-248
38507	Refer to the KFPA19335-E message.	-1335
38508	Refer to the KFPA19336-E message.	-1336

Table 8-23 SQLSTATE class 40

SQLSTATE	Explanation	SQLCODE
40000	Refer to the KFPA11716-E message.	-716
40001	Serialization failed due to one of the following causes: Another user is using the resources of the specified table, and for this reason the lock prohibits execution of the SQL statement, DELETE (operation) command, or DELETE subcommand. For details, refer to the KFPA11770-I message. A deadlock occurred. For details, refer to the KFPA11911-E message.	-770 -911
40501	Refer to the KFPA11713-E message.	-713
40503	Refer to the KFPA11756-E message.	-756
40505	Refer to the KFPA11806-E message.	-806
40506	Refer to the KFPA11809-I message.	-809
40507	Refer to the KFPA11822-E message.	-822
40508	Refer to the KFPA11879-E message.	-879
40509	Refer to the KFPA11487-E message.	-487
4050F	Refer to the KFPA11912-E message.	-912
4050G	Refer to the KFPA11913-E message.	-913
4050N	Refer to the KFPA11931-E message.	-931
4050I	Refer to the KFPA11925-E message.	-925
4050K	Refer to the KFPA11927-E message.	-927
4050L	Refer to the KFPA19940-E message.	-1940
4050M	Refer to the KFPA19941-E message.	-1941
40510	Refer to the KFPA11488-E message.	-488
40511	Refer to the KFPA11489-E message.	-489
40512	Refer to the KFPA11490-E message.	-490
40513	Refer to the KFPA11494-E message.	-494
40514	Refer to the KFPA11530-E message.	-530
40515	Refer to the KFPA11595-E message.	-595
40516	Refer to the KFPA11740-E message.	-740
40517	Refer to the KFPA11797-E message.	-797
40518	Refer to the KFPA11808-E message.	-808
40519	Refer to the KFPA11828-E message.	-828
40520	Refer to the KFPA11876-E message.	-876
40521	Refer to the KFPA11877-E message.	-877
40522	Refer to the KFPA11878-E message.	-878
40523	Refer to the KFPA11886-E message.	-886
40525	Refer to the KFPA11892-E message.	-892
40526	Refer to the KFPA11945-E message.	-945
40527	Refer to the KFPA11958-E message.	-958
40528	Refer to the KFPA11959-E message.	-959
40529	Refer to the KFPA11981-E message.	-981
40530	Refer to the KFPA11986-E message.	-986
40531	Refer to the KFPA11989-E message.	-989
40532	Refer to the KFPA11992-E message.	-992
40533	Refer to the KFPA19311-E message.	-1311
40534	Refer to the KFPA19313-E message.	-1313
40535	Refer to the KFPA19400-E message.	-1400
40537	Refer to the KFPA19455-E message	-1455
40538	Refer to the KFPA19703-E message.	-1703
40539	Refer to the KFPA19716-E message.	-1716
40540	Refer to the KFPA19633-E message.	-1633
40541	Refer to the KFPA11898-E message.	-898
40542	The following SQL statements cannot be executed on a shared table unless the LOCK statement with IN EXCLUSIVE MODE specified is executed: INSERT statement UPDATE statement that accompanies index updating UPDATE statement specifying DEFAULT as the update value for the TIMESTAMP column for which the DEFAULT clause with USING BES specified is defined DELETE statement For details, refer to the KFPA11296-E message.	-296
40543	Refer to the KFPA19713-E message.	-1713
40544	Refer to the KFPA19721-E message.	-1721
40601	Refer to the KFPA11917-E message.	-917
40602	Refer to the KFPA11918-E message.	-918
40603	Refer to the KFPA11891-E message.	-891
40620	Refer to the KFPA11920-E message.	-920
40621	Refer to the KFPA11928-I message.	-928
40622	Refer to the KFPA19701-E message.	-1701
40623	Refer to the KFPA19702-E message.	-1702
40701	Refer to the KFPA11934-E message.	-934
40702	Refer to the KFPA11953-E message.	-953
40703	Refer to the KFPA11342-E message.	-342
40A01	The transaction rolled back due to an integrity error in the dictionary. For details, refer to the message corresponding to the SQLCODE.	--
40A02	The transaction rolled back due to a basic unit error in SQL. For details, refer to the message corresponding to the SQLCODE.	--
40B01	The transaction rolled back due to a list processing error. For details, refer to the message corresponding to the SQLCODE.	--
40B02	The transaction rolled back due to an index processing error. For details, refer to the message corresponding to the SQLCODE.	--
40B03	The transaction rolled back due to an inner replica error. For details, refer to the message corresponding to the SQLCODE.	--
40B04	The transaction rolled back due to a cursor processing error. For details, refer to the message corresponding to the SQLCODE.	--
40B05	The transaction rolled back due to a transaction error. For details, refer to the message corresponding to the SQLCODE.	--
40B08	The transaction rolled back due to a resource release failure. For details, refer to the message corresponding to the SQLCODE.	--
40B09	The transaction rolled back due to a routine processing error. For details, refer to the message corresponding to the SQLCODE.	--
40B10	The transaction rolled back due to a privilege manipulation error. For details, refer to the message corresponding to the SQLCODE.	--
40B11	The transaction rolled back due to an update processing error. For details, refer to the message corresponding to the SQLCODE.	--
40B12	The transaction rolled back due to a constraint processing error. For details, refer to the message corresponding to SQLCODE.	--
40B13	The transaction rolled back due to a preprocessing error. For details, refer to the message corresponding to the SQLCODE.	--
40B14	The transaction rolled back due to an intermediate result acquisition failure. For details, refer to the message corresponding to the SQLCODE.	--
40B15	The transaction rolled back due to an abstract data type error. For details, refer to the message corresponding to the SQLCODE.	--
40B16	The transaction rolled back due to a communication processing error. For details, refer to the message corresponding to the SQLCODE.	--
40B17	The transaction rolled back due to a lock error. For details, refer to the message corresponding to the SQLCODE.	--
40B18	The transaction rolled back due to an array processing error. For details, refer to the message corresponding to the SQLCODE.	--
40B19	The transaction rolled back due to a memory allocation failure. For details, refer to the message corresponding to the SQLCODE.	--
40B20	The transaction rolled back due to an embedded language syntax error. For details, refer to the message corresponding to the SQLCODE.	--
40C01	The transaction rolled back due to an error in the definition SQL. For details, refer to the message corresponding to the SQLCODE.	--
40C02	The transaction rolled back because there is already a resource to be defined. For details, refer to the KFPA11601-E message.	-601
40C03	One of the following errors is present: The table, index, trigger, or sequence generator was not found in the HiRDB system. For details, refer to the KFPA11204-E message. The specified routine was not found in the HiRDB system. For details, refer to the KFPA11529-E message.	-204 -529 -624
40C04	One of the following errors is present: The table, index, trigger, or sequence generator was not found in the HiRDB system. For details, refer to the KFPA11204-E message. The specified user-defined type was not found in the HiRDB system. For details, refer to the KFPA11224-E message. The specified routine was not found in the HiRDB system. For details, refer to the KFPA11529-E message.	-204 -224 -529 -624 -660
40C05	One of the following errors is present: The table, index, trigger, or sequence generator was not found in the HiRDB system. For details, refer to the KFPA11204-E message. The specified user-defined type was not found in the HiRDB system. For details, refer to the KFPA11224-E message. The specified routine was not found in the HiRDB system. For details, refer to the KFPA11529-E message. The following SQL statements cannot be executed due to a missing schema: ALTER PROCEDURE ALTER ROUTINE CREATE FUNCTION CREATE INDEX CREATE PROCEDURE CREATE TABLE CREATE TRIGGER CREATE TYPE CREATE VIEW DROP SCHEMA For details, refer to the KFPA11656-E message. The audit event specified in AUDIT is not defined. For details, refer to the KFPA11909-E message. The SQL statement specified in the connection security facility cannot be executed. For details, refer to the KFPA19633-E message.	-204 -224 -529 -624 -656 -721 -909 -1633
40C06	The transaction rolled back because the same index was already defined during a CREATE INDEX operation. For details, refer to the KFPA11601-E message.	-601
40C07	One of the following errors is present: The table identifier, index identifier, routine identifier, trigger identifier, constraint name, data type identifier, or index type identifier specified in the SQL statement has already been defined. For details, refer to the KFPA11601-E message. The specified schema has already been defined. For details, refer to the KFPA11664-E message. The audit event specified in CREATE AUDIT has already been defined. For details, refer to the KFPA11908-E message. The SQL statement specified in the connection security facility cannot be executed. For details, refer to the KFPA19633-E message.	-601 -664 -721 -908 -1633
40C08	One of the following errors is present: The user is not authorized to execute the SQL statement. For details, refer to the KFPA11548-E message. The executor cannot define or delete access privileges for the table because the executor is not the owner of the table. For details, refer to the KFPA11551-E message. Because the user does not have DBA privileges, the user cannot execute the following SQL statements: GRANT DBA GRANT CONNECT GRANT RDAREA GRANT SCHEMA REVOKE DBA REVOKE CONNECT REVOKE RDAREA REVOKE SCHEMA For details, refer to the KFPA11552-E message. The user cannot create schemas, delete schemas, re-create procedures, or re-create SQL objects as triggers for another user. For details, refer to the KFPA11573-E message. The user cannot define schemas because the user does not have schema definition privileges. For details, refer to the KFPA11579-E message. The user cannot define a table or an index that is owned by another user. For details, refer to the KFPA11607-E message. The following SQL statements cannot be executed due to a missing schema: ALTER PROCEDURE ALTER ROUTINE CREATE FUNCTION CREATE INDEX CREATE PROCEDURE CREATE SEQUENCE CREATE TABLE CREATE TRIGGER CREATE TYPE CREATE VIEW DROP SCHEMA For details, refer to the KFPA11656-E message. Because the user does not have audit privileges, the user cannot execute the following operations: CREATE AUDIT DROP AUDIT GRANT AUDIT DROP TABLE for audit trail table For details, refer to the KFPA11905-E message. The SQL statement specified in the connection security facility cannot be executed. For details, refer to the KFPA19633-E message.	-548 -551 -552 -573 -579 -607 -656 -905 -1633
40D01	Refer to the KFPA11940-E message.	-940
40D10	Refer to the KFPA19451-E message.	-1451
40D30	Refer to the KFPA11948-E message.	-948
40D31	Refer to the KFPA11950-E message.	-950
40D50	Refer to the KFPA11404-E message.	-404
40D51	Refer to the KFPA11801-E message.	-801
40D52	Refer to the KFPA11223-E message.	-223
40D53	Refer to the KFPA11321-E message.	-321
40D70	Refer to the KFPA11210-E message.	-210
40D71	Refer to the KFPA11603-E message.	-603
40D72	Refer to the KFPA11451-E message.	-451
40D73	One of the following errors is present: A violation of a referential constraint or check constraint occurred. For details, refer to the KFPA11451-E message. The column cannot be deleted for one of the following reasons: A check constraint is defined for the table that contains the column to be deleted. A reference constraint (foreign key) is defined for the table that contains the column to be deleted. The table containing the column to be deleted is the referenced table for the reference constraint. For details, refer to the KFPA19582-E message.	-451 -1582
40D90	Refer to the KFPA11996-E message.	-996
40DB0	Refer to the KFPA11492-E message.	-492
40DB1	Refer to the KFPA11493-E message.	-493
40DD0	Refer to the KFPA11204-E message.	-204
40DD1	Refer to the KFPA11224-E message.	-224
40DD2	Refer to the KFPA11101-E message.	-101
40DD3	There is no column in a WITH clause or correlation name query of a table or of a derived table in the FROM clause. For details, refer to the KFPA11205-E message.	-205
40DD4	Refer to the KFPA19727-E message.	-1727
40DH0	Refer to the KFPA11206-E message.	-206
40DH1	Refer to the KFPA11601-E message.	-601
40DH2	Refer to the KFPA11656-E message.	-656
40DH3	Refer to the KFPA11660-E message.	-660
40DH4	Refer to the KFPA11664-E message.	-664
40DH5	Refer to the KFPA11743-E message.	-743
40DH6	Refer to the KFPA11744-E message.	-744
40DH7	Refer to the KFPA11749-E message.	-749
40DH8	Refer to the KFPA11741-E message.	-741
40DH9	Refer to the KFPA11624-E message.	-624
40DHA	Refer to the KFPA11893-E message.	-893
40DHB	Refer to the KFPA11894-E message.	-894
40DHC	CLUSTER KEY, PRIMARY KEY, or PRIMARY CLUSTER KEY is not defined for the table. For details, refer to the KFPA11207-E message.	-207
40DHD	The specified data type does not have the specified attribute. For details, refer to the KFPA11228-E message.	-228
40DHE	PUBLIC, MASTER, HiRDB, or ALL is specified for the authorization identifier. For details, refer to the KFPA11549-E message.	-549
40DHF	One of the following errors is present: The same RDAREA name is specified more than once for the primary key, cluster key, RDAREA for table, RDAREA for LOB column, or RDAREA for LOB attribute in CREATE TABLE. The same RDAREA name is specified more than once in CREATE INDEX. An attempt was made to add the RDAREA that already contains this table by using ALTER TABLE. For details, refer to the KFPA11574-E message.	-574
40DHG	A plug-in index cannot be applied to routines. A plug-in index can be applied to a plug-in function that has been implemented by a plug-in and for which SCAN TYPE is specified as the operation qualifier of the plug-in IDL. For details, refer to the KFPA11583-E message.	-583
40DHH	The column specified as an index is not appropriate for the index type. For details, refer to the KFPA11584-E message.	-584
40DHI	NULL cannot be specified in the column definition for a table with FIX specified. For details, refer to the KFPA11591-E message.	-591
40DHJ	NULL cannot be specified in the column definition for a column for which a single column uniqueness constraint definition or a multicolumn uniqueness constraint definition is defined. For details, refer to the KFPA11592-E message.	-592
40DHK	ALTER TABLE cannot delete a column for which BLOB or abstract is specified as its data type. For details, refer to the KFPA11597-E message.	-597
40DHL	Another plug-in index has already been applied to the routine. For details, refer to the KFPA11600-E message.	-600
40DHM	The total number of columns per table has already exceeded the permitted maximum value (30,000). For details, refer to the KFPA11602-E message.	-602
40DHN	SUPPRESS cannot be specified for a table with the FIX attribute. For details, refer to the KFPA11605-E message.	-605
40DHP	Neither a variable-length column, nor a column with a user-defined type, nor a repetition column can be defined for a table with the FIX attribute. For details, refer to the KFPA11609-E message.	-609
40DHQ	Because this is not a hash row-partitioned table, the hash function cannot be renamed nor can an RDAREA be added. For details, refer to the KFPA11611-E message.	-611
40DHR	The same column name cannot be defined more than once for the same table. For details, refer to the KFPA11612-E message.	-612
40DHT	A FLOAT or SMALLFLT type column cannot be specified for a multicolumn index, multicolumn primary key, or multicolumn cluster key. For details, refer to the KFPA11615-E message.	-615
40DHU	The column name or the column name constituting a primary key or cluster key specified in CREATE INDEX is duplicated. For details, refer to the KFPA11619-E message.	-619
40DHV	Neither UNIQUE nor PRIMARY KEY can be specified for a flexible hash-partitioned table or a matrix partitioning table using flexible hash partitioning. For details, refer to the KFPA11620-E message.	-620
40DHW	An index with UNIQUE specified cannot be defined for a repetition column. For details, refer to the KFPA11621-E message.	-621
40DHX	One of the following errors is present with regard to the hash function name: The specified hash function name does not exist. The key length of the specified hash function is greater than the column length of the hash partitioning key. For details, refer to the KFPA11622-E message.	-622
40DHY	The following table restriction definitions cannot be specified for a repetition column: CLUSTER KEY: Cluster key PRIMARY KEY: Primary key FOREIGN KEY: Foreign key For details, refer to the KFPA11625-E message.	-625
40DHZ	When a table is defined or a table definition is changed, neither a NOT NULL constraint nor a character set can be specified for a repetition column. For details, refer to the KFPA11628-E message.	-628
40DI0	If the column type is not abstract data, neither change nor drop processing can be performed on the column. If the column type is abstract data, neither change nor drop processing can be performed on the table that contains the column. The column types are as follows: CLUSTER KEY: Column constituting a cluster key FOREIGN KEY: Column constituting a foreign key PRIMARY KEY: Column constituting a primary key PARTITION KEY: Column constituting a partitioning key REFERENCED PRIMARY KEY: Column constituting a primary key of a referenced table TRIGGER: Column in a trigger definition that is qualified and referenced by the old or new values correlation name CHECK: Check constraint definition abstract data: Abstract data type For details, refer to the KFPA11631-E message.	-631
40DI1	The column cannot be deleted because it is the only column in the table. For details, refer to the KFPA11632-E message.	-632
40DI2	The storage condition column, boundary-value partitioning column, or hash partitioning key column does not have the NOT NULL constraint. For details, refer to the KFPA11633-E message.	-633
40DI3	ALL cannot be used for a table identifier. For details, refer to the KFPA11658-E message.	-658
40DI4	The data type and data length specified in the CHANGE clause are invalid. For details, refer to the KFPA11659-E message.	-659
40DI5	The index has already been defined in HiRDB. For details, refer to the KFPA11661-E message.	-661
40DI6	The information specified in the CHANGE clause in ALTER TABLE (maximum number of elements in the repetition column, data type, data length, default value (WITH DEFAULT, SET DEFAULT clause, or DROP DEFAULT clause), or variable-length character string data storage method) is the same as before the change. For details, refer to the KFPA11665-E message.	-665
40DI7	The maximum number of elements specified in the CHANGE clause in ALTER TABLE contains one of the following errors: An attempt was made to reduce the maximum number of elements An attempt was made to change a repetition column to a non-repetition column or a non-repetition column to a repetition column. The maximum number of elements has not changed, but * is not specified. For details, refer to the KFPA11667-E message.	-667
40DI8	A referenced table for a reference constraint cannot be deleted. For details, refer to the KFPA11690-E message.	-690
40DI9	A cluster key clause cannot be specified together with a primary key clause for the same column structure. For details, refer to the KFPA11693-E message.	-693
40DIA	When the attribute of a cluster key was changed, one of the following errors occurred: An attempt was made to change a cluster key with UNIQUE already specified to UNIQUE, or to change a cluster key with UNIQUE not specified to non-UNIQUE. An attempt was made, using flexible hash partitioning, to change a cluster key for a flexible hash-partitioned table or a matrix partitioning table to UNIQUE. For details, refer to the KFPA11694-E message.	-694
40DIB	When a table is defined or a table definition is changed, WITH DEFAULT cannot be specified for a column without the NOT NULL constraint. For details, refer to the KFPA11697-E message.	-697
40DIC	NOT NULL cannot be specified for a column configured for the abstract data type. For details, refer to the KFPA11698-E message.	-698
40DID	WITH DEFAULT has already been specified for the column. For details, refer to the KFPA11699-E message.	-699
40DIF	An index with UNIQUE specified cannot be defined for one of the following reasons: In a table that is row-partitioned over multiple back-end servers, the columns comprising the index do not include all the columns specified as table partitioning keys. In a rebalancing table with FIX hash partitioning in a single server or a single back-end server, the columns comprising the index do not include all the columns specified as table partitioning keys. For details, refer to the KFPA11702-E message.	-702
40DIG	Neither BLOB nor BINARY can be specified as the data type for a table with the FIX attribute, nor can any character set be specified for an attribute name in a type definition. For details, refer to the KFPA11704-E message.	-704
40DIH	The PCTFREE or SEGMENT REUSE option value exceeds the maximum value in CREATE TABLE, CREATE INDEX, or ALTER TABLE. For details, refer to the KFPA11705-E message.	-705
40DII	The name of an attribute that constitutes a single data type must be unique in all abstract data types that have inheritance relationships. For details, refer to the KFPA11712-E message.	-712
40DIJ	The table or column cannot be renamed for one of the following reasons: A viewed table is created on the basis of the table to be changed. A trigger is defined for the table to be changed. A check constraint is defined for the table to be changed. A column in the table to be changed is used in the search condition for a check constraint. A reference constraint (foreign key) is defined for the table to be changed. The column to be changed is a component of a foreign key. The table to be changed is a referenced table for a reference constraint. The column to be changed is a component of the primary key of a referenced table for a reference constraint. The table to be changed is specified in a stored procedure or a triggered SQL statement. An attempt was made to rename a column of a viewed table. An attempt was made to rename a column specified in the trigger execution timing. An attempt was made to rename a column referenced by using an old or new values correlation name in the search condition for a trigger action. An attempt was made to rename a column referenced by using an old or new values correlation name in the triggered SQL statement. An attempt was made to rename a falsification prevented table or its column. For details, refer to the KFPA11717-E message.	-717
40DIK	The definition for column data control contains one of the following errors: This definition is specified for a FIX table. This definition is specified for a column whose data type is neither CHAR, nor MCHAR, nor NCHAR. This definition is specified for a repetition column. For details, refer to the KFPA11718-E message.	-718
40DIN	None of the following columns can be specified for a partitioning key: CHAR, VARCHAR, MCHAR, or MVARCHAR with a definition length of 256 bytes or more NCHAR or NVARCHAR with a definition length of 128 characters or more For single column partitioning, a column that constitutes a cluster key other than the first column constituting the cluster key For multicolumn partitioning or matrix partitioning, a column whose specification order for the partitioning key differs from that for the cluster key BLOB Column that duplicates a partitioning key for multicolumn partitioning or matrix partitioning A repetition column BINARY TIMESTAMP whose precision in a fraction of a second is greater than 0 Column for which CURRENT_TIMESTAMP USING BES is specified as the default value Column fo rwhich abstract data type is specified For details, refer to the KFPA11745-E message.	-745
40DIO	The condition value for the storage condition specified for a column contains one of the following errors: The data type of the condition value cannot be changed to the data type of the column specified in the storage condition. The data length of the condition value exceeds the data length of the column specified in the storage condition. The condition value is logically invalid. Data for the condition value is invalid. The data length of the condition value converted with a character set specified exceeds the data length of the column specified in the partitioning condition. For details, refer to the KFPA11746-E message.	-746
40DIP	The storage condition specified for a partitioning key contains one of the following errors: As a result of evaluating the storage conditions in the order specified, there is no row to be stored according to the storage condition. The storage condition is specified for two or more columns. The length of character string specified for the storage condition is 0. For details, refer to the KFPA11747-E message.	-747
40DIQ	The ALLOCATE clause specified for a column is invalid. For details, refer to the KFPA11750-E message.	-750
40DIR	The option specified for a column is invalid. For details, refer to the KFPA11753-E message.	-753
40DIS	A duplicate routine name is specified in the FOR clause in CREATE INDEX. For details, refer to the KFPA11754-E message.	-754
40DIT	The specified exceptional key value for the index contains one of the following errors: NULL is specified as a value constituting the exceptional key value for a column with the NOT NULL constraint. An exceptional key value is specified for the index for a repetition column. For details, refer to the KFPA11758-E message.	-758
40DIU	That SQL statement cannot be executed because the plug-in has not been registered. For details, refer to the KFPA11761-E message.	-761
40DIV	The number of columns constituting the index does not match the number of values constituting the exceptional key value. For details, refer to the KFPA11764-E message.	-764
40DIW	One of the following errors is present: For multi-value, the following columns cannot be specified: BLOB columns of abstract data type or BINARY type For no-split or split, the following columns cannot be specified: Columns other than VARCHAR, MVARCHAR, or NVARCHAR For collating-sequence, the following columns cannot be specified: Columns other than CHAR, VARCHAR, MCHAR, MVARCHAR, NCHAR, or NVARCHAR For trailing-space, the following columns cannot be specified: Columns other than VARCHAR, MVARCHAR, or NVARCHAR For recovery, non-BLOB columns and columns whose attribute is not BLOB cannot be specified. For the with default clause, columns of the abstract data type cannot be specified. For details, refer to the KFPA11766-E message.	-766
40DIX	The specified function cannot be defined because it has the same name and the same SQL parameter structure as a system-provided function. For details, refer to the KFPA11775-E message.	-775
40DIY	There is an error in the number of RDAREAs specified for the index. For details, refer to the KFPA11791-E message.	-791
40DIZ	The RDAREA in the index definition with partitioning specified does not correspond to the RDAREA for the boundary value-partitioned or hash row-partitioned table. For details, refer to the KFPA11793-E message.	-793
40DJ0	The DEFAULT clause is invalid at one of the following locations: Table definition Table definition update (when the DEFAULT clause is specified or deleted) SQL variable declaration in a routine definition For details, refer to the KFPA11798-E message.	-798
40DJ1	The audit event specified in CREATE AUDIT has already been defined. For details, refer to the KFPA11908-E message.	-908
40DJ2	The audit event specified in DROP AUDIT is not defined. For details, refer to the KFPA11909-E message.	-909
40DJ3	The total length of attributes defined with abstract data types is too large. For details, refer to the KFPA11939-E message.	-939
40DJ4	There is an error in the shared table or shared index definition. For details, refer to the KFPA19575-E message.	-1575
40DJ5	There is an error in the reference constraint definition or check constraint definition. For details, refer to the KFPA19581-E message.	-1581
40DJ6	In a reference constraint, the primary key of the same referenced table cannot be referenced from the same set of columns (the order might not be the same). For details, refer to the KFPA19602-E message.	-1602
40DJ7	The column cannot be changed for one of the following reasons: The corresponding column is referenced by using an old or new values correlation name in the search condition for a trigger action. This column cannot be changed or deleted. The corresponding column is referenced by using an old or new values correlation name in the triggered SQL statement. This column cannot be changed or deleted. For details, refer to the KFPA19603-E message.	-1603
40DJ8	The specified matrix partitioning table is invalid. For details, refer to the KFPA19612-E message.	-1612
40DJ9	A definition SQL statement cannot be executed on a falsification prevented table that stores data. For details, refer to the KFPA19615-E message.	-1615
40DJA	The insert history maintenance column specified in the deletion prevented duration for a falsification prevented table cannot be deleted. For details, refer to the KFPA19616-E message.	-1616
40DJB	Only a column of DATE type with SYSTEM GENERATED specified can be specified for the insert history maintenance column of a falsification prevented table. For details, refer to the KFPA19617-E message.	-1617
40DJC	The deletion prevented duration specified for a falsification prevented table is invalid. For details, refer to the KFPA19620-E message.	-1620
40DJD	There is an error in the specified ALTER TABLE CHANGE RDAREA. For details, refer to the KFPA19625-E message.	-1625
40DJH	A sequence generator cannot be created. For details, refer to the KFPA19624-E message.	-1624
40DJI	The table cannot be set to be expanded to or released from the memory database. For details, refer to the KFPA19864-E message.	-1864
40DJJ	The definition SQL statement cannot be executed because this table is to be expanded to the memory database. For details, refer to the KFPA19865-E message.	-1865
40DJK	There is an error in the definition of a temporary table or temporary table index. For details, refer to the KFPA19621-E or KFPA19622-E message.	-1621 -1622
40DJL	Refer to the KFPA19604-E message.	-1604
40DJM	There is an error specifying a reserved column definition, or adding, dropping, or excising a column. For details, refer to the following messages: KFPA11626-E KFPA11632-E KFPA11681-E KFPA11682-E KFPA11683-E KFPA11684-E KFPA11695-E KFPA11696-E	-626 -632 -681 -682 -683 -684 -695 -696
40DJN	ALTER TABLE cannot be executed. For details, refer to the KFPA19613-E message.	-1613
40DJO	ALTER TABLE cannot change the table definition due to the free space reusage facility. For details, refer to the KFPA11751-E message.	-751
40DL0	Refer to the KFPA11552-E message.	-552
40DL1	Refer to the KFPA11559-E message.	-559
40DL2	Refer to the KFPA11576-E message.	-576
40DL3	Refer to the KFPA11577-E message.	-577
40DL4	Refer to the KFPA11578-E message.	-578
40DL5	Refer to the KFPA11579-E message.	-579
40DL6	Refer to the KFPA11580-E message.	-580
40DL7	Refer to the KFPA11562-E message.	-562
40DL8	Refer to the KFPA19683-E message.	-1683
40DL9	Refer to the KFPA11571-E message.	-571
40DLA	Refer to the KFPA11903-E message.	-903
40DLB	Refer to the KFPA11905-E message.	-905
40DLC	One of the following errors is present: The SQL statement cannot be executed because the user does not have the required privileges for the corresponding table. When the optimizing information collection utility (pdgetcst) was used, the user did not have SELECT privileges for the table to be processed. For details, refer to the KFPA11548-E message.	-548
40DLD	Because the executor is not the owner of the table, the executor cannot execute the SQL statement or grant another user a privilege that the executor does not have. For details, refer to the KFPA11551-E message.	-551
40DLE	The user cannot grant a privilege to him/herself. For details, refer to the KFPA11554-E message.	-554
40DLF	The user cannot revoke his/her own privilege. For details, refer to the KFPA11555-E message.	-555
40DLG	The list of authorization identifiers specified in the GRANT statement (defining privileges) or the REVOKE statement (revoking privileges) contains the table owner's authorization identifier. For details, refer to the KFPA11556-E message.	-556
40DLH	One or more ofhe following cannot be executed: Creation of a base table, a viewed table, or an index owned by another user Dropping of a base table, a viewed table, or an index owned by another user Changing the table definition for a table owned by another user Adding comments to a base table or a viewed table owned by another user Creation or deletion of a procedure owned by another user Creation or deletion of a function owned by another user Creation or deletion of a data type owned by another user Creation or deletion of an index type owned by another user Changing a data type owned by another user Changing an index type owned by another user Definition or deletion of a trigger owned by another user Definition or deletion of a sequence generator owned by another user For details, refer to the KFPA11607-E message.	-607
40DLJ	The following SQL statements cannot be executed because the rebalancing utility is executing: ALTER TABLE CREATE INDEX For details, refer to the KFPA11823-E message.	-823
40DLK	The INSERT, UPDATE, and DELETE privileges for an audit trail table or a viewed table based on the audit trail table cannot be granted to a user who is not the auditor. For details, refer to the KFPA11902-E message.	-902
40DLL	Usage privileges for an RDAREA storing an audit trail table cannot be granted to a user who is not the auditor. For details, refer to the KFPA11904-E message.	-904
40DLM	The auditor's schema cannot be deleted because there is an audit trail table. For details, refer to the KFPA11906-E message.	-906
40DLN	The auditor's schema definition privileges and CONNECT privileges cannot be revoked. For details, refer to the KFPA11907-E message.	-907
40DLO	An error occurred in a definition related to a falsification prevented table. For details, refer to the KFPA19631-E message.	-1631
40DLP	The GRANT statement could not be executed due to one of the following password violations: Minimum length in bytes, prohibition of authorization identifier specification, prohibition of specification in a single character type For details, refer to the KFPA19634-E message.	-1634
40DLQ	The GRANT DBA statement cannot be used to grant DBA privileges or change the password, due to the password-invalid account lock state. For details, refer to the KFPA19635-E message.	-1635
40DLR	In the audit event definition, a combination of operation type, event type, and other operands is invalid. For details, refer to the KFPA19680-E message.	-1680
40DLS	The specified privilege cannot be granted or revoked. For details, refer to the KFPA19610-E message.	-1610
40DN0	Refer to the KFPA11307-E message.	-307
40DN1	Refer to the KFPA11209-E message.	-209
40DP0	Refer to the KFPA11787-E message.	-787
40DR0	No new update transaction is accepted while both-system operation is being restored. For details, refer to the KFPA19726-E message.	-1726
40DT0	Refer to the KFPA11692-E message.	-692
40DT1	Refer to the KFPA11777-E message.	-777
40DT2	Refer to the KFPA11930-E message.	-930
40DT3	Refer to the KFPA11929-E message.	-929
40DT4	Refer to the KFPA11811-E message.	-811
40DT5	Refer to the KFPA11814-E message.	-814
40DT6	Refer to the KFPA19718-E message.	-1718
40DT7	Refer to the KFPA11919-E message.	-919
40DT8	Refer to the KFPA11531-E message.	-531
40DT9	Refer to the KFPA19705-E message.	-1705
40DTA	Because the data dictionary LOB RDAREA is not defined, the following SQL statements cannot be executed: ALTER PROCEDURE ALTER ROUTINE ALTER TRIGGER CALL statement CREATE FUNCTION CREATE PROCEDURE CREATE TRIGGER CREATE TYPE DROP FUNCTION DROP PROCEDURE Function invocation For details, refer to the KFPA11596-E message.	-596
40DTB	None of the following operations can be executed on a table containing data: add column: Addition of a column with a NOT NULL constraint or DEFAULT clause specified, or addition of a column to a FIX table add rdarea: Addition of an RDAREA to a FIX hash-partitioned table that does not use the rebalancing facility change no split or change split: Changing the no-split option change set default: Specifying or changing a default value change drop default: Deleting a default value change cluster key: Changing the attribute of a cluster key change hash: Changing the hash function for a FIX hash-partitioned table drop column: Dropping columns change insert only: Changing a non-falsification-prevented table to a falsification prevented table For details, refer to the KFPA11613-E message.	-613
40DTC	Because the specified RDAREA is a shared RDAREA, none of the following operations can be performed: Definition of a table other than the shared table Definition of an index other than the shared index Addition of an RDAREA Changing the partition storage condition For details, refer to the KFPA19576-E message.	-1576
40DTD	There is a shortage of shared memory for locking. For details, refer to the KFPA11914-E message.	-914
40DTE	The resource cannot be accessed because one of the following resources is in use by a definition SQL statement or utility: A table, routine, or sequence generator is in use. For details, refer to the KFPA19670-E message. A table, routine, sequence generator, or abstract data type is in use. For details, refer to the KFPA19671-E message.	-1670 -1671
40DTG	Refer to the KFPA19724-E message.	-1724
40DTH	Refer to the KFPA19725-E message.	-1725
40DX0	Refer to the KFPA11812-E message.	-812
40DX1	Refer to the KFPA11657-E message.	-657
40DX2	Refer to the KFPA11827-E message.	-827
40DX3	Refer to the KFPA11952-E message.	-952
40DX4	Refer to the KFPA19706-E message.	-1706
40DX5	The key length of an index exceeds the maximum value. For details, refer to the KFPA11616-E message.	-616
40DX6	The number of partitions exceeds the system limit (1,024 for a rebalancing table, 4,096 otherwise). Alternatively, the number of RDAREA names specified for storage exceeds the system limit (4,096). For details, refer to the KFPA11634-E message.	-634
40DX7	The number of tables in an RDAREA, the total number of sequence generators, or the number of indexes exceeds the permitted maximum value. For details, refer to the KFPA11654-E message.	-654
40DX8	changedata length or add rdarea cannot be executed because the key length of an index exceeds the permitted maximum value. For details, refer to the KFPA11662-E message.	-662
40DX9	A single table cannot be partitioned and defined in 4,097 or more back-end servers. For details, refer to the KFPA11703-E message.	-703
40DXA	The number of indexes specified for a single table exceeds the maximum value (255). For details, refer to the KFPA11706-E message.	-706
40DXB	The ADT LEVEL value (number of generations of abstract data type) exceeds 30,000, which is the maximum value permitted for the system. For details, refer to the KFPA11714-E message.	-714
40DXC	The number of foreign keys referencing the primary key of a referenced table exceeds the maximum value (255). For details, refer to the KFPA11748-E message.	-748
40DXD	The number of RDAREAs with duplicates excluded that can be specified when a table or index is partitioned exceeds the maximum value. For details, refer to the KFPA11795-E message.	-795
40DXE	The number of foreign keys that can be specified for a single table exceeds the maximum value (255). For details, refer to the KFPA19583-E message.	-1583
40DXF	The check constraint cannot be defined because the number of check constraints defined for the table (total number of Boolean operators specified in the check constraint search condition (number of ANDs and ORs excluding the ANDs and ORs in the WHEN search condition in the CASE expression) and the total number of check constraints) exceeds the maximum value (254). For details, refer to the KFPA19584-E message.	-1584
40E01	Refer to the KFPA11528-E message.	-528
40E02	Refer to the KFPA11529-E message.	-529
40E03	Refer to the KFPA11537-E message.	-537
40E20	Refer to the KFPA11652-E message.	-652
40E21	Refer to the KFPA11653-E message.	-653
40E22	Refer to the KFPA11358-E message.	-358
40E23	Refer to the KFPA11511-E message.	-511
40E24	Refer to the KFPA11737-E message.	-737
40E25	Refer to the KFPA11738-E message.	-738
40E26	Refer to the KFPA11815-E message.	-815
40E27	The table or index cannot be dropped or the table definition cannot be changed because a copied RDAREA is defined. For details, refer to the KFPA11513-E message.	-513
40E28	The specified RDAREA is not a user LOB RDAREA. For details, refer to the KFPA11599-E message.	-599
40E29	The user is not authorized to use the specified RDAREA. Therefore, the table, sequence generator, or index cannot be created. For details, refer to the KFPA11608-E message.	-608
40E2A	There is no available public user RDAREA. For details, refer to the KFPA11610-E message.	-610
40E2B	If the name of an RDAREA for a table is duplicated or an RDAREA for a table that is already in use for the target table is specified in ALTER TABLE ADD RDAREA, the specification for the RDAREA for the table does not match the specification for the following items: RDAREA for LOB column RDAREA for LOB attribute For details, refer to the KFPA11707-E message.	-707
40E2C	The specified LOB RDAREA is not on the same server as the RDAREA for the table. For details, refer to the KFPA11708-E message.	-708
40E2D	The specified LOB RDAREA is already in use for another table. For details, refer to the KFPA11709-E message.	-709
40E2E	The specified RDAREA for the index is not on the server that contains the RDAREA for the table. For details, refer to the KFPA11771-E message.	-771
40E2F	The same RDAREA as the immediately preceding RDAREA cannot be specified. For details, refer to the KFPA11796-E message.	-796
40E2G	The specified RDAREA contains one of the following errors: For error code=1 No other table or index can be stored in the specified user RDAREA because it contains a rebalancing table. For error code=2 No rebalancing table can be stored in the specified user RDAREA because it already contains another table or index. For error code=3 When an index is defined for a rebalancing table, specification of an RDAREA for the index cannot be omitted. For details, refer to the KFPA11845-E message.	-845
40E2I	Refer to the KFPA19704-E message.	-1704
40E40	Refer to the KFPA11431-E message.	-431
40E41	Refer to the KFPA11897-E message.	-897
40E42	Refer to the KFPA11964-E message.	-964
40E43	No SQL statement other than ROLLBACK or DISCONNECT can be executed. For details, refer to the KFPA11987-E message.	-987
40E60	Refer to the KFPA11810-E message.	-810
40E61	One of the following errors is present: An attempt was made to perform batch creation of an index that had already been created. For details, refer to the KFPA11875-E message. Contents of the specified index information file do not match the data in the table. Therefore, the index information file cannot be used to perform batch creation of an index. For details, refer to the KFPA11883-E message.	-875 -883
40E62	Refer to the KFPA11882-E message.	-882
40E63	Refer to the KFPA11884-E message.	-884
40E64	Refer to the KFPA19523-E message.	-1523

Legend:

--: Not applicable

Table 8-24 SQLSTATE class 42

SQLSTATE	Explanation	SQLCODE
42000	One of the following errors is present: The specified viewed table was defined with duplicate elimination specified in the FROM clause in a subquery. For details, refer to the Refer to the KFPA11639-E message. For a derived table with a name that was derived by a query with the GROUP BY clause, HAVING clause, or a set function specified, a table join was specified in the view definition, the derived query expression in a query for the WITH clause, or the query with a value expression specified in the GROUP BY clause. For details, refer to the KFPA11643-E message. For a derived table with a name that was derived by a query with the GROUP BY clause, HAVING clause, or a set function specified, the GROUP BY clause, HAVING clause, or a set function is specified in the view definition, the derived query expression in a query for the WITH clause, or the query with a value expression specified in the GROUP BY clause. For details, refer to the KFPA11644-E message. A value expression other than the column specification is specified in a query (SELECT statement) for a viewed table that was defined with duplicate elimination (DISTINCT) specified. For details, refer to the KFPA11645-E message. A table join is specified in a query (SELECT statement) for a viewed table that was defined with duplicate elimination (DISTINCT) specified. For details, refer to the KFPA11646-E message. Duplicate elimination is specified in a query for a viewed table that was derived with duplicate elimination (DISTINCT) specified. For details, refer to the KFPA11647-E message. A query with a value expression other than the column specification specified in the GROUP BY clause, or a subquery for the WHERE clause in a query with a value expression other than the column specification specified in the GROUP BY clause, is specified as the query for creating an internal derived table. For details, refer to the KFPA11648-E message. The GROUP BY clause, HAVING clause, or a set function is specified for a derived table with a name that was derived with duplicate elimination (DISTINCT) specified. For details, refer to the KFPA11649-E message. The name of the base table for the viewed table or the viewed table name is invalid, or the name of the base table for the viewed table is the same as the name of the viewed table. For details, refer to the KFPA11669-E message. The lock option is omitted in the query for searching for the table to be expanded to the memory database, or a nonzero value is specified in the PDISLLVL client environment definition. For details, refer to the KFPA19198-E message. ON COMMIT was specified when defining a permanent base table. For details, refer to the KFPA19522-E message.	-639 -643 -644 -645 -646 -647 -648 -649 -669 -1198 -1522
42501	The number of characters specified in the character string literal exceeds the permitted maximum value. For details, refer to the KFPA11102-E message.	-102
42502	Refer to the KFPA11145-E message.	-145
42503	The number of characters specified in the national character string literal or the number of characters in the result of a concatenation operation between national character string literals exceeds the permitted maximum value. For details, refer to the KFPA11104-E and KFPA11141-E messages.	-104 -141
42504	The number of characters specified in the mixed character string literal exceeds the permitted maximum value. For details, refer to the KFPA11102-E and KFPA11140-E messages.	-102 -140
42505	The character string literal is not complete. For details, refer to the KFPA11106-E message.	-106
42506	The hexadecimal character string literal is not complete. For details, refer to the KFPA11106-E message.	-106
42507	Refer to the KFPA11140-E message.	-140
42508	The mixed character string literal is not complete. For details, refer to the KFPA11106-E message.	-106
42509	Refer to the KFPA11144-E message.	-144
42510	There are one or more characters that violate the syntax rules. For details, refer to the KFPA11104-E message.	-104
42511	Refer to the KFPA11410-E message.	-410
42512	Refer to the KFPA11103-E message.	-103
42513	The value of the specified numeric literal falls beyond the permitted value range. For details, refer to the KFPA11405-E message.	-405
42514	Refer to the KFPA11142-E message.	-142
42520	Refer to the KFPA11107-E message.	-107
42529	The authorization identifier is longer than 8 characters. For details, refer to the Refer to the KFPA11564-E message.	-564
42530	The identifier does not begin with an alphabetic character, or the delimited identifier is not complete. For details, refer to the KFPA11104-E message.	-104
42539	There is a syntax error in the authorization identifier. For details, refer to the KFPA11564-E message.	-564
42550	Refer to the KFPA11418-E message.	-418
42551	Refer to the KFPA11217-E message.	-217
42561	There is an error in the left-hand operand of the NULL predicate. For details, refer to the KFPA11114-E message.	-114
42562	There is an error in the left-hand operand of the LIKE predicate. For details, refer to the KFPA11114-E message.	-114
42563	The XMLEXISTS predicate is specified outside the WHERE clause. For details, refer to the KFPA11114-E message.	-114
42570	The UPDATE or DELETE statement using the cursor cannot be preprocessed by the PREPARE statement. For details, refer to the KFPA11157-E message.	-157
42572	Refer to the KFPA11149-E message.	-149
42573	Refer to the KFPA11164-E message.	-164
42580	The subscript specified for a repetition column is invalid. For details, refer to the KFPA11186-E message.	-186
42581	In the column definition in CREATE TABLE or ALTER TABLE, there is an error in the maximum number of elements or the number of elements specified for a repetition column. For details, refer to the KFPA11189-E message.	-189
42590	Refer to the KFPA11604-E message.	-604
42591	Refer to the KFPA11131-E message.	-131
425A0	The number of specified embedded variables, parameters, ? parameters, SQL variables, and SQL parameters exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425A2	Refer to the KFPA11139-E message.	-139
425A4	The number of simple WHEN clauses or searched WHEN clauses and ELSE clauses specified in the CASE expression exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425A6	The number of specified row value constructor elements exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425B0	The number of tables specified in the query exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425B1	The number of specified selection expressions exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425B2	Refer to the KFPA11122-E message.	-122
425B3	Refer to the KFPA11124-E message.	-124
425B4	The number of column specifications in the FOR UPDATE clause exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425B5	The number of specified insertion values exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425B6	The number of columns to be inserted exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425B7	The number of columns to be updated exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425B8	The number of arguments specified in the arguments list exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425B9	The number of table names specified in the LOCK statement exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425BB	The number of column names specified in the derived columns list exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425BC	The number of list names exceeds the permitted maximum value. For details, refer to the KFPA11773-E message.	-773
425C0	Refer to the KFPA11602-E message.	-602
425C1	The number of columns in the view columns list specified in the view definition exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425C2	The number of foreign keys specified in the table definition or the number of foreign keys resulting from the addition made by altering the table definition exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425C3	The number of predicates specified in a check constraint exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425C6	The number of columns specified in the index definition exceeds the permitted maximum value. For details, refer to the KFPA11617-E message.	-617
425C7	The number of tables specified in the index definition exceeds the permitted maximum value. For details, refer to the KFPA11617-E message.	-617
425C8	The number of exception values specified in the index definition exceeds the permitted maximum value. For details, refer to the KFPA11617-E message.	-617
425C9	The number of exception key values specified in the index definition exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
425CA	Refer to the KFPA11570-E message.	-570
425CB	Refer to the KFPA11585-E message.	-585
425CC	The number of columns for the primary key in CREATE TABLE exceeds the permitted maximum value. For details, refer to the KFPA11674-E message.	-674
425CD	The number of columns specified for multicolumn hash partitioning in CREATE TABLE exceeds the permitted maximum value. For details, refer to the KFPA11674-E message.	-674
425CE	The number of columns for the cluster key in CREATE TABLE exceeds the permitted maximum value. For details, refer to the KFPA11674-E message.	-674
425D0	Refer to the KFPA11678-E message.	-678
425D3	There is one of the following syntax errors in ALTER TABLE: The maximum number of elements or the number of elements is specified twice in the column definition. For details, refer to the KFPA11189-E message. The specification for the column to be added or changed in ALTER TABLE is invalid. For details, refer to the KFPA11676-E message.	-189 -676
425D4	Refer to the KFPA11673-E message.	-673
425D5	There is an error in the specified table options or index options. For details, refer to the KFPA11705-E message.	-705
425D7	Refer to the KFPA11572-E message.	-572
425DP	Refer to the KFPA11136-E message.	-136
425E0	Refer to the KFPA11633-E message.	-633
425L0	Refer to the KFPA11778-E message.	-778
425L1	Refer to the KFPA11781-E message.	-781
425L2	Refer to the KFPA11782-E message.	-782
425L5	Refer to the KFPA11191-E message.	-191
42601	There is an excess character string at the end of the SQL statement, or the first keyword is invalid in the SQL statement. For details, refer to the KFPA11104-E message.	-104
42602	Refer to the KFPA11105-E message.	-105
42603	Refer to the KFPA11106-E message.	-106
42604	Refer to the KFPA11116-E message.	-116
42605	Refer to the KFPA11138-E message.	-138
42606	Refer to the KFPA11173-E message.	-173
42607	Refer to the KFPA11175-E message.	-175
42608	Refer to the KFPA11289-E message.	-289
42609	Refer to the KFPA11292-E message.	-292
42610	Refer to the KFPA11355-E message.	-355
42611	Refer to the KFPA11461-E message.	-461
42613	Refer to the KFPA11508-E message.	-508
42614	Refer to the KFPA11638-E message.	-638
42615	Refer to the KFPA11641-E message.	-641
42618	Refer to the KFPA19323-E message.	-1323
42619	Refer to the KFPA19407-E message.	-1407
42620	Refer to the KFPA19408-E message.	-1408
42621	A column that is not the last column of the table was specified as a reserved column. For details, refer to the KFPA19106-E message.	-1106
42701	The number of literals exceeds the permitted maximum value. For details, refer to the KFPA11102-E and KFPA11141-E messages.	-102 -141
42702	Refer to the KFPA11161-E message.	-161
42703	The value specified for a numeric literal falls beyond the permitted value range (this is an integer literal specified for a labeled duration). For details, refer to the KFPA11405-E message.	-405
42704	Refer to the KFPA11128-E message.	-128
42710	Refer to the KFPA11112-E message.	-112
42711	Refer to the KFPA11113-E message.	-113
42712	Refer to the KFPA11402-E message.	-402
42713	Refer to the KFPA11403-E message.	-403
42714	Refer to the KFPA11120-E message.	-120
42716	Refer to the KFPA11127-E message.	-127
42720	Refer to the KFPA11117-E message.	-117
42721	Refer to the KFPA11195-E message.	-195
42722	Refer to the KFPA11192-E message.	-192
42723	Refer to the KFPA11650-E message.	-650
42730	Refer to the KFPA11211-E message.	-211
42731	Refer to the KFPA11121-E message.	-121
42732	Refer to the KFPA11123-E message.	-123
42733	Refer to the KFPA11458-E message.	-458
42734	Refer to the KFPA11459-E message.	-459
42740	One of the following errors is present: The table specification qualifying the column name is not the valid name specified in the SQL statement, or the qualification of the SQL parameter or SQL variable is not the valid name specified in the SQL statement. For details, refer to the KFPA11201-E message. The column name, *, or table specification qualifying ROW is not the valid name specified in the SQL statement. For details, refer to the KFPA11241-E message. The SQL parameter or the qualification of the SQL variable is not the valid name specified in the SQL statement, or a column specification is specified at an invalid location. For details, refer to the KFPA11251-E message.	-201 -241 -251
42741	Refer to the KFPA11204-E message.	-204
42742	One of the following errors is present: The specified column was not found in the SQL statement, table in the query specification, or query name; or, the SQL variable or SQL parameter is not declared in the routine. For details, refer to the KFPA11202-E message. The specified column was not found in the specified table, or in the correlation name for a derived table in the FROM clause, or in the query name in the query in the WITH clause. For details, refer to the KFPA11205-E message. The column name specified in the ON condition is not in the table to be joined by the join table that contains the ON condition or is not in the table that allows external references. For details, refer to the KFPA11227-E message. The specified column is neither in the SQL statement, nor in the table in the query specification, nor in the query name. For details, refer to the KFPA11242-E message. The specified SQL variable or SQL parameter is not declared in the routine, or a column name is specified at an invalid location. For details, refer to the KFPA11252-E message. The specified SQL variable was not found in the statement label or loop variable. For details, refer to the KFPA11255-E message. The specified SQL parameter was not found in the routine. For details, refer to the KFPA11256-E message.	-202 -205 -227 -242 -252 -255 -256
42743	One of the following errors is present: There is an error in the sort item specification number specified in the ORDER BY clause. For details, refer to the KFPA11125-E message. The column specified in the ORDER BY clause was not found in the column specification in the SELECT clause in the outermost query. For details, refer to the KFPA11208-E message.	-125 -208
42744	One of the following errors is present: It cannot be determined to which table or query name the specified column belongs because this column is in two or more tables' query names or tables in the query. For details, refer to the KFPA11203-E message. It cannot be determined to which table the ROW specification corresponds because two or more corresponding tables in the query contain ROW. For details, refer to the KFPA11213-E message.	-203 -213
42745	One of the following errors is present: There are multiple identical columns in the derived table in the FROM clause. For details, refer to the KFPA11218-E message. The table derived as a result of a query contains two or more columns specified in the ORDER BY clause. For details, refer to the KFPA11220-E message.	-218 -220
42746	Refer to the KFPA11119-E message.	-119
42747	Refer to the KFPA11224-E message.	-224
42748	Refer to the KFPA11260-E message.	-260
42749	Refer to the KFPA11239-E message.	-239
42750	Refer to the KFPA11214-E message.	-214
42751	Refer to the KFPA11215-E message.	-215
42752	Refer to the KFPA11216-E message.	-216
42754	Refer to the KFPA11180-E message.	-180
42755	One of the following errors is present: A repetition column with a subscript omitted is specified at an invalid location. For details, refer to the KFPA11181-E message. A repetition column with a subscript specified is specified at an invalid location. For details, refer to the KFPA11182-E message. A repetition column is specified at an invalid location. For details, refer to the KFPA11183-E message.	-181 -182 -183
42756	Refer to the KFPA11184-E message.	-184
42757	Refer to the KFPA11185-E message.	-185
42758	Refer to the KFPA11186-E message.	-186
42759	Refer to the KFPA11187-E message.	-187
4275A	Refer to the KFPA11188-E message.	-188
42760	There is an error in the base table specification for the list to be created. For details, refer to the KFPA11773-E message.	-773
42762	Refer to the KFPA11776-E message.	-776
42763	Refer to the KFPA11783-E message.	-783
42770	One of the following errors is present: There is an error in the NULL, LIKE, XLIKE, BETWEEN, or Boolean predicate. For details, refer to the KFPA11114-E message. No value specification is permitted in the right-hand or left-hand operand of a comparison predicate, or in the left-hand operand of an IN predicate. For details, refer to the KFPA11417-E message.	-114 -417
42771	Refer to the KFPA11419-E message.	-419
42772	Refer to the KFPA11422-E message.	-422
42773	Refer to the KFPA11428-E message.	-428
42774	Refer to the KFPA11445-E message.	-445
42780	One of the following errors is present: A data type that is not permitted in date or time operations is specified together with an arithmetic operator, or a unary operation was performed on date data, time data, or a labeled duration. For details, refer to the KFPA11413-E message. A labeled duration other than an addition or subtraction operand is specified on date or time data. For details, refer to the KFPA11414-E message.	-413 -414
42781	Refer to the KFPA11421-E message.	-421
42782	There is an error in the operands specified in a scalar function. For details, refer to the KFPA11425-E message.	-425
42783	Refer to the KFPA11427-E message.	-427
42784	There is one of the following errors: There is an error in the format or data type of the value expression specified in the CASE expression. For details, refer to the KFPA11444-E message. A value expression must be specified in at least one of the THEN operands in simple CASE expressions and searched CASE expressions, but the null value is specified in all THEN operands. For details, refer to the KFPA11448-E message.	-444 -448
42785	There is an error in operands in the CAST specification. For details, refer to the KFPA11453-E message.	-453
42786	Refer to the KFPA11177-E message.	-177
42787	Refer to the KFPA11475-E message.	-475
42792	One of the following errors is present: FOR UPDATE OF and FOR READ ONLY clauses can be specified only in the cursor declaration. For details, refer to the KFPA11155-E message. An invalid specification was made in the query for updating or deleting using the cursor. For details, refer to the KFPA11156-E message.	-155 -156
42793	Refer to the KFPA11118-E message.	-118
42794	Refer to the KFPA11148-E message.	-148
42795	No RDAREA can be specified for the following tables: Read-only viewed tables Query name tables For details, refer to the KFPA19277-E message.	-1277
42796	The RDAREA specification contains one of the following errors: There is a syntax error. The same RDAREA name is specified more than once. The specified RDAREA does not correspond to the RDAREA that stores the table. For details, refer to the KFPA11497-E message.	-497
427A0	Refer to the KFPA11101-E message.	-101
427A1	Refer to the KFPA11196-E message.	-196
427A2	Refer to the KFPA11137-E message.	-137
427B2	Refer to the KFPA11194-E message.	-194
427B3	Refer to the KFPA11677-E message.	-677
427C1	Refer to the KFPA19290-E message.	-1290
427D0	Refer to the KFPA11169-E message.	-169
427DA	Refer to the KFPA19203-E message.	-1203
427E0	Refer to the KFPA11237-E message.	-237
427F0	Refer to the KFPA11259-E message.	-259
427FA	Refer to the KFPA11262-E message.	-262
427FB	Refer to the KFPA11263-E message.	-263
42801	One of the following errors is present: The data type of the operands specified on both sides of a predicate is invalid for comparison or conversion. For details, refer to the KFPA11401-E message. An invalid data type is specified in the LIKE or XLIKE predicate. For details, refer to the KFPA11407-E message.	-401 -407
42802	One of the following errors is present: There is an error in the search condition specified in the IF or WHILE statement. For details, refer to the KFPA11163-E message. An arithmetic operation is specified for an invalid data type. For details, refer to the KFPA11406-E message. The data type of the operands specified on both sides of a concatenation operation is invalid for comparison or conversion. For details, refer to the KFPA11411-E message. The specified data type is invalid for concatenation operations. For details, refer to the KFPA11412-E message. The specified data type is invalid. For details, refer to the KFPA11415-E message. Data types are incompatible between the first value expression in a scalar function or CASE abbreviation, and the specified expression value. For details, refer to the KFPA11426-E message. Only BOOLEAN-type data can be specified in Boolean predicates. For details, refer to the KFPA11465-E message. Character type data with a length of 4,037 bytes or greater is specified at an invalid location in the XDS. For details, refer to the KFPA11409-E message.	-163 -406 -411 -412 -415 -426 -465 -409
42803	Refer to the KFPA11408-E message.	-408
42804	Refer to the KFPA11197-E message.	-197
42806	One of the following errors is present: Data types are incompatible between the value expression in CASE and the value expression in WHEN in the simple CASE expression. For details, refer to the KFPA11446-E message. Data types are incompatible between the value expression in THEN and the value expression in THEN or ELSE in the simple CASE and searched CASE expressions. For details, refer to the KFPA11447-E message.	-446 -447
42807	There is an error in the combination of the data type and data length resulting from a value expression, and the data type and data length obtained after conversion. For details, refer to the KFPA11453-E message.	-453
42809	Refer to the KFPA11238-E message.	-238
4280B	Refer to the KFPA11236-E message.	-236
4280C	Refer to the KFPA11440-E message.	-440
4280E	Refer to the KFPA11468-E message.	-468
42810	Refer to the KFPA11134-E message.	-134
42812	The length of a long data item falls beyond the permitted value range. For details, refer to the KFPA11420-E message.	-420
42814	Refer to the KFPA11441-E message.	-441
4281A	Refer to the KFPA11132-E message.	-132
42820	Refer to the KFPA11548-E message.	-548
42830	Refer to the KFPA11230-E message.	-230
42850	One of the following errors is present: Invalid information is specified in the query specification in the WITH clause, or in the view definition. For details, refer to the KFPA11467-E message. Invalid information is specified in the view definition. For details, refer to the KFPA11651-E message.	-467 -651
42851	Refer to the KFPA11671-E message.	-671
42870	Refer to the KFPA11670-E message.	-670
42871	Refer to the KFPA11672-E message.	-672
428A0	Refer to the KFPA11456-E message.	-456
428A1	Refer to the KFPA11640-E message.	-640
428A2	Refer to the KFPA11642-E message.	-642
428D1	Refer to the KFPA19150-E message.	-1150
428D2	Refer to the KFPA19617-E message.	-1617
428D3	Refer to the KFPA19620-E message.	-1620
42907	Refer to the KFPA11146-E message.	-146
42908	Refer to the KFPA11162-E message.	-162
42909	Refer to the KFPA11174-E message.	-174
42910	Refer to the KFPA11231-E message.	-231
42911	Refer to the KFPA11232-E message.	-232
42912	Refer to the KFPA11234-E message.	-234
42913	Refer to the KFPA11240-E message.	-240
42914	Refer to the KFPA11158-E message.	-158
42915	Refer to the KFPA11282-E message.	-282
42916	Refer to the KFPA11283-E message.	-283
42917	Refer to the KFPA11284-E message.	-284
42918	Refer to the KFPA11285-E message.	-285
42919	Refer to the KFPA11286-E message.	-286
42920	Refer to the KFPA11287-E message.	-287
42921	Refer to the KFPA11288-E message.	-288
42922	Refer to the KFPA11291-E message.	-291
42924	Refer to the KFPA11294-E message.	-294
42925	Refer to the KFPA11295-E message.	-295
42927	Refer to the KFPA11382-E message.	-382
42928	Refer to the KFPA11442-E message.	-442
42929	Refer to the KFPA11460-E message.	-460
42930	Refer to the KFPA11565-E message.	-565
42931	Refer to the KFPA11600-E message.	-600
42932	Refer to the KFPA11724-E message.	-724
42933	Refer to the KFPA11780-E message.	-780
42934	Refer to the KFPA11824-E message.	-824
42937	Refer to the KFPA19330-E message.	-1330
42938	Refer to the KFPA19458-E message.	-1458
42939	Refer to the KFPA19633-E message.	-1633
42941	Refer to the KFPA11126-E message.	-126
42942	Refer to the KFPA11133-E message.	-133
42943	Refer to the KFPA11154-E message.	-154
42946	Refer to the KFPA11168-E message.	-168
42947	Refer to the KFPA11171-E message.	-171
42948	Refer to the KFPA11172-E message.	-172
42949	Refer to the KFPA11176-E message.	-176
42950	Refer to the KFPA11179-E message.	-179
42951	Refer to the KFPA11198-E message.	-198
42952	Refer to the KFPA11228-E message.	-228
42953	Refer to the KFPA11235-E message.	-235
42954	Refer to the KFPA11243-E message.	-243
42955	Refer to the KFPA11249-E message.	-249
42956	Refer to the KFPA11254-E message.	-254
42958	Refer to the KFPA11266-E message.	-266
42959	Refer to the KFPA11267-E message.	-267
42960	Refer to the KFPA11273-E message.	-273
42961	Refer to the KFPA11274-E message.	-274
42962	Refer to the KFPA11276-E message.	-276
42963	Refer to the KFPA11277-E message.	-277
42964	Refer to the KFPA11296-E message.	-296
42965	Refer to the KFPA11299-E message.	-299
42966	Refer to the KFPA11314-E message.	-314
42967	Refer to the KFPA11351-E message.	-351
42968	Refer to the KFPA11443-E message.	-443
42970	Refer to the KFPA11462-E message.	-462
42971	Refer to the KFPA11463-E message.	-463
42972	Refer to the KFPA11470-E message.	-470
42973	Refer to the KFPA11471-E message.	-471
42974	Refer to the KFPA11472-E message.	-472
42975	Refer to the KFPA11473-E message.	-473
42976	Refer to the KFPA11474-E message.	-474
42978	Refer to the KFPA11477-E message.	-477
42979	Refer to the KFPA11479-E message.	-479
42980	Refer to the KFPA11504-E message.	-504
42981	Refer to the KFPA11583-E message.	-583
42983	Refer to the KFPA11746-E message.	-746
42984	Refer to the KFPA11750-E message.	-750
42985	Refer to the KFPA11753-E message.	-753
42986	Refer to the KFPA11774-E message.	-774
42987	Refer to the KFPA11807-E message.	-807
42988	Refer to the KFPA11829-E message.	-829
42989	Refer to the KFPA11839-E message.	-839
429A2	Refer to the KFPA19101-E message.	-1101
429A5	Refer to the KFPA19110-E message.	-1110
429A6	Refer to the KFPA19111-E message.	-1111
429A7	Refer to the KFPA19130-E message.	-1130
429A8	Refer to the KFPA19170-E message.	-1170
429A9	Refer to the KFPA19180-E message.	-1180
429B0	Refer to the KFPA19181-E message.	-1181
429B1	Refer to the KFPA19182-E message.	-1182
429B2	Refer to the KFPA19184-E message.	-1184
429B3	Refer to the KFPA19185-E message.	-1185
429B4	Refer to the KFPA19187-E message.	-1187
429B5	Refer to the KFPA19188-E message.	-1188
429B6	Refer to the KFPA19189-E message.	-1189
429B9	Refer to the KFPA19212-E message.	-1212
429C0	Refer to the KFPA19220-E message.	-1220
429C1	Refer to the KFPA19221-E message.	-1221
429C2	Refer to the KFPA19254-E message.	-1254
429C3	Refer to the KFPA19270-E message.	-1270
429C4	Refer to the KFPA19271-E message.	-1271
429C5	Refer to the KFPA19272-E message.	-1272
429C6	Refer to the KFPA19273-E message.	-1273
429C7	Refer to the KFPA19274-E message.	-1274
429C8	Refer to the KFPA19275-E message.	-1275
429C9	Refer to the KFPA19291-E message.	-1291
429D0	Refer to the KFPA19292-E message.	-1292
429D1	Refer to the KFPA19295-E message.	-1295
429D2	Refer to the KFPA19319-E message.	-1319
429D3	Refer to the KFPA19321-E message.	-1321
429D4	Refer to the KFPA19322-E message.	-1322
429D5	Refer to the KFPA19324-E message.	-1324
429D6	Refer to the KFPA19327-E message.	-1327
429D7	Refer to the KFPA19328-E message.	-1328
429D8	Refer to the KFPA19329-E message.	-1329
429D9	Refer to the KFPA19405-E message.	-1405
429E0	Refer to the KFPA19409-E message.	-1409
429E2	Refer to the KFPA19452-E message.	-1452
429E3	Refer to the KFPA19453-E message.	-1453
429E4	Refer to the KFPA19454-E message.	-1454
429E5	Refer to the KFPA19577-E message.	-1577
429E6	The number of columns in INTO clauses specified in the SQL statement exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
429E7	The number of java.sql.ResultSet[] in EXTERNAL NAME clauses specified in the SQL statement exceeds the permitted maximum value. For details, refer to the KFPA11129-E message.	-129
429E8	Refer to the KFPA11188-E message.	-188
429E9	Refer to the KFPA11553-E message.	-553
429F0	Refer to the KFPA11836-E message.	-836
429F1	Refer to the KFPA19105-E message.	-1105
429F2	Refer to the KFPA19140-E message.	-1140
429F3	Refer to the KFPA19171-E message.	-1171
429F4	Refer to the KFPA19186-E message.	-1186
429F5	Refer to the KFPA19406-E message.	-1406
429F6	Refer to the KFPA19603-E message.	-1603
429F8	Refer to the KFPA19318-E message.	-1318
429F9	Defined information cannot be changed for the columns of the base table specified in the concatenation operation or scalar function in the view definition. For details, refer to the KFPA11716-E message.	-716
429FA	A function execution does not end with the RETURN statement. For details, refer to the KFPA11986-E message.	-986
42E28	Refer to the KFPA11455-E message.	-455
42E29	Refer to the KFPA19459-E message.	-1459
42I02	Refer to the KFPA11207-E message.	-207
42I03	Refer to the KFPA11432-E message.	-432
42I08	One of the following errors is present: PUBLIC, MASTER, HiRDB, or ALL was specified as the authorization identifier or group ID. For details, refer to the KFPA11549-E message. ALL was specified for the table identifier. For details, refer to the KFPA11658-E message.	-549 -658
42I0A	Refer to the KFPA11766-E message.	-766
42I12	Refer to the KFPA11574-E message.	-574
42I13	Refer to the KFPA11601-E message.	-601
42I14	Refer to the KFPA11609-E message.	-609
42I15	Refer to the KFPA11612-E message.	-612
42I16	Refer to the KFPA11614-E message.	-614
42I17	Refer to the KFPA11615-E message.	-615
42I18	Refer to the KFPA11619-E message.	-619
42I19	Refer to the KFPA11621-E message.	-621
42I20	Refer to the KFPA11625-E message.	-625
42I23	Refer to the KFPA11628-E message.	-628
42I24	Refer to the KFPA11631-E message.	-631
42I25	Refer to the KFPA11632-E message.	-632
42I26	Refer to the KFPA11656-E message.	-656
42I27	Refer to the KFPA11659-E message.	-659
42I29	Refer to the KFPA11661-E message.	-661
42I30	Refer to the KFPA11664-E message.	-664
42I31	One of the following errors is present: The information specified in the CHANGE clause in ALTER TABLE is the same information as before the change. For details, refer to the KFPA11665-E message. WITH DEFAULT has already been specified for the column. For details, refer to the KFPA11699-E message.	-665 -699
42I32	Refer to the KFPA11667-E message.	-667
42I37	Tables cannot be defined with only reserved columns. For details, refer to the KFPA11685-E message.	-685
42I41	Refer to the KFPA11690-E message.	-690
42I42	Refer to the KFPA11693-E message.	-693
42I43	Refer to the KFPA11694-E message.	-694
42I46	Refer to the KFPA11697-E message.	-697
42I47	Refer to the KFPA11698-E message.	-698
42I54	Refer to the KFPA11743-E message.	-743
42I55	Refer to the KFPA11744-E message.	-744
42I56	Refer to the KFPA11745-E message.	-745
42I58	Refer to the KFPA11747-E message.	-747
42I60	Refer to the KFPA11758-E message.	-758
42I65	Refer to the KFPA11764-E message.	-764
42I68	Refer to the KFPA11791-E message.	-791
42I70	Refer to the KFPA11793-E message.	-793
42I77	Refer to the KFPA19602-E message.	-1602
42I79	Refer to the KFPA11741-E message.	-741
42I80	Refer to the KFPA11775-E message.	-775
42I82	Refer to the KFPA11712-E message.	-712
42I86	Refer to the KFPA19612-E message.	-1612
42I88	Refer to the KFPA11591-E message.	-591
42I89	Refer to the KFPA11592-E message.	-592
42I90	Refer to the KFPA11165-E message.	-165
42I93	Refer to the KFPA11478-E message.	-478
42I9A	Refer to the KFPA19615-E message.	-1615
42I9B	Refer to the KFPA19616-E message.	-1616
42IA0	A sequence generator cannot be created. For details, refer to the KFPA19624-E message.	-1624
42J02	Refer to the KFPA11584-E message.	-584
42J03	Refer to the KFPA11605-E message.	-605
42J04	Refer to the KFPA11606-E message.	-606
42J05	Refer to the KFPA11611-E message.	-611
42J06	Refer to the KFPA11620-E message.	-620
42J07	Refer to the KFPA11622-E message.	-622
42J08	Refer to the KFPA11624-E message.	-624
42J10	Refer to the KFPA11702-E message.	-702
42J11	Refer to the KFPA11704-E message.	-704
42J12	Refer to the KFPA11710-E message.	-710
42J13	Refer to the KFPA11717-E message.	-717
42J14	Refer to the KFPA11718-E message.	-718
42J15	Refer to the KFPA11721-E message.	-721
42J16	Refer to the KFPA19331-E message.	-1331
42J17	Refer to the KFPA19575-E message.	-1575
42J18	Refer to the KFPA19625-E message.	-1625
42J21	Refer to the KFPA11200-E message.	-200
42J22	Refer to the KFPA11369-E message.	-369
42J23	Refer to the KFPA11597-E message.	-597
42J24	Refer to the KFPA11754-E message.	-754
42J29	Refer to the KFPA11908-E message.	-908
42J30	Refer to the KFPA11909-E message.	-909
42J31	Refer to the KFPA11939-E message.	-939
42J33	Refer to the KFPA19200-E message.	-1200
42J34	Refer to the KFPA19581-E message.	-1581
42J35	Refer to the KFPA19681-E message.	-1681
42JA1	The ? parameter cannot be specified in an SQL statement for a trigger. For details, refer to the KFPA19450-E message.	-1450
42JA2	A trigger cannot be defined for other schemas. For details, refer to the KFPA19450-E message.	-1450
42JA4	Trigger can be defined only for a base table. For details, refer to the KFPA19450-E message.	-1450
42JA5	The table for which a trigger is to be defined does not exist. For details, refer to the KFPA19450-E message.	-1450
42JA6	OLD ROW or NEW ROW can be specified only once in the old or new values alias list, respectively. For details, refer to the KFPA19450-E message.	-1450
42JA7	If INSERT is specified as the trigger execution timing, OLD ROW cannot be specified. For details, refer to the KFPA19450-E message.	-1450
42JA8	If DELETE is specified as the trigger execution timing, NEW ROW cannot be specified. For details, refer to the KFPA19450-E message.	-1450
42JA9	The same name cannot be specified in OLD ROW and NEW ROW. For details, refer to the KFPA19450-E message.	-1450
42JAA	If FOR EACH STATEMENT is specified, NEW ROW and OLD ROW cannot be specified. For details, refer to the KFPA19450-E message.	-1450
42JAB	More than 30,000 columns are specified in the trigger execution timing. For details, refer to the KFPA19450-E message.	-1450
42JAC	The column name specified in the trigger execution timing is duplicated. For details, refer to the KFPA19450-E message.	-1450
42JAD	The column specified in the trigger execution timing was not found in the table for which a trigger is to be defined. For details, refer to the KFPA19450-E message.	-1450
42JAE	In the trigger definition in which BEFORE is specified as the trigger action time, an update SQL statement cannot be specified as the triggered SQL statement. For details, refer to the KFPA19450-E message.	-1450
42JAF	Repetition columns and abstract data type columns cannot be referenced by the old or new values correlation name. For details, refer to the KFPA19450-E message.	-1450
42JAH	A table for which a trigger is defined cannot be specified in the triggered SQL statement. For details, refer to the KFPA19450-E message.	-1450
42JAJ	A reserved column cannot be specified as a trigger event column. For details, refer to the KFPA19450-E message.	-1450
42JAL	The user cannot define another user's table. For details, refer to the KFPA19450-E message.	-1450
42JAM	ROW cannot be specified for the old or new values correlation name. For details, refer to the KFPA19450-E message.	-1450
42JAN	If a CURRENT_TIMESTAMP column with USING BES as its default value is specified as the target of an assignment statement, DEFAULT cannot be assigned as a value. For details, refer to the KFPA19450-E message.	-1450
42JAO	In the trigger definition in which BEFORE is specified as the trigger action time, only the default constructor can be specified as the function call in the triggered SQL statement. For details, refer to the KFPA19450-E message.	-1450
42JAP	Neither a Java function nor a Java procedure can be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message.	-1450
42JAQ	ROLLBACK cannot be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message.	-1450
42JAR	COMMIT cannot be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message.	-1450
42JAS	PURGE cannot be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message.	-1450
42JAT	GET_JAVA_STORED_ROUTINE_SOURCE cannot be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message.	-1450
42JD1	Refer to the KFPA19293-E message.	-1293
42K01	Refer to the KFPA11550-E message.	-550
42K02	Refer to the KFPA11551-E message.	-551
42K03	Refer to the KFPA11552-E message.	-552
42K04	Refer to the KFPA11554-E message.	-554
42K05	Refer to the KFPA11555-E message.	-555
42K06	Refer to the KFPA11556-E message.	-556
42K14	Refer to the KFPA11607-E message.	-607
42K20	Refer to the KFPA11663-E message.	-663
42K21	Refer to the KFPA11680-E message.	-680
42K22	Refer to the KFPA11823-E message.	-823
42K25	Refer to the KFPA11514-E message.	-514
42K26	Refer to the KFPA11547-E message.	-547
42K27	Refer to the KFPA19219-E message.	-1219
42K28	Refer to the KFPA11573-E message.	-573
42K29	Refer to the KFPA11590-E message.	-590
42K30	Refer to the KFPA11902-E message.	-902
42K32	Refer to the KFPA11904-E message.	-904
42K33	Refer to the KFPA11905-E message.	-905
42K34	Refer to the KFPA11906-E message.	-906
42K35	Refer to the KFPA11907-E message.	-907
42K36	Refer to the KFPA19518-E message.	-1518
42K37	Refer to the KFPA19631-E message.	-1631
42K38	Refer to the KFPA19634-E message.	-1634
42K39	Refer to the KFPA19635-E message.	-1635
42K40	Refer to the KFPA19680-E message.	-1680
42K41	Refer to the KFPA19296-E message.	-1296
42K42	Refer to the KFPA11925-E message.	-925

Table 8-25 SQLSTATE class 45

SQLSTATE	Explanation	SQLCODE
45501	Refer to the KFPA19404-E message.	-1404

Table 8-26 SQLSTATE class 51

SQLSTATE	Explanation	SQLCODE
51001	Refer to the KFPA11307-E message.	-307
51003	Refer to the KFPA11769-E message.	-769
51004	Refer to the KFPA11838-E message.	-838
51006	Refer to the KFPA11804-E message.	-804
5100F	Refer to the KFPA11997-E message.	-997
5100H	Refer to the KFPA11359-E message.	-359

Table 8-27 SQLSTATE class 52

SQLSTATE	Explanation	SQLCODE
52002	Refer to the KFPA11787-E message.	-787
52003	Refer to the KFPA11558-E message.	-558
52004	Refer to the KFPA11727-E message.	-727
52005	Refer to the KFPA11734-E message.	-734
52006	Refer to the KFPA19456-E message.	-1456
52007	Refer to the KFPA19503-E message.	-1503
52008	Refer to the KFPA11948-E message.	-948
52009	Refer to the KFPA11569-E message.	-569
5200B	Refer to the KFPA11937-E message.	-937
52010	Refer to the KFPA11494-E message.	-494
52011	An error occurred during transaction control processing. For details, refer to the KFPA19703-E message.	-1703
52014	Refer to the KFPA11990-E message.	-990
52206	Refer to the KFPA19802-E message.	-1802
52208	Refer to the KFPA19102-E message.	-1102
52209	Refer to the KFPA19518-E message.	-1518
52301	Refer to the KFPA11395-E message.	-395
52302	Refer to the KFPA11722-E message.	-722
52303	Refer to the KFPA11723-E message.	-723

Table 8-28 SQLSTATE class 53

SQLSTATE	Explanation	SQLCODE
53001	Refer to the KFPA11356-E message.	-356
53002	Refer to the KFPA11546-E message.	-546
53004	Refer to the KFPA11900-E message.	-900
53005	Refer to the KFPA19587-E message.	-1587
53006	Refer to the KFPA19800-E message.	-1800
53021	Refer to the KFPA11613-E message.	-613
53201	Refer to the KFPA11930-E message.	-930
53202	Refer to the KFPA11729-E message.	-729
53203	Refer to the KFPA11914-E message.	-914
53204	Refer to the KFPA11929-E message.	-929
53208	Refer to the KFPA11395-E message.	-395
53209	The SQL statement cannot be executed because the resource indicated by its resource ID is in use exclusively by another transaction. For details, refer to the KFPA11770-I message.	-770
53210	There is not enough work area for locking. For details, refer to the KFPA11912-E message.	-912
53212	An attempt to expand the thread stack area failed. For details, refer to the KFPA11945-E message.	-945
53301	Refer to the KFPA11596-E message.	-596
53302	Refer to the KFPA19576-E message.	-1576
53305	Refer to the KFPA19705-E message.	-1705
53401	Refer to the KFPA11342-E message.	-342
53402	Refer to the KFPA11531-E message.	-531
53601	Refer to the KFPA19719-E message.	-1719
53602	Refer to the KFPA19724-E message.	-1724
53603	Refer to the KFPA19725-E message.	-1725

Table 8-29 SQLSTATE class 54

SQLSTATE	Explanation	SQLCODE
54001	Refer to the KFPA11159-E message.	-159
54002	Refer to the KFPA11315-E message.	-315
54003	Refer to the KFPA11935-E message.	-935
54005	Refer to the KFPA19411-E message.	-1411
54006	Refer to the KFPA19502-E message.	-1502
54007	Refer to the KFPA19510-E message.	-1510
54008	Refer to the KFPA19511-E message.	-1511
54009	Refer to the KFPA19512-E message.	-1512
54201	Refer to the KFPA11563-E message.	-563
54202	Refer to the KFPA11725-E message.	-725

Table 8-30 SQLSTATE class 55

SQLSTATE	Explanation	SQLCODE
55001	An error occurred on the Java Virtual Machine. For details, refer to the KFPA11491-E message.	-491

Table 8-31 SQLSTATE class 56

SQLSTATE	Explanation	SQLCODE
56001	Refer to the KFPA11312-E message.	-312
56007	Refer to the KFPA11616-E message.	-616
56008	Refer to the KFPA11654-E message.	-654
56009	Refer to the KFPA11657-E message.	-657
5600B	Refer to the KFPA11706-E message.	-706
5600C	Refer to the KFPA11748-E message.	-748
5600E	The length of the SQL statement to be dynamically preprocessed is invalid. For details, refer to the KFPA11821-E message.	-821
5600F	The length of the SQL statement specified in the view definition exceeds the permitted maximum value. For details, refer to the KFPA11821-E message.	-821
5600G	The length of the SQL statement specified in the check constraint definition exceeds the permitted maximum value. For details, refer to the KFPA11821-E message.	-821
5600H	The length of the SQL statement specified in the procedure definition exceeds the permitted maximum value. For details, refer to the KFPA11821-E message.	-821
5600I	Refer to the KFPA19450-E message.	-1450
56010	Refer to the KFPA11662-E message.	-662
56011	Refer to the KFPA11167-E message.	-167
56012	Refer to the KFPA11250-E message.	-250
56013	Refer to the KFPA11343-E message.	-343
56014	Refer to the KFPA11634-E message.	-634
56015	Refer to the KFPA11636-E message.	-636
56016	Refer to the KFPA11637-E message.	-637
56017	Refer to the KFPA11703-E message.	-703
56018	Refer to the KFPA11714-E message.	-714
56019	Refer to the KFPA11795-E message.	-795
56020	Refer to the KFPA11805-E message.	-805
56022	Refer to the KFPA11952-E message.	-952
56026	Refer to the KFPA19513-E message.	-1513
56027	Refer to the KFPA19583-E message.	-1583
56028	Refer to the KFPA19584-E message.	-1584
56030	The result of serialization (conversion to character string) of an XML-type value is too long. For details, refer to the KFPA19313-E message.	-1313
56031	The size of an SQL object exceeds 32 MB. For details, refer to the KFPA11992-E message.	-992
56032	The SQL statement cannot be executed for one of the following reasons The row length is greater than the page length. The key length of the index exceeds the maximum value. The number of columns exceeds the maximum value. For details, refer to the KFPA11813-E message.	-813

Table 8-32 SQLSTATE class 57

SQLSTATE	Explanation	SQLCODE
57008	Refer to the KFPA11528-E message.	-528
57009	Refer to the KFPA11529-E message.	-529

Table 8-33 SQLSTATE class 58

SQLSTATE	Explanation	SQLCODE
58004	Refer to the KFPA11610-E message.	-610
58005	Refer to the KFPA11652-E message.	-652
58006	Refer to the KFPA11653-E message.	-653
58008	Refer to the KFPA11608-E message.	-608
58009	Refer to the KFPA19704-E message.	-1704
58011	Refer to the KFPA11513-E message.	-513
58012	Refer to the KFPA11599-E message.	-599
58013	Refer to the KFPA11707-E message.	-707
58014	Refer to the KFPA11708-E message.	-708
58015	Refer to the KFPA11709-E message.	-709
58018	Refer to the KFPA11771-E message.	-771
58019	Refer to the KFPA11796-E message.	-796
58021	Refer to the KFPA11844-E message.	-844
58022	Refer to the KFPA11845-E message.	-845
58023	Refer to the KFPA11848-E message.	-848

Table 8-34 SQLSTATE class 59

SQLSTATE	Explanation	SQLCODE
59001	Refer to the KFPA11280-E message.	-280
59002	Refer to the KFPA11281-E message.	-281
59003	Refer to the KFPA11761-E message.	-761
59004	Refer to the KFPA11890-E message.	-890
59005	Refer to the KFPA11895-E message.	-895
59006	Refer to the KFPA11896-E message.	-896

Table 8-35 SQLSTATE class 5A

SQLSTATE	Explanation	SQLCODE
5A001	Refer to the KFPA11329-E message.	-329
5A003	Refer to the KFPA11785-E message.	-785

Table 8-36 SQLSTATE class 5B

SQLSTATE	Explanation	SQLCODE
5B001	Refer to the KFPA11735-E message.	-735
5B002	The SIGNAL or RESIGNAL statement resulted in an error. For details, refer to the KFPA19400-E message.	-1400

Table 8-37 SQLSTATE class 5C

SQLSTATE	Explanation	SQLCODE
5C006	Refer to the KFPA11431-E message.	-431
5C007	Refer to the KFPA11476-E message.	-476
5C008	Refer to the KFPA11484-E message.	-484
5C009	Refer to the KFPA11485-E message.	-485
5C010	Refer to the KFPA11553-E message.	-553
5C011	Refer to the KFPA11720-E message.	-720
5C012	Refer to the KFPA11728-E message.	-728
5C013	Refer to the KFPA11731-E message.	-731
5C014	Refer to the KFPA11732-E message.	-732
5C015	Refer to the KFPA11733-E message.	-733
5C016	Refer to the KFPA11736-E message.	-736
5C021	Refer to the KFPA11941-E message.	-941
5C024	Refer to the KFPA11984-E message.	-984
5C025	Refer to the KFPA11987-E message.	-987
5C026	Refer to the KFPA19332-E message.	-1332
5C027	Refer to the KFPA19333-E message.	-1333
5C030	Refer to the KFPA19700-E message.	-1700
5C031	Refer to the KFPA19517-E message.	-1517
5C032	Refer to the KFPA19520-E message.	-1520

Table 8-38 SQLSTATE class 5E

SQLSTATE	Explanation	SQLCODE
5E101	Refer to the KFPA19222-E message.	-1222

Table 8-39 SQLSTATE class IZ

SQLSTATE	Explanation	SQLCODE
IZ003	An attempt was made to execute index batch creation for an index that had already been created. For details, refer to the KFPA11875-E message.	-875

Table 8-40 SQLSTATE class R2

SQLSTATE	Explanation	SQLCODE
R2000	During a list search, a row that existed at the time of list creation was not returned. For details, refer to the KFPA12110-I message.	110