8.1.1 When the PDSTANDARDSQLSTATE client environment variable is set to YES or the pd_standard_sqlstate system common definition is set to Y

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

ClassExplanationReference
00Terminated normally.Table 8-2
01A warning was issued.Table 8-3
02There is no data.Table 8-4
07An error occurred on a dynamic SQL statement.Table 8-5
08A connection violation occurred.Table 8-6
0AThe facility is not supported.Table 8-7
0FA locator exception occurred.Table 8-8
0KRESIGNAL was executed while the handler was disabled.Table 8-9
21A base violation occurred.Table 8-10
22A data exception occurred.Table 8-11
23An integrity constraint violation occurred.Table 8-12
24The cursor status is invalid.Table 8-13
25The transaction status is invalid.Table 8-14
26The SQL statement name is invalid.Table 8-15
28The specified authorization identifier is invalid.Table 8-16
2CThe character set name is invalid.Table 8-17
2FAn SQL routine exception occurred.Table 8-18
33The SQL descriptor name is invalid.Table 8-19
34The cursor name is invalid.Table 8-20
37A syntax error or access rule violation was detected in a dynamic SQL statement.Table 8-21
38An external routine exception occurred.Table 8-22
40The transaction rolled back.Table 8-23
42A syntax error or access rule violation was detected.Table 8-24
45An unprocessed user definition exception occurred.Table 8-25
51An error related to a specific SQL facility occurred (error caused by a nonstandard specific SQL facility).Table 8-26
52The 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
53The 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
54The application program status is invalid (error caused by application program settings, details of processing, attributes, status, etc.).Table 8-29
55An error occurred on the remote system (such as an OS error or a communication error).Table 8-30
56The maximum or limit value was reached (error based on the maximum or minimum value permitted by the processors or system).Table 8-31
57The status of an SQL execution procedure object is invalid (error related to an SQL object, routine object, or SQL pool object).Table 8-32
58The RDAREA specification or RDAREA status is invalid (error caused by the specification, status, and type of RDAREA).Table 8-33
59The abstract data type or plug-in status is invalid (error caused by the abstract data type or plug-in registration status).Table 8-34
5AThe list name or list status is invalid.Table 8-35
5BProcessing was canceled by a user request (such as an interrupt).Table 8-36
5CA system error other than those described above or below occurred.Table 8-37
5EThe view object status is invalid.Table 8-38
IZAn error specific to a utility or non-SQLAPI occurred.Table 8-39
R2There is no data.Table 8-40

Table 8-2 SQLSTATE class 00

SQLSTATEExplanationSQLCODE
00000Terminated normally.0

Table 8-3 SQLSTATE class 01

SQLSTATEExplanationSQLCODE
01000Terminated normally with a warning.0
0100CA dynamic results set was returned.+120
0100DAnother result set was returned.+121
0100EAn attempt was made to return too many result sets.+120
01R00Terminated normally with a warning.Positive number other than 100 or 110

Table 8-4 SQLSTATE class 02

SQLSTATEExplanationSQLCODE
02000There is no data.100
02001There is no other result set to be returned.100

Table 8-5 SQLSTATE class 07

SQLSTATEExplanationSQLCODE
07001One 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
07002The 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
07003Refer to the KFPA11506-E message.-506
07005Refer to the KFPA11507-E message.-507
07006One 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
07008Refer to the KFPA11310-E message.-310
07501Refer to the KFPA11308-E message.-308
07502Refer to the KFPA11340-E message.-340
07503Refer to the KFPA11901-E message.-901

Table 8-6 SQLSTATE class 08

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

Table 8-7 SQLSTATE class 0A

SQLSTATEExplanationSQLCODE
0A503Refer to the KFPA11948-E message.-948
0A504Refer to the KFPA11950-E message.-950
0A505Refer to the KFPA11988-E message.-988
0A507Refer to the KFPA11899 message.-899

Table 8-8 SQLSTATE class 0F

SQLSTATEExplanationSQLCODE
0F001Refer to the KFPA11364-E message.-364

Table 8-9 SQLSTATE class 0K

SQLSTATEExplanationSQLCODE
0K000Refer to the KFPA19403-E message.-1403

Table 8-10 SQLSTATE class 21

SQLSTATEExplanationSQLCODE
21501Refer to the KFPA11449-E message.-449
21502Refer to the KFPA11450-E message.-450

Table 8-11 SQLSTATE class 22

SQLSTATEExplanationSQLCODE
22001One 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
22002A 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
22003One 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
22004One 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
22007The operation resulted in an overflow because the specified date representation is invalid. For details, refer to the KFPA11801-E message.-801
22008One 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
2200ARefer to the KFPA11938-E message.-938
22011In the SUBSTR scalar function, the end location falls before the start location.
For details, refer to the KFPA11427-E message.
-427
22012A division by zero error occurred during an arithmetic operation.
For details, refer to the KFPA11800-E and KFPA19326-E messages.
-800
-1326
22014Refer to the KFPA11367-E message.-367
22015The value of the time interval field falls beyond the permitted range.
For details, refer to the KFPA11326-E message.
-326
22018The 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
22019The 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
22025An 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
22027The length of the TRIM character is not one character.
For details, refer to the KFPA11425-E message.
-425
2202FThe 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
22501The 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
22503Refer to the KFPA11306-E message.-306
22504Refer to the KFPA11310-E message.-310
22505Data 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
22506Data 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
22507Data 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
22508Refer to the KFPA11170-E message.-170
22509Refer to the KFPA11223-E message.-223
2250GOne 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
2250JRefer to the KFPA11316-E message.-316
22510Refer to the KFPA11381-E message.-381
22511Refer to the KFPA11430-E message.-430
22512Refer to the KFPA11993-E message.-993
22513Refer to the KFPA19183-E message.-1183
22514Refer to the KFPA19320-E message.-1320
22515Refer to the KFPA19325-E message.-1325
22516Refer to the KFPA19801-E message.-1801
22520A 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
22521Refer to the KFPA19346-E message.-1346
22522Refer to the KFPA19347-E message.-1347
22523Refer to the KFPA19348-E message.-1348
22524Refer to the KFPA19349-E message.-1349
22525Refer to the KFPA19350-E message.-1350
22526Refer to the KFPA19351-E message.-1351
22527Refer to the KFPA19352-E message.-1352
22528Refer to the KFPA19353-E message.-1353
22529Refer to the KFPA19354-E message.-1354

Table 8-12 SQLSTATE class 23

SQLSTATEExplanationSQLCODE
23001A RESTRICT violation occurred.
For details, refer to the KFPA11451-E message.
-451
23502A NOT NULL constraint violation occurred.
For details, refer to the KFPA11210-E message.
-210
23503A violation of a referential constraint occurred.
Refer to the KFPA11451-E message.
-451
23505One 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
23506Refer to the KFPA19582-E message.-1582
23507Refer to the KFPA19717-E message.-1717
23514A violation of a check constraint occurred.
For details, refer to the KFPA11451-E message.
-451

Table 8-13 SQLSTATE class 24

SQLSTATEExplanationSQLCODE
24000This 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
24501Refer to the KFPA11500-E message.-500
24502Refer to the KFPA11711-E message.-711
24504Refer to the KFPA11501-E message.-501
24505Refer to the KFPA11502-E message.-502
24506Refer to the KFPA11505-E message.-505
24507Refer to the KFPA11994-E message.-994
24509Refer to the KFPA19508-E message.-1508
24510Refer to the KFPA19509-E message.-1509

Table 8-14 SQLSTATE class 25

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

Table 8-15 SQLSTATE class 26

SQLSTATEExplanationSQLCODE
26000Refer to the KFPA11512-E message.-512

Table 8-16 SQLSTATE class 28

SQLSTATEExplanationSQLCODE
28501Refer to the KFPA11560-E message.-560
28502Refer to the KFPA11561-E message.-561

Table 8-17 SQLSTATE class 2C

SQLSTATEExplanationSQLCODE
2C000Refer to the KFPA19104-E message.-1104

Table 8-18 SQLSTATE class 2F

SQLSTATEExplanationSQLCODE
2F002Refer to the KFPA11495-E message.-495

Table 8-19 SQLSTATE class 33

SQLSTATEExplanationSQLCODE
33501Refer to the KFPA19506-E message.-1506
33502Refer to the KFPA19507-E message.-1507

Table 8-20 SQLSTATE class 34

SQLSTATEExplanationSQLCODE
34501Refer to the KFPA11233-E message.-233

Table 8-21 SQLSTATE class 37

SQLSTATEExplanationSQLCODE
37901Refer to the KFPA11331-E message.-331

Table 8-22 SQLSTATE class 38

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

Table 8-23 SQLSTATE class 40

SQLSTATEExplanationSQLCODE
40000Refer to the KFPA11716-E message.-716
40001Serialization 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
40501Refer to the KFPA11713-E message.-713
40503Refer to the KFPA11756-E message.-756
40505Refer to the KFPA11806-E message.-806
40506Refer to the KFPA11809-I message.-809
40507Refer to the KFPA11822-E message.-822
40508Refer to the KFPA11879-E message.-879
40509Refer to the KFPA11487-E message.-487
4050FRefer to the KFPA11912-E message.-912
4050GRefer to the KFPA11913-E message.-913
4050NRefer to the KFPA11931-E message.-931
4050IRefer to the KFPA11925-E message.-925
4050KRefer to the KFPA11927-E message.-927
4050LRefer to the KFPA19940-E message.-1940
4050MRefer to the KFPA19941-E message.-1941
40510Refer to the KFPA11488-E message.-488
40511Refer to the KFPA11489-E message.-489
40512Refer to the KFPA11490-E message.-490
40513Refer to the KFPA11494-E message.-494
40514Refer to the KFPA11530-E message.-530
40515Refer to the KFPA11595-E message.-595
40516Refer to the KFPA11740-E message.-740
40517Refer to the KFPA11797-E message.-797
40518Refer to the KFPA11808-E message.-808
40519Refer to the KFPA11828-E message.-828
40520Refer to the KFPA11876-E message.-876
40521Refer to the KFPA11877-E message.-877
40522Refer to the KFPA11878-E message.-878
40523Refer to the KFPA11886-E message.-886
40525Refer to the KFPA11892-E message.-892
40526Refer to the KFPA11945-E message.-945
40527Refer to the KFPA11958-E message.-958
40528Refer to the KFPA11959-E message.-959
40529Refer to the KFPA11981-E message.-981
40530Refer to the KFPA11986-E message.-986
40531Refer to the KFPA11989-E message.-989
40532Refer to the KFPA11992-E message.-992
40533Refer to the KFPA19311-E message.-1311
40534Refer to the KFPA19313-E message.-1313
40535Refer to the KFPA19400-E message.-1400
40537Refer to the KFPA19455-E message-1455
40538Refer to the KFPA19703-E message.-1703
40539Refer to the KFPA19716-E message.-1716
40540Refer to the KFPA19633-E message.-1633
40541Refer to the KFPA11898-E message.-898
40542The 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
40543Refer to the KFPA19713-E message.-1713
40544Refer to the KFPA19721-E message.-1721
40601Refer to the KFPA11917-E message.-917
40602Refer to the KFPA11918-E message.-918
40603Refer to the KFPA11891-E message.-891
40620Refer to the KFPA11920-E message.-920
40621Refer to the KFPA11928-I message.-928
40622Refer to the KFPA19701-E message.-1701
40623Refer to the KFPA19702-E message.-1702
40701Refer to the KFPA11934-E message.-934
40702Refer to the KFPA11953-E message.-953
40703Refer to the KFPA11342-E message.-342
40A01The transaction rolled back due to an integrity error in the dictionary.
For details, refer to the message corresponding to the SQLCODE.
--
40A02The transaction rolled back due to a basic unit error in SQL.
For details, refer to the message corresponding to the SQLCODE.
--
40B01The transaction rolled back due to a list processing error.
For details, refer to the message corresponding to the SQLCODE.
--
40B02The transaction rolled back due to an index processing error.
For details, refer to the message corresponding to the SQLCODE.
--
40B03The transaction rolled back due to an inner replica error.
For details, refer to the message corresponding to the SQLCODE.
--
40B04The transaction rolled back due to a cursor processing error.
For details, refer to the message corresponding to the SQLCODE.
--
40B05The transaction rolled back due to a transaction error.
For details, refer to the message corresponding to the SQLCODE.
--
40B08The transaction rolled back due to a resource release failure.
For details, refer to the message corresponding to the SQLCODE.
--
40B09The transaction rolled back due to a routine processing error.
For details, refer to the message corresponding to the SQLCODE.
--
40B10The transaction rolled back due to a privilege manipulation error.
For details, refer to the message corresponding to the SQLCODE.
--
40B11The transaction rolled back due to an update processing error.
For details, refer to the message corresponding to the SQLCODE.
--
40B12The transaction rolled back due to a constraint processing error.
For details, refer to the message corresponding to SQLCODE.
--
40B13The transaction rolled back due to a preprocessing error.
For details, refer to the message corresponding to the SQLCODE.
--
40B14The transaction rolled back due to an intermediate result acquisition failure.
For details, refer to the message corresponding to the SQLCODE.
--
40B15The transaction rolled back due to an abstract data type error.
For details, refer to the message corresponding to the SQLCODE.
--
40B16The transaction rolled back due to a communication processing error.
For details, refer to the message corresponding to the SQLCODE.
--
40B17The transaction rolled back due to a lock error.
For details, refer to the message corresponding to the SQLCODE.
--
40B18The transaction rolled back due to an array processing error.
For details, refer to the message corresponding to the SQLCODE.
--
40B19The transaction rolled back due to a memory allocation failure.
For details, refer to the message corresponding to the SQLCODE.
--
40B20The transaction rolled back due to an embedded language syntax error.
For details, refer to the message corresponding to the SQLCODE.
--
40C01The transaction rolled back due to an error in the definition SQL.
For details, refer to the message corresponding to the SQLCODE.
--
40C02The transaction rolled back because there is already a resource to be defined.
For details, refer to the KFPA11601-E message.
-601
40C03One 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
40C04One 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
40C05One 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:
    [Figure]ALTER PROCEDURE
    [Figure] ALTER ROUTINE
    [Figure] CREATE FUNCTION
    [Figure] CREATE INDEX
    [Figure] CREATE PROCEDURE
    [Figure] CREATE TABLE
    [Figure] CREATE TRIGGER
    [Figure] CREATE TYPE
    [Figure] CREATE VIEW
    [Figure] 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
40C06The transaction rolled back because the same index was already defined during a CREATE INDEX operation.
For details, refer to the KFPA11601-E message.
-601
40C07One 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
40C08One 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:
    [Figure]GRANT DBA
    [Figure] GRANT CONNECT
    [Figure] GRANT RDAREA
    [Figure] GRANT SCHEMA
    [Figure] REVOKE DBA
    [Figure] REVOKE CONNECT
    [Figure] REVOKE RDAREA
    [Figure] 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:
    [Figure]ALTER PROCEDURE
    [Figure] ALTER ROUTINE
    [Figure] CREATE FUNCTION
    [Figure] CREATE INDEX
    [Figure] CREATE PROCEDURE
    [Figure] CREATE SEQUENCE
    [Figure] CREATE TABLE
    [Figure] CREATE TRIGGER
    [Figure] CREATE TYPE
    [Figure] CREATE VIEW
    [Figure] 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:
    [Figure]CREATE AUDIT
    [Figure] DROP AUDIT
    [Figure] GRANT AUDIT
    [Figure] 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
40D01Refer to the KFPA11940-E message.-940
40D10Refer to the KFPA19451-E message.-1451
40D30Refer to the KFPA11948-E message.-948
40D31Refer to the KFPA11950-E message.-950
40D50Refer to the KFPA11404-E message.-404
40D51Refer to the KFPA11801-E message.-801
40D52Refer to the KFPA11223-E message.-223
40D53Refer to the KFPA11321-E message.-321
40D70Refer to the KFPA11210-E message.-210
40D71Refer to the KFPA11603-E message.-603
40D72Refer to the KFPA11451-E message.-451
40D73One 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:
    [Figure]A check constraint is defined for the table that contains the column to be deleted.
    [Figure]A reference constraint (foreign key) is defined for the table that contains the column to be deleted.
    [Figure]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
40D90Refer to the KFPA11996-E message.-996
40DB0Refer to the KFPA11492-E message.-492
40DB1Refer to the KFPA11493-E message.-493
40DD0Refer to the KFPA11204-E message.-204
40DD1Refer to the KFPA11224-E message.-224
40DD2Refer to the KFPA11101-E message.-101
40DD3There 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
40DD4Refer to the KFPA19727-E message.-1727
40DH0Refer to the KFPA11206-E message.-206
40DH1Refer to the KFPA11601-E message.-601
40DH2Refer to the KFPA11656-E message.-656
40DH3Refer to the KFPA11660-E message.-660
40DH4Refer to the KFPA11664-E message.-664
40DH5Refer to the KFPA11743-E message.-743
40DH6Refer to the KFPA11744-E message.-744
40DH7Refer to the KFPA11749-E message.-749
40DH8Refer to the KFPA11741-E message.-741
40DH9Refer to the KFPA11624-E message.-624
40DHARefer to the KFPA11893-E message.-893
40DHBRefer to the KFPA11894-E message.-894
40DHCCLUSTER KEY, PRIMARY KEY, or PRIMARY CLUSTER KEY is not defined for the table.
For details, refer to the KFPA11207-E message.
-207
40DHDThe specified data type does not have the specified attribute.
For details, refer to the KFPA11228-E message.
-228
40DHEPUBLIC, MASTER, HiRDB, or ALL is specified for the authorization identifier.
For details, refer to the KFPA11549-E message.
-549
40DHFOne 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
40DHGA 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
40DHHThe column specified as an index is not appropriate for the index type.
For details, refer to the KFPA11584-E message.
-584
40DHINULL cannot be specified in the column definition for a table with FIX specified.
For details, refer to the KFPA11591-E message.
-591
40DHJNULL 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
40DHKALTER 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
40DHLAnother plug-in index has already been applied to the routine.
For details, refer to the KFPA11600-E message.
-600
40DHMThe total number of columns per table has already exceeded the permitted maximum value (30,000).
For details, refer to the KFPA11602-E message.
-602
40DHNSUPPRESS cannot be specified for a table with the FIX attribute.
For details, refer to the KFPA11605-E message.
-605
40DHPNeither 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
40DHQBecause 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
40DHRThe same column name cannot be defined more than once for the same table.
For details, refer to the KFPA11612-E message.
-612
40DHTA 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
40DHUThe 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
40DHVNeither 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
40DHWAn index with UNIQUE specified cannot be defined for a repetition column.
For details, refer to the KFPA11621-E message.
-621
40DHXOne 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
40DHYThe 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
40DHZWhen 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
40DI0If 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
40DI1The column cannot be deleted because it is the only column in the table.
For details, refer to the KFPA11632-E message.
-632
40DI2The 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
40DI3ALL cannot be used for a table identifier.
For details, refer to the KFPA11658-E message.
-658
40DI4The data type and data length specified in the CHANGE clause are invalid.
For details, refer to the KFPA11659-E message.
-659
40DI5The index has already been defined in HiRDB.
For details, refer to the KFPA11661-E message.
-661
40DI6The 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
40DI7The 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
40DI8A referenced table for a reference constraint cannot be deleted.
For details, refer to the KFPA11690-E message.
-690
40DI9A 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
40DIAWhen 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
40DIBWhen 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
40DICNOT NULL cannot be specified for a column configured for the abstract data type.
For details, refer to the KFPA11698-E message.
-698
40DIDWITH DEFAULT has already been specified for the column.
For details, refer to the KFPA11699-E message.
-699
40DIFAn 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
40DIGNeither 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
40DIHThe 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
40DIIThe 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
40DIJThe 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
40DIKThe 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
40DINNone 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
40DIOThe 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
40DIPThe 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
40DIQThe ALLOCATE clause specified for a column is invalid.
For details, refer to the KFPA11750-E message.
-750
40DIRThe option specified for a column is invalid.
For details, refer to the KFPA11753-E message.
-753
40DISA duplicate routine name is specified in the FOR clause in CREATE INDEX.
For details, refer to the KFPA11754-E message.
-754
40DITThe 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
40DIUThat SQL statement cannot be executed because the plug-in has not been registered.
For details, refer to the KFPA11761-E message.
-761
40DIVThe 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
40DIWOne 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
40DIXThe 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
40DIYThere is an error in the number of RDAREAs specified for the index.
For details, refer to the KFPA11791-E message.
-791
40DIZThe 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
40DJ0The 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
40DJ1The audit event specified in CREATE AUDIT has already been defined.
For details, refer to the KFPA11908-E message.
-908
40DJ2The audit event specified in DROP AUDIT is not defined.
For details, refer to the KFPA11909-E message.
-909
40DJ3The total length of attributes defined with abstract data types is too large.
For details, refer to the KFPA11939-E message.
-939
40DJ4There is an error in the shared table or shared index definition.
For details, refer to the KFPA19575-E message.
-1575
40DJ5There is an error in the reference constraint definition or check constraint definition.
For details, refer to the KFPA19581-E message.
-1581
40DJ6In 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
40DJ7The 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
40DJ8The specified matrix partitioning table is invalid.
For details, refer to the KFPA19612-E message.
-1612
40DJ9A definition SQL statement cannot be executed on a falsification prevented table that stores data.
For details, refer to the KFPA19615-E message.
-1615
40DJAThe 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
40DJBOnly 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
40DJCThe deletion prevented duration specified for a falsification prevented table is invalid.
For details, refer to the KFPA19620-E message.
-1620
40DJDThere is an error in the specified ALTER TABLE CHANGE RDAREA.
For details, refer to the KFPA19625-E message.
-1625
40DJHA sequence generator cannot be created.
For details, refer to the KFPA19624-E message.
-1624
40DJIThe table cannot be set to be expanded to or released from the memory database.
For details, refer to the KFPA19864-E message.
-1864
40DJJThe 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
40DJKThere 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
40DJLRefer to the KFPA19604-E message.-1604
40DJMThere 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
40DJNALTER TABLE cannot be executed.
For details, refer to the KFPA19613-E message.
-1613
40DJOALTER TABLE cannot change the table definition due to the free space reusage facility.
For details, refer to the KFPA11751-E message.
-751
40DL0Refer to the KFPA11552-E message.-552
40DL1Refer to the KFPA11559-E message.-559
40DL2Refer to the KFPA11576-E message.-576
40DL3Refer to the KFPA11577-E message.-577
40DL4Refer to the KFPA11578-E message.-578
40DL5Refer to the KFPA11579-E message.-579
40DL6Refer to the KFPA11580-E message.-580
40DL7Refer to the KFPA11562-E message.-562
40DL8Refer to the KFPA19683-E message.-1683
40DL9Refer to the KFPA11571-E message.-571
40DLARefer to the KFPA11903-E message.-903
40DLBRefer to the KFPA11905-E message.-905
40DLCOne 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
40DLDBecause 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
40DLEThe user cannot grant a privilege to him/herself.
For details, refer to the KFPA11554-E message.
-554
40DLFThe user cannot revoke his/her own privilege.
For details, refer to the KFPA11555-E message.
-555
40DLGThe 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
40DLHOne 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
40DLJThe 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
40DLKThe 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
40DLLUsage 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
40DLMThe auditor's schema cannot be deleted because there is an audit trail table.
For details, refer to the KFPA11906-E message.
-906
40DLNThe auditor's schema definition privileges and CONNECT privileges cannot be revoked.
For details, refer to the KFPA11907-E message.
-907
40DLOAn error occurred in a definition related to a falsification prevented table. For details, refer to the KFPA19631-E message.-1631
40DLPThe 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
40DLQThe 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
40DLRIn 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
40DLSThe specified privilege cannot be granted or revoked. For details, refer to the KFPA19610-E message.-1610
40DN0Refer to the KFPA11307-E message.-307
40DN1Refer to the KFPA11209-E message.-209
40DP0Refer to the KFPA11787-E message.-787
40DR0No new update transaction is accepted while both-system operation is being restored. For details, refer to the KFPA19726-E message.-1726
40DT0Refer to the KFPA11692-E message.-692
40DT1Refer to the KFPA11777-E message.-777
40DT2Refer to the KFPA11930-E message.-930
40DT3Refer to the KFPA11929-E message.-929
40DT4Refer to the KFPA11811-E message.-811
40DT5Refer to the KFPA11814-E message.-814
40DT6Refer to the KFPA19718-E message.-1718
40DT7Refer to the KFPA11919-E message.-919
40DT8Refer to the KFPA11531-E message.-531
40DT9Refer to the KFPA19705-E message.-1705
40DTABecause 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
40DTBNone 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
40DTCBecause 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
40DTDThere is a shortage of shared memory for locking.
For details, refer to the KFPA11914-E message.
-914
40DTEThe 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
40DTGRefer to the KFPA19724-E message.-1724
40DTHRefer to the KFPA19725-E message.-1725
40DX0Refer to the KFPA11812-E message.-812
40DX1Refer to the KFPA11657-E message.-657
40DX2Refer to the KFPA11827-E message.-827
40DX3Refer to the KFPA11952-E message.-952
40DX4Refer to the KFPA19706-E message.-1706
40DX5The key length of an index exceeds the maximum value.
For details, refer to the KFPA11616-E message.
-616
40DX6The 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
40DX7The 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
40DX8changedata 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
40DX9A single table cannot be partitioned and defined in 4,097 or more back-end servers.
For details, refer to the KFPA11703-E message.
-703
40DXAThe number of indexes specified for a single table exceeds the maximum value (255).
For details, refer to the KFPA11706-E message.
-706
40DXBThe 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
40DXCThe 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
40DXDThe 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
40DXEThe 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
40DXFThe 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
40E01Refer to the KFPA11528-E message.-528
40E02Refer to the KFPA11529-E message.-529
40E03Refer to the KFPA11537-E message.-537
40E20Refer to the KFPA11652-E message.-652
40E21Refer to the KFPA11653-E message.-653
40E22Refer to the KFPA11358-E message.-358
40E23Refer to the KFPA11511-E message.-511
40E24Refer to the KFPA11737-E message.-737
40E25Refer to the KFPA11738-E message.-738
40E26Refer to the KFPA11815-E message.-815
40E27The 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
40E28The specified RDAREA is not a user LOB RDAREA.
For details, refer to the KFPA11599-E message.
-599
40E29The 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
40E2AThere is no available public user RDAREA.
For details, refer to the KFPA11610-E message.
-610
40E2BIf 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
40E2CThe specified LOB RDAREA is not on the same server as the RDAREA for the table.
For details, refer to the KFPA11708-E message.
-708
40E2DThe specified LOB RDAREA is already in use for another table.
For details, refer to the KFPA11709-E message.
-709
40E2EThe 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
40E2FThe same RDAREA as the immediately preceding RDAREA cannot be specified.
For details, refer to the KFPA11796-E message.
-796
40E2GThe 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
40E2IRefer to the KFPA19704-E message.-1704
40E40Refer to the KFPA11431-E message.-431
40E41Refer to the KFPA11897-E message.-897
40E42Refer to the KFPA11964-E message.-964
40E43No SQL statement other than ROLLBACK or DISCONNECT can be executed.
For details, refer to the KFPA11987-E message.
-987
40E60Refer to the KFPA11810-E message.-810
40E61One 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
40E62Refer to the KFPA11882-E message.-882
40E63Refer to the KFPA11884-E message.-884
40E64Refer to the KFPA19523-E message.-1523
Legend:
--: Not applicable

Table 8-24 SQLSTATE class 42

SQLSTATEExplanationSQLCODE
42000One 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
42501The number of characters specified in the character string literal exceeds the permitted maximum value.
For details, refer to the KFPA11102-E message.
-102
42502Refer to the KFPA11145-E message.-145
42503The 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
42504The 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
42505The character string literal is not complete.
For details, refer to the KFPA11106-E message.
-106
42506The hexadecimal character string literal is not complete.
For details, refer to the KFPA11106-E message.
-106
42507Refer to the KFPA11140-E message.-140
42508The mixed character string literal is not complete.
For details, refer to the KFPA11106-E message.
-106
42509Refer to the KFPA11144-E message.-144
42510There are one or more characters that violate the syntax rules.
For details, refer to the KFPA11104-E message.
-104
42511Refer to the KFPA11410-E message.-410
42512Refer to the KFPA11103-E message.-103
42513The value of the specified numeric literal falls beyond the permitted value range.
For details, refer to the KFPA11405-E message.
-405
42514Refer to the KFPA11142-E message.-142
42520Refer to the KFPA11107-E message.-107
42529The authorization identifier is longer than 8 characters.
For details, refer to the Refer to the KFPA11564-E message.
-564
42530The identifier does not begin with an alphabetic character, or the delimited identifier is not complete.
For details, refer to the KFPA11104-E message.
-104
42539There is a syntax error in the authorization identifier.
For details, refer to the KFPA11564-E message.
-564
42550Refer to the KFPA11418-E message.-418
42551Refer to the KFPA11217-E message.-217
42561There is an error in the left-hand operand of the NULL predicate.
For details, refer to the KFPA11114-E message.
-114
42562There is an error in the left-hand operand of the LIKE predicate.
For details, refer to the KFPA11114-E message.
-114
42563The XMLEXISTS predicate is specified outside the WHERE clause.
For details, refer to the KFPA11114-E message.
-114
42570The UPDATE or DELETE statement using the cursor cannot be preprocessed by the PREPARE statement.
For details, refer to the KFPA11157-E message.
-157
42572Refer to the KFPA11149-E message.-149
42573Refer to the KFPA11164-E message.-164
42580The subscript specified for a repetition column is invalid.
For details, refer to the KFPA11186-E message.
-186
42581In 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
42590Refer to the KFPA11604-E message.-604
42591Refer to the KFPA11131-E message.-131
425A0The 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
425A2Refer to the KFPA11139-E message.-139
425A4The 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
425A6The number of specified row value constructor elements exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425B0The number of tables specified in the query exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425B1The number of specified selection expressions exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425B2Refer to the KFPA11122-E message.-122
425B3Refer to the KFPA11124-E message.-124
425B4The number of column specifications in the FOR UPDATE clause exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425B5The number of specified insertion values exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425B6The number of columns to be inserted exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425B7The number of columns to be updated exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425B8The number of arguments specified in the arguments list exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425B9The number of table names specified in the LOCK statement exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425BBThe number of column names specified in the derived columns list exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425BCThe number of list names exceeds the permitted maximum value.
For details, refer to the KFPA11773-E message.
-773
425C0Refer to the KFPA11602-E message.-602
425C1The 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
425C2The 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
425C3The number of predicates specified in a check constraint exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425C6The number of columns specified in the index definition exceeds the permitted maximum value.
For details, refer to the KFPA11617-E message.
-617
425C7The number of tables specified in the index definition exceeds the permitted maximum value.
For details, refer to the KFPA11617-E message.
-617
425C8The number of exception values specified in the index definition exceeds the permitted maximum value.
For details, refer to the KFPA11617-E message.
-617
425C9The number of exception key values specified in the index definition exceeds the permitted maximum value.
For details, refer to the KFPA11129-E message.
-129
425CARefer to the KFPA11570-E message.-570
425CBRefer to the KFPA11585-E message.-585
425CCThe number of columns for the primary key in CREATE TABLE exceeds the permitted maximum value.
For details, refer to the KFPA11674-E message.
-674
425CDThe 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
425CEThe number of columns for the cluster key in CREATE TABLE exceeds the permitted maximum value.
For details, refer to the KFPA11674-E message.
-674
425D0Refer to the KFPA11678-E message.-678
425D3There 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
425D4Refer to the KFPA11673-E message.-673
425D5There is an error in the specified table options or index options.
For details, refer to the KFPA11705-E message.
-705
425D7Refer to the KFPA11572-E message.-572
425DPRefer to the KFPA11136-E message.-136
425E0Refer to the KFPA11633-E message.-633
425L0Refer to the KFPA11778-E message.-778
425L1Refer to the KFPA11781-E message.-781
425L2Refer to the KFPA11782-E message.-782
425L5Refer to the KFPA11191-E message.-191
42601There 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
42602Refer to the KFPA11105-E message.-105
42603Refer to the KFPA11106-E message.-106
42604Refer to the KFPA11116-E message.-116
42605Refer to the KFPA11138-E message.-138
42606Refer to the KFPA11173-E message.-173
42607Refer to the KFPA11175-E message.-175
42608Refer to the KFPA11289-E message.-289
42609Refer to the KFPA11292-E message.-292
42610Refer to the KFPA11355-E message.-355
42611Refer to the KFPA11461-E message.-461
42613Refer to the KFPA11508-E message.-508
42614Refer to the KFPA11638-E message.-638
42615Refer to the KFPA11641-E message.-641
42618Refer to the KFPA19323-E message.-1323
42619Refer to the KFPA19407-E message.-1407
42620Refer to the KFPA19408-E message.-1408
42621A 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
42701The number of literals exceeds the permitted maximum value.
For details, refer to the KFPA11102-E and KFPA11141-E messages.
-102
-141
42702Refer to the KFPA11161-E message.-161
42703The 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
42704Refer to the KFPA11128-E message.-128
42710Refer to the KFPA11112-E message.-112
42711Refer to the KFPA11113-E message.-113
42712Refer to the KFPA11402-E message.-402
42713Refer to the KFPA11403-E message.-403
42714Refer to the KFPA11120-E message.-120
42716Refer to the KFPA11127-E message.-127
42720Refer to the KFPA11117-E message.-117
42721Refer to the KFPA11195-E message.-195
42722Refer to the KFPA11192-E message.-192
42723Refer to the KFPA11650-E message.-650
42730Refer to the KFPA11211-E message.-211
42731Refer to the KFPA11121-E message.-121
42732Refer to the KFPA11123-E message.-123
42733Refer to the KFPA11458-E message.-458
42734Refer to the KFPA11459-E message.-459
42740One 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
42741Refer to the KFPA11204-E message.-204
42742One 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
42743One 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
42744One 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
42745One 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
42746Refer to the KFPA11119-E message.-119
42747Refer to the KFPA11224-E message.-224
42748Refer to the KFPA11260-E message.-260
42749Refer to the KFPA11239-E message.-239
42750Refer to the KFPA11214-E message.-214
42751Refer to the KFPA11215-E message.-215
42752Refer to the KFPA11216-E message.-216
42754Refer to the KFPA11180-E message.-180
42755One 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
42756Refer to the KFPA11184-E message.-184
42757Refer to the KFPA11185-E message.-185
42758Refer to the KFPA11186-E message.-186
42759Refer to the KFPA11187-E message.-187
4275ARefer to the KFPA11188-E message.-188
42760There is an error in the base table specification for the list to be created.
For details, refer to the KFPA11773-E message.
-773
42762Refer to the KFPA11776-E message.-776
42763Refer to the KFPA11783-E message.-783
42770One 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
42771Refer to the KFPA11419-E message.-419
42772Refer to the KFPA11422-E message.-422
42773Refer to the KFPA11428-E message.-428
42774Refer to the KFPA11445-E message.-445
42780One 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
42781Refer to the KFPA11421-E message.-421
42782There is an error in the operands specified in a scalar function.
For details, refer to the KFPA11425-E message.
-425
42783Refer to the KFPA11427-E message.-427
42784There 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
42785There is an error in operands in the CAST specification.
For details, refer to the KFPA11453-E message.
-453
42786Refer to the KFPA11177-E message.-177
42787Refer to the KFPA11475-E message.-475
42792One 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
42793Refer to the KFPA11118-E message.-118
42794Refer to the KFPA11148-E message.-148
42795No RDAREA can be specified for the following tables:
  • Read-only viewed tables
  • Query name tables
For details, refer to the KFPA19277-E message.
-1277
42796The 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
427A0Refer to the KFPA11101-E message.-101
427A1Refer to the KFPA11196-E message.-196
427A2Refer to the KFPA11137-E message.-137
427B2Refer to the KFPA11194-E message.-194
427B3Refer to the KFPA11677-E message.-677
427C1Refer to the KFPA19290-E message.-1290
427D0Refer to the KFPA11169-E message.-169
427DARefer to the KFPA19203-E message.-1203
427E0Refer to the KFPA11237-E message.-237
427F0Refer to the KFPA11259-E message.-259
427FARefer to the KFPA11262-E message.-262
427FBRefer to the KFPA11263-E message.-263
42801One 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
42802One 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
42803Refer to the KFPA11408-E message.-408
42804Refer to the KFPA11197-E message.-197
42806One 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
42807There 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
42809Refer to the KFPA11238-E message.-238
4280BRefer to the KFPA11236-E message.-236
4280CRefer to the KFPA11440-E message.-440
4280ERefer to the KFPA11468-E message.-468
42810Refer to the KFPA11134-E message.-134
42812The length of a long data item falls beyond the permitted value range.
For details, refer to the KFPA11420-E message.
-420
42814Refer to the KFPA11441-E message.-441
4281ARefer to the KFPA11132-E message.-132
42820Refer to the KFPA11548-E message.-548
42830Refer to the KFPA11230-E message.-230
42850One 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
42851Refer to the KFPA11671-E message.-671
42870Refer to the KFPA11670-E message.-670
42871Refer to the KFPA11672-E message.-672
428A0Refer to the KFPA11456-E message.-456
428A1Refer to the KFPA11640-E message.-640
428A2Refer to the KFPA11642-E message.-642
428D1Refer to the KFPA19150-E message.-1150
428D2Refer to the KFPA19617-E message.-1617
428D3Refer to the KFPA19620-E message.-1620
42907Refer to the KFPA11146-E message.-146
42908Refer to the KFPA11162-E message.-162
42909Refer to the KFPA11174-E message.-174
42910Refer to the KFPA11231-E message.-231
42911Refer to the KFPA11232-E message.-232
42912Refer to the KFPA11234-E message.-234
42913Refer to the KFPA11240-E message.-240
42914Refer to the KFPA11158-E message.-158
42915Refer to the KFPA11282-E message.-282
42916Refer to the KFPA11283-E message.-283
42917Refer to the KFPA11284-E message.-284
42918Refer to the KFPA11285-E message.-285
42919Refer to the KFPA11286-E message.-286
42920Refer to the KFPA11287-E message.-287
42921Refer to the KFPA11288-E message.-288
42922Refer to the KFPA11291-E message.-291
42924Refer to the KFPA11294-E message.-294
42925Refer to the KFPA11295-E message.-295
42927Refer to the KFPA11382-E message.-382
42928Refer to the KFPA11442-E message.-442
42929Refer to the KFPA11460-E message.-460
42930Refer to the KFPA11565-E message.-565
42931Refer to the KFPA11600-E message.-600
42932Refer to the KFPA11724-E message.-724
42933Refer to the KFPA11780-E message.-780
42934Refer to the KFPA11824-E message.-824
42937Refer to the KFPA19330-E message.-1330
42938Refer to the KFPA19458-E message.-1458
42939Refer to the KFPA19633-E message.-1633
42941Refer to the KFPA11126-E message.-126
42942Refer to the KFPA11133-E message.-133
42943Refer to the KFPA11154-E message.-154
42946Refer to the KFPA11168-E message.-168
42947Refer to the KFPA11171-E message.-171
42948Refer to the KFPA11172-E message.-172
42949Refer to the KFPA11176-E message.-176
42950Refer to the KFPA11179-E message.-179
42951Refer to the KFPA11198-E message.-198
42952Refer to the KFPA11228-E message.-228
42953Refer to the KFPA11235-E message.-235
42954Refer to the KFPA11243-E message.-243
42955Refer to the KFPA11249-E message.-249
42956Refer to the KFPA11254-E message.-254
42958Refer to the KFPA11266-E message.-266
42959Refer to the KFPA11267-E message.-267
42960Refer to the KFPA11273-E message.-273
42961Refer to the KFPA11274-E message.-274
42962Refer to the KFPA11276-E message.-276
42963Refer to the KFPA11277-E message.-277
42964Refer to the KFPA11296-E message.-296
42965Refer to the KFPA11299-E message.-299
42966Refer to the KFPA11314-E message.-314
42967Refer to the KFPA11351-E message.-351
42968Refer to the KFPA11443-E message.-443
42970Refer to the KFPA11462-E message.-462
42971Refer to the KFPA11463-E message.-463
42972Refer to the KFPA11470-E message.-470
42973Refer to the KFPA11471-E message.-471
42974Refer to the KFPA11472-E message.-472
42975Refer to the KFPA11473-E message.-473
42976Refer to the KFPA11474-E message.-474
42978Refer to the KFPA11477-E message.-477
42979Refer to the KFPA11479-E message.-479
42980Refer to the KFPA11504-E message.-504
42981Refer to the KFPA11583-E message.-583
42983Refer to the KFPA11746-E message.-746
42984Refer to the KFPA11750-E message.-750
42985Refer to the KFPA11753-E message.-753
42986Refer to the KFPA11774-E message.-774
42987Refer to the KFPA11807-E message.-807
42988Refer to the KFPA11829-E message.-829
42989Refer to the KFPA11839-E message.-839
429A2Refer to the KFPA19101-E message.-1101
429A5Refer to the KFPA19110-E message.-1110
429A6Refer to the KFPA19111-E message.-1111
429A7Refer to the KFPA19130-E message.-1130
429A8Refer to the KFPA19170-E message.-1170
429A9Refer to the KFPA19180-E message.-1180
429B0Refer to the KFPA19181-E message.-1181
429B1Refer to the KFPA19182-E message.-1182
429B2Refer to the KFPA19184-E message.-1184
429B3Refer to the KFPA19185-E message.-1185
429B4Refer to the KFPA19187-E message.-1187
429B5Refer to the KFPA19188-E message.-1188
429B6Refer to the KFPA19189-E message.-1189
429B9Refer to the KFPA19212-E message.-1212
429C0Refer to the KFPA19220-E message.-1220
429C1Refer to the KFPA19221-E message.-1221
429C2Refer to the KFPA19254-E message.-1254
429C3Refer to the KFPA19270-E message.-1270
429C4Refer to the KFPA19271-E message.-1271
429C5Refer to the KFPA19272-E message.-1272
429C6Refer to the KFPA19273-E message.-1273
429C7Refer to the KFPA19274-E message.-1274
429C8Refer to the KFPA19275-E message.-1275
429C9Refer to the KFPA19291-E message.-1291
429D0Refer to the KFPA19292-E message.-1292
429D1Refer to the KFPA19295-E message.-1295
429D2Refer to the KFPA19319-E message.-1319
429D3Refer to the KFPA19321-E message.-1321
429D4Refer to the KFPA19322-E message.-1322
429D5Refer to the KFPA19324-E message.-1324
429D6Refer to the KFPA19327-E message.-1327
429D7Refer to the KFPA19328-E message.-1328
429D8Refer to the KFPA19329-E message.-1329
429D9Refer to the KFPA19405-E message.-1405
429E0Refer to the KFPA19409-E message.-1409
429E2Refer to the KFPA19452-E message.-1452
429E3Refer to the KFPA19453-E message.-1453
429E4Refer to the KFPA19454-E message.-1454
429E5Refer to the KFPA19577-E message.-1577
429E6The 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
429E7The 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
429E8Refer to the KFPA11188-E message.-188
429E9Refer to the KFPA11553-E message.-553
429F0Refer to the KFPA11836-E message.-836
429F1Refer to the KFPA19105-E message.-1105
429F2Refer to the KFPA19140-E message.-1140
429F3Refer to the KFPA19171-E message.-1171
429F4Refer to the KFPA19186-E message.-1186
429F5Refer to the KFPA19406-E message.-1406
429F6Refer to the KFPA19603-E message.-1603
429F8Refer to the KFPA19318-E message.-1318
429F9Defined 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
429FAA function execution does not end with the RETURN statement.
For details, refer to the KFPA11986-E message.
-986
42E28Refer to the KFPA11455-E message.-455
42E29Refer to the KFPA19459-E message.-1459
42I02Refer to the KFPA11207-E message.-207
42I03Refer to the KFPA11432-E message.-432
42I08One 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
42I0ARefer to the KFPA11766-E message.-766
42I12Refer to the KFPA11574-E message.-574
42I13Refer to the KFPA11601-E message.-601
42I14Refer to the KFPA11609-E message.-609
42I15Refer to the KFPA11612-E message.-612
42I16Refer to the KFPA11614-E message.-614
42I17Refer to the KFPA11615-E message.-615
42I18Refer to the KFPA11619-E message.-619
42I19Refer to the KFPA11621-E message.-621
42I20Refer to the KFPA11625-E message.-625
42I23Refer to the KFPA11628-E message.-628
42I24Refer to the KFPA11631-E message.-631
42I25Refer to the KFPA11632-E message.-632
42I26Refer to the KFPA11656-E message.-656
42I27Refer to the KFPA11659-E message.-659
42I29Refer to the KFPA11661-E message.-661
42I30Refer to the KFPA11664-E message.-664
42I31One 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
42I32Refer to the KFPA11667-E message.-667
42I37Tables cannot be defined with only reserved columns.
For details, refer to the KFPA11685-E message.
-685
42I41Refer to the KFPA11690-E message.-690
42I42Refer to the KFPA11693-E message.-693
42I43Refer to the KFPA11694-E message.-694
42I46Refer to the KFPA11697-E message.-697
42I47Refer to the KFPA11698-E message.-698
42I54Refer to the KFPA11743-E message.-743
42I55Refer to the KFPA11744-E message.-744
42I56Refer to the KFPA11745-E message.-745
42I58Refer to the KFPA11747-E message.-747
42I60Refer to the KFPA11758-E message.-758
42I65Refer to the KFPA11764-E message.-764
42I68Refer to the KFPA11791-E message.-791
42I70Refer to the KFPA11793-E message.-793
42I77Refer to the KFPA19602-E message.-1602
42I79Refer to the KFPA11741-E message.-741
42I80Refer to the KFPA11775-E message.-775
42I82Refer to the KFPA11712-E message.-712
42I86Refer to the KFPA19612-E message.-1612
42I88Refer to the KFPA11591-E message.-591
42I89Refer to the KFPA11592-E message.-592
42I90Refer to the KFPA11165-E message.-165
42I93Refer to the KFPA11478-E message.-478
42I9ARefer to the KFPA19615-E message.-1615
42I9BRefer to the KFPA19616-E message.-1616
42IA0A sequence generator cannot be created.
For details, refer to the KFPA19624-E message.
-1624
42J02Refer to the KFPA11584-E message.-584
42J03Refer to the KFPA11605-E message.-605
42J04Refer to the KFPA11606-E message.-606
42J05Refer to the KFPA11611-E message.-611
42J06Refer to the KFPA11620-E message.-620
42J07Refer to the KFPA11622-E message.-622
42J08Refer to the KFPA11624-E message.-624
42J10Refer to the KFPA11702-E message.-702
42J11Refer to the KFPA11704-E message.-704
42J12Refer to the KFPA11710-E message.-710
42J13Refer to the KFPA11717-E message.-717
42J14Refer to the KFPA11718-E message.-718
42J15Refer to the KFPA11721-E message.-721
42J16Refer to the KFPA19331-E message.-1331
42J17Refer to the KFPA19575-E message.-1575
42J18Refer to the KFPA19625-E message.-1625
42J21Refer to the KFPA11200-E message.-200
42J22Refer to the KFPA11369-E message.-369
42J23Refer to the KFPA11597-E message.-597
42J24Refer to the KFPA11754-E message.-754
42J29Refer to the KFPA11908-E message.-908
42J30Refer to the KFPA11909-E message.-909
42J31Refer to the KFPA11939-E message.-939
42J33Refer to the KFPA19200-E message.-1200
42J34Refer to the KFPA19581-E message.-1581
42J35Refer to the KFPA19681-E message.-1681
42JA1The ? parameter cannot be specified in an SQL statement for a trigger.
For details, refer to the KFPA19450-E message.
-1450
42JA2A trigger cannot be defined for other schemas.
For details, refer to the KFPA19450-E message.
-1450
42JA4Trigger can be defined only for a base table.
For details, refer to the KFPA19450-E message.
-1450
42JA5The table for which a trigger is to be defined does not exist.
For details, refer to the KFPA19450-E message.
-1450
42JA6OLD 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
42JA7If INSERT is specified as the trigger execution timing, OLD ROW cannot be specified.
For details, refer to the KFPA19450-E message.
-1450
42JA8If DELETE is specified as the trigger execution timing, NEW ROW cannot be specified.
For details, refer to the KFPA19450-E message.
-1450
42JA9The same name cannot be specified in OLD ROW and NEW ROW.
For details, refer to the KFPA19450-E message.
-1450
42JAAIf FOR EACH STATEMENT is specified, NEW ROW and OLD ROW cannot be specified.
For details, refer to the KFPA19450-E message.
-1450
42JABMore than 30,000 columns are specified in the trigger execution timing.
For details, refer to the KFPA19450-E message.
-1450
42JACThe column name specified in the trigger execution timing is duplicated.
For details, refer to the KFPA19450-E message.
-1450
42JADThe 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
42JAEIn 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
42JAFRepetition 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
42JAHA table for which a trigger is defined cannot be specified in the triggered SQL statement.
For details, refer to the KFPA19450-E message.
-1450
42JAJA reserved column cannot be specified as a trigger event column.
For details, refer to the KFPA19450-E message.
-1450
42JALThe user cannot define another user's table.
For details, refer to the KFPA19450-E message.
-1450
42JAMROW cannot be specified for the old or new values correlation name.
For details, refer to the KFPA19450-E message.
-1450
42JANIf 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
42JAOIn 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
42JAPNeither a Java function nor a Java procedure can be specified in a triggered SQL statement.
For details, refer to the KFPA19450-E message.
-1450
42JAQROLLBACK cannot be specified in a triggered SQL statement.
For details, refer to the KFPA19450-E message.
-1450
42JARCOMMIT cannot be specified in a triggered SQL statement.
For details, refer to the KFPA19450-E message.
-1450
42JASPURGE cannot be specified in a triggered SQL statement.
For details, refer to the KFPA19450-E message.
-1450
42JATGET_JAVA_STORED_ROUTINE_SOURCE cannot be specified in a triggered SQL statement.
For details, refer to the KFPA19450-E message.
-1450
42JD1Refer to the KFPA19293-E message.-1293
42K01Refer to the KFPA11550-E message.-550
42K02Refer to the KFPA11551-E message.-551
42K03Refer to the KFPA11552-E message.-552
42K04Refer to the KFPA11554-E message.-554
42K05Refer to the KFPA11555-E message.-555
42K06Refer to the KFPA11556-E message.-556
42K14Refer to the KFPA11607-E message.-607
42K20Refer to the KFPA11663-E message.-663
42K21Refer to the KFPA11680-E message.-680
42K22Refer to the KFPA11823-E message.-823
42K25Refer to the KFPA11514-E message.-514
42K26Refer to the KFPA11547-E message.-547
42K27Refer to the KFPA19219-E message.-1219
42K28Refer to the KFPA11573-E message.-573
42K29Refer to the KFPA11590-E message.-590
42K30Refer to the KFPA11902-E message.-902
42K32Refer to the KFPA11904-E message.-904
42K33Refer to the KFPA11905-E message.-905
42K34Refer to the KFPA11906-E message.-906
42K35Refer to the KFPA11907-E message.-907
42K36Refer to the KFPA19518-E message.-1518
42K37Refer to the KFPA19631-E message.-1631
42K38Refer to the KFPA19634-E message.-1634
42K39Refer to the KFPA19635-E message.-1635
42K40Refer to the KFPA19680-E message.-1680
42K41Refer to the KFPA19296-E message.-1296
42K42Refer to the KFPA11925-E message.-925

Table 8-25 SQLSTATE class 45

SQLSTATEExplanationSQLCODE
45501Refer to the KFPA19404-E message.-1404

Table 8-26 SQLSTATE class 51

SQLSTATEExplanationSQLCODE
51001Refer to the KFPA11307-E message.-307
51003Refer to the KFPA11769-E message.-769
51004Refer to the KFPA11838-E message.-838
51006Refer to the KFPA11804-E message.-804
5100FRefer to the KFPA11997-E message.-997
5100HRefer to the KFPA11359-E message.-359

Table 8-27 SQLSTATE class 52

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

Table 8-28 SQLSTATE class 53

SQLSTATEExplanationSQLCODE
53001Refer to the KFPA11356-E message.-356
53002Refer to the KFPA11546-E message.-546
53004Refer to the KFPA11900-E message.-900
53005Refer to the KFPA19587-E message.-1587
53006Refer to the KFPA19800-E message.-1800
53021Refer to the KFPA11613-E message.-613
53201Refer to the KFPA11930-E message.-930
53202Refer to the KFPA11729-E message.-729
53203Refer to the KFPA11914-E message.-914
53204Refer to the KFPA11929-E message.-929
53208Refer to the KFPA11395-E message.-395
53209The 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
53210There is not enough work area for locking.
For details, refer to the KFPA11912-E message.
-912
53212An attempt to expand the thread stack area failed.
For details, refer to the KFPA11945-E message.
-945
53301Refer to the KFPA11596-E message.-596
53302Refer to the KFPA19576-E message.-1576
53305Refer to the KFPA19705-E message.-1705
53401Refer to the KFPA11342-E message.-342
53402Refer to the KFPA11531-E message.-531
53601Refer to the KFPA19719-E message.-1719
53602Refer to the KFPA19724-E message.-1724
53603Refer to the KFPA19725-E message.-1725

Table 8-29 SQLSTATE class 54

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

Table 8-30 SQLSTATE class 55

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

Table 8-31 SQLSTATE class 56

SQLSTATEExplanationSQLCODE
56001Refer to the KFPA11312-E message.-312
56007Refer to the KFPA11616-E message.-616
56008Refer to the KFPA11654-E message.-654
56009Refer to the KFPA11657-E message.-657
5600BRefer to the KFPA11706-E message.-706
5600CRefer to the KFPA11748-E message.-748
5600EThe length of the SQL statement to be dynamically preprocessed is invalid.
For details, refer to the KFPA11821-E message.
-821
5600FThe length of the SQL statement specified in the view definition exceeds the permitted maximum value.
For details, refer to the KFPA11821-E message.
-821
5600GThe 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
5600HThe length of the SQL statement specified in the procedure definition exceeds the permitted maximum value.
For details, refer to the KFPA11821-E message.
-821
5600IRefer to the KFPA19450-E message.-1450
56010Refer to the KFPA11662-E message.-662
56011Refer to the KFPA11167-E message.-167
56012Refer to the KFPA11250-E message.-250
56013Refer to the KFPA11343-E message.-343
56014Refer to the KFPA11634-E message.-634
56015Refer to the KFPA11636-E message.-636
56016Refer to the KFPA11637-E message.-637
56017Refer to the KFPA11703-E message.-703
56018Refer to the KFPA11714-E message.-714
56019Refer to the KFPA11795-E message.-795
56020Refer to the KFPA11805-E message.-805
56022Refer to the KFPA11952-E message.-952
56026Refer to the KFPA19513-E message.-1513
56027Refer to the KFPA19583-E message.-1583
56028Refer to the KFPA19584-E message.-1584
56030The result of serialization (conversion to character string) of an XML-type value is too long.
For details, refer to the KFPA19313-E message.
-1313
56031The size of an SQL object exceeds 32 MB.
For details, refer to the KFPA11992-E message.
-992
56032The 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

SQLSTATEExplanationSQLCODE
57008Refer to the KFPA11528-E message.-528
57009Refer to the KFPA11529-E message.-529

Table 8-33 SQLSTATE class 58

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

Table 8-34 SQLSTATE class 59

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

Table 8-35 SQLSTATE class 5A

SQLSTATEExplanationSQLCODE
5A001Refer to the KFPA11329-E message.-329
5A003Refer to the KFPA11785-E message.-785

Table 8-36 SQLSTATE class 5B

SQLSTATEExplanationSQLCODE
5B001Refer to the KFPA11735-E message.-735
5B002The SIGNAL or RESIGNAL statement resulted in an error.
For details, refer to the KFPA19400-E message.
-1400

Table 8-37 SQLSTATE class 5C

SQLSTATEExplanationSQLCODE
5C006Refer to the KFPA11431-E message.-431
5C007Refer to the KFPA11476-E message.-476
5C008Refer to the KFPA11484-E message.-484
5C009Refer to the KFPA11485-E message.-485
5C010Refer to the KFPA11553-E message.-553
5C011Refer to the KFPA11720-E message.-720
5C012Refer to the KFPA11728-E message.-728
5C013Refer to the KFPA11731-E message.-731
5C014Refer to the KFPA11732-E message.-732
5C015Refer to the KFPA11733-E message.-733
5C016Refer to the KFPA11736-E message.-736
5C021Refer to the KFPA11941-E message.-941
5C024Refer to the KFPA11984-E message.-984
5C025Refer to the KFPA11987-E message.-987
5C026Refer to the KFPA19332-E message.-1332
5C027Refer to the KFPA19333-E message.-1333
5C030Refer to the KFPA19700-E message.-1700
5C031Refer to the KFPA19517-E message.-1517
5C032Refer to the KFPA19520-E message.-1520

Table 8-38 SQLSTATE class 5E

SQLSTATEExplanationSQLCODE
5E101Refer to the KFPA19222-E message.-1222

Table 8-39 SQLSTATE class IZ

SQLSTATEExplanationSQLCODE
IZ003An 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

SQLSTATEExplanationSQLCODE
R2000During 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