Table 8-1 Classes of SQLSTATE returned by HiRDB and their explanations
Class | Explanation | Reference |
---|---|---|
00 | Terminated normally. | Table 8-2 |
01 | A warning was issued. | Table 8-3 |
02 | There is no data. | Table 8-4 |
07 | An error occurred on a dynamic SQL statement. | Table 8-5 |
08 | A connection violation occurred. | Table 8-6 |
0A | The facility is not supported. | Table 8-7 |
0F | A locator exception occurred. | Table 8-8 |
0K | RESIGNAL was executed while the handler was disabled. | Table 8-9 |
21 | A base violation occurred. | Table 8-10 |
22 | A data exception occurred. | Table 8-11 |
23 | An integrity constraint violation occurred. | Table 8-12 |
24 | The cursor status is invalid. | Table 8-13 |
25 | The transaction status is invalid. | Table 8-14 |
26 | The SQL statement name is invalid. | Table 8-15 |
28 | The specified authorization identifier is invalid. | Table 8-16 |
2C | The character set name is invalid. | Table 8-17 |
2F | An SQL routine exception occurred. | Table 8-18 |
33 | The SQL descriptor name is invalid. | Table 8-19 |
34 | The cursor name is invalid. | Table 8-20 |
37 | A syntax error or access rule violation was detected in a dynamic SQL statement. | Table 8-21 |
38 | An external routine exception occurred. | Table 8-22 |
40 | The transaction rolled back. | Table 8-23 |
42 | A syntax error or access rule violation was detected. | Table 8-24 |
45 | An unprocessed user definition exception occurred. | Table 8-25 |
51 | An error related to a specific SQL facility occurred (error caused by a nonstandard specific SQL facility). | Table 8-26 |
52 | The environment is not ready for SQL execution (this status occurs when the environment refuses to execute SQL statements. The environment status much be changed). | Table 8-27 |
53 | The system resource status does not allow SQL execution (this status occurs when SQL execution is refused due to the system status, owing to a problem such as a shortage of memory or resources. The user might need to take some action on the system). | Table 8-28 |
54 | The application program status is invalid (error caused by application program settings, details of processing, attributes, status, etc.). | Table 8-29 |
55 | An error occurred on the remote system (such as an OS error or a communication error). | Table 8-30 |
56 | The maximum or limit value was reached (error based on the maximum or minimum value permitted by the processors or system). | Table 8-31 |
57 | The status of an SQL execution procedure object is invalid (error related to an SQL object, routine object, or SQL pool object). | Table 8-32 |
58 | The RDAREA specification or RDAREA status is invalid (error caused by the specification, status, and type of RDAREA). | Table 8-33 |
59 | The abstract data type or plug-in status is invalid (error caused by the abstract data type or plug-in registration status). | Table 8-34 |
5A | The list name or list status is invalid. | Table 8-35 |
5B | Processing was canceled by a user request (such as an interrupt). | Table 8-36 |
5C | A system error other than those described above or below occurred. | Table 8-37 |
5E | The view object status is invalid. | Table 8-38 |
IZ | An error specific to a utility or non-SQLAPI occurred. | Table 8-39 |
R2 | There is no data. | Table 8-40 |
Table 8-2 SQLSTATE class 00
SQLSTATE | Explanation | SQLCODE |
---|---|---|
00000 | Terminated normally. | 0 |
Table 8-3 SQLSTATE class 01
SQLSTATE | Explanation | SQLCODE |
---|---|---|
01000 | Terminated normally with a warning. | 0 |
0100C | A dynamic results set was returned. | +120 |
0100D | Another result set was returned. | +121 |
0100E | An attempt was made to return too many result sets. | +120 |
01R00 | Terminated normally with a warning. | Positive number other than 100 or 110 |
Table 8-4 SQLSTATE class 02
SQLSTATE | Explanation | SQLCODE |
---|---|---|
02000 | There is no data. | 100 |
02001 | There is no other result set to be returned. | 100 |
Table 8-5 SQLSTATE class 07
SQLSTATE | Explanation | SQLCODE |
---|---|---|
07001 | One of the following errors is present:
| -311 -313 |
07002 | The data type or data length of an output variable set in the SQL descriptor area is invalid. For details, refer to the KFPA11311-E message. | -311 |
07003 | Refer to the KFPA11506-E message. | -506 |
07005 | Refer to the KFPA11507-E message. | -507 |
07006 | One of the following errors is present:
| -301 -303 |
07008 | Refer to the KFPA11310-E message. | -310 |
07501 | Refer to the KFPA11308-E message. | -308 |
07502 | Refer to the KFPA11340-E message. | -340 |
07503 | Refer to the KFPA11901-E message. | -901 |
Table 8-6 SQLSTATE class 08
SQLSTATE | Explanation | SQLCODE |
---|---|---|
08000 | The authorization identifier is invalid. For details, refer to the KFPA11564-E message. | -564 |
08002 | Refer to the KFPA11752-E message. | -752 |
08007 | Refer to the KFPA11966-E message. | -966 |
08603 | Refer to the KFPA11940-E message. | -940 |
08605 | Refer to the KFPA11990-E message. | -990 |
08606 | Refer to the KFPA19632-E message. | -1632 |
08620 | Refer to the KFPA11932-E message. | -932 |
08621 | Refer to the KFPA19521-E message. | -1521 |
08622 | Refer to the KFPA11930-E message. | -930 |
Table 8-7 SQLSTATE class 0A
SQLSTATE | Explanation | SQLCODE |
---|---|---|
0A503 | Refer to the KFPA11948-E message. | -948 |
0A504 | Refer to the KFPA11950-E message. | -950 |
0A505 | Refer to the KFPA11988-E message. | -988 |
0A507 | Refer to the KFPA11899 message. | -899 |
Table 8-8 SQLSTATE class 0F
SQLSTATE | Explanation | SQLCODE |
---|---|---|
0F001 | Refer to the KFPA11364-E message. | -364 |
Table 8-9 SQLSTATE class 0K
SQLSTATE | Explanation | SQLCODE |
---|---|---|
0K000 | Refer to the KFPA19403-E message. | -1403 |
Table 8-10 SQLSTATE class 21
SQLSTATE | Explanation | SQLCODE |
---|---|---|
21501 | Refer to the KFPA11449-E message. | -449 |
21502 | Refer to the KFPA11450-E message. | -450 |
Table 8-11 SQLSTATE class 22
SQLSTATE | Explanation | SQLCODE |
---|---|---|
22001 | One of the following errors is present:
| -404 -420 -453 -469 |
22002 | A data value assigned to the locator is the null value, but no indicator variable is specified. For details, refer to the KFPA11305-E and KFPA11366-E messages. | -305 -366 |
22003 | One of the following errors is present:
| -302 -304 -326 -453 -801 -802 -1345 |
22004 | One of the following errors is present:
| -212 -1294 |
22007 | The operation resulted in an overflow because the specified date representation is invalid. For details, refer to the KFPA11801-E message. | -801 |
22008 | One of the following errors is present:
| -326 -416 -801 |
2200A | Refer to the KFPA11938-E message. | -938 |
22011 | In the SUBSTR scalar function, the end location falls before the start location. For details, refer to the KFPA11427-E message. | -427 |
22012 | A division by zero error occurred during an arithmetic operation. For details, refer to the KFPA11800-E and KFPA19326-E messages. | -800 -1326 |
22014 | Refer to the KFPA11367-E message. | -367 |
22015 | The value of the time interval field falls beyond the permitted range. For details, refer to the KFPA11326-E message. | -326 |
22018 | The format of a character-string literal in the conversion source data or the value of the conversion source data is invalid. For details, refer to the KFPA11453-E message. | -453 |
22019 | The length of the escape character specified in the LIKE, XLIKE, or SIMILAR predicate is not one character. For details, refer to the KFPA11424-E message. | -424 |
22025 | An invalid method was used to specify the escape character or pattern character string in the LIKE, XLIKE, or SIMILAR predicate. For details, refer to the KFPA11424-E message. | -424 |
22027 | The length of the TRIM character is not one character. For details, refer to the KFPA11425-E message. | -425 |
2202F | The number of elements in the input data is greater than the maximum number of elements for a repetition column. For details, refer to the KFPA11302-E message. | -302 |
22501 | The number of elements in the input data does not match the number of elements in the array. For details, refer to the KFPA11302-E message. | -302 |
22503 | Refer to the KFPA11306-E message. | -306 |
22504 | Refer to the KFPA11310-E message. | -310 |
22505 | Data in the input variable contradicts the information specified in the embedded variable, parameter variable declaration, or SQL descriptor area. (If the input variable is variable-length data, the input variable length exceeds the maximum value or is less than 0). For details, refer to the KFPA11326-E message. | -326 |
22506 | Data in the input variable contradicts the information specified in the embedded variable, parameter variable declaration, or SQL descriptor area. (If the input variable is LOB data, the input variable length exceeds the maximum value or is less than 0). For details, refer to the KFPA11326-E message. | -326 |
22507 | Data in the input variable contradicts the information specified in the embedded variable, parameter variable declaration, or SQL descriptor area. (If the input variable is a repetition column, the current number of elements for the input variable exceeds the maximum number of elements or is less than 0). For details, refer to the KFPA11326-E message. | -326 |
22508 | Refer to the KFPA11170-E message. | -170 |
22509 | Refer to the KFPA11223-E message. | -223 |
2250G | One of the following errors is present:
| -360 -361 -362 |
2250J | Refer to the KFPA11316-E message. | -316 |
22510 | Refer to the KFPA11381-E message. | -381 |
22511 | Refer to the KFPA11430-E message. | -430 |
22512 | Refer to the KFPA11993-E message. | -993 |
22513 | Refer to the KFPA19183-E message. | -1183 |
22514 | Refer to the KFPA19320-E message. | -1320 |
22515 | Refer to the KFPA19325-E message. | -1325 |
22516 | Refer to the KFPA19801-E message. | -1801 |
22520 | A key value cannot be generated for the data type from the substructure value specified in the definition of substructure index. For details, refer to the KFPA19311-E message. | -1311 |
22521 | Refer to the KFPA19346-E message. | -1346 |
22522 | Refer to the KFPA19347-E message. | -1347 |
22523 | Refer to the KFPA19348-E message. | -1348 |
22524 | Refer to the KFPA19349-E message. | -1349 |
22525 | Refer to the KFPA19350-E message. | -1350 |
22526 | Refer to the KFPA19351-E message. | -1351 |
22527 | Refer to the KFPA19352-E message. | -1352 |
22528 | Refer to the KFPA19353-E message. | -1353 |
22529 | Refer to the KFPA19354-E message. | -1354 |
Table 8-12 SQLSTATE class 23
SQLSTATE | Explanation | SQLCODE |
---|---|---|
23001 | A RESTRICT violation occurred. For details, refer to the KFPA11451-E message. | -451 |
23502 | A NOT NULL constraint violation occurred. For details, refer to the KFPA11210-E message. | -210 |
23503 | A violation of a referential constraint occurred. Refer to the KFPA11451-E message. | -451 |
23505 | One of the following errors is present:
| -603 -803 |
23506 | Refer to the KFPA19582-E message. | -1582 |
23507 | Refer to the KFPA19717-E message. | -1717 |
23514 | A violation of a check constraint occurred. For details, refer to the KFPA11451-E message. | -451 |
Table 8-13 SQLSTATE class 24
SQLSTATE | Explanation | SQLCODE |
---|---|---|
24000 | This cursor cannot be used to update or delete rows due to one of the following errors:
| -330 -332 |
24501 | Refer to the KFPA11500-E message. | -500 |
24502 | Refer to the KFPA11711-E message. | -711 |
24504 | Refer to the KFPA11501-E message. | -501 |
24505 | Refer to the KFPA11502-E message. | -502 |
24506 | Refer to the KFPA11505-E message. | -505 |
24507 | Refer to the KFPA11994-E message. | -994 |
24509 | Refer to the KFPA19508-E message. | -1508 |
24510 | Refer to the KFPA19509-E message. | -1509 |
Table 8-14 SQLSTATE class 25
SQLSTATE | Explanation | SQLCODE |
---|---|---|
25501 | Refer to the KFPA11980-E message. | -980 |
25502 | Refer to the KFPA11998-E message. | -998 |
25503 | Refer to the KFPA19703-E message. | -1703 |
Table 8-15 SQLSTATE class 26
SQLSTATE | Explanation | SQLCODE |
---|---|---|
26000 | Refer to the KFPA11512-E message. | -512 |
Table 8-16 SQLSTATE class 28
SQLSTATE | Explanation | SQLCODE |
---|---|---|
28501 | Refer to the KFPA11560-E message. | -560 |
28502 | Refer to the KFPA11561-E message. | -561 |
Table 8-17 SQLSTATE class 2C
SQLSTATE | Explanation | SQLCODE |
---|---|---|
2C000 | Refer to the KFPA19104-E message. | -1104 |
Table 8-18 SQLSTATE class 2F
SQLSTATE | Explanation | SQLCODE |
---|---|---|
2F002 | Refer to the KFPA11495-E message. | -495 |
Table 8-19 SQLSTATE class 33
SQLSTATE | Explanation | SQLCODE |
---|---|---|
33501 | Refer to the KFPA19506-E message. | -1506 |
33502 | Refer to the KFPA19507-E message. | -1507 |
Table 8-20 SQLSTATE class 34
SQLSTATE | Explanation | SQLCODE |
---|---|---|
34501 | Refer to the KFPA11233-E message. | -233 |
Table 8-21 SQLSTATE class 37
SQLSTATE | Explanation | SQLCODE |
---|---|---|
37901 | Refer to the KFPA11331-E message. | -331 |
Table 8-22 SQLSTATE class 38
SQLSTATE | Explanation | SQLCODE |
---|---|---|
38501 | Refer to the KFPA11245-E message. | -245 |
38502 | Refer to the KFPA11246-E message. | -246 |
38503 | Refer to the KFPA11247-E message. | -247 |
38504 | Refer to the KFPA11248-E message. | -248 |
38507 | Refer to the KFPA19335-E message. | -1335 |
38508 | Refer to the KFPA19336-E message. | -1336 |
Table 8-23 SQLSTATE class 40
SQLSTATE | Explanation | SQLCODE |
---|---|---|
40000 | Refer to the KFPA11716-E message. | -716 |
40001 | Serialization failed due to one of the following causes:
| -770 -911 |
40501 | Refer to the KFPA11713-E message. | -713 |
40503 | Refer to the KFPA11756-E message. | -756 |
40505 | Refer to the KFPA11806-E message. | -806 |
40506 | Refer to the KFPA11809-I message. | -809 |
40507 | Refer to the KFPA11822-E message. | -822 |
40508 | Refer to the KFPA11879-E message. | -879 |
40509 | Refer to the KFPA11487-E message. | -487 |
4050F | Refer to the KFPA11912-E message. | -912 |
4050G | Refer to the KFPA11913-E message. | -913 |
4050N | Refer to the KFPA11931-E message. | -931 |
4050I | Refer to the KFPA11925-E message. | -925 |
4050K | Refer to the KFPA11927-E message. | -927 |
4050L | Refer to the KFPA19940-E message. | -1940 |
4050M | Refer to the KFPA19941-E message. | -1941 |
40510 | Refer to the KFPA11488-E message. | -488 |
40511 | Refer to the KFPA11489-E message. | -489 |
40512 | Refer to the KFPA11490-E message. | -490 |
40513 | Refer to the KFPA11494-E message. | -494 |
40514 | Refer to the KFPA11530-E message. | -530 |
40515 | Refer to the KFPA11595-E message. | -595 |
40516 | Refer to the KFPA11740-E message. | -740 |
40517 | Refer to the KFPA11797-E message. | -797 |
40518 | Refer to the KFPA11808-E message. | -808 |
40519 | Refer to the KFPA11828-E message. | -828 |
40520 | Refer to the KFPA11876-E message. | -876 |
40521 | Refer to the KFPA11877-E message. | -877 |
40522 | Refer to the KFPA11878-E message. | -878 |
40523 | Refer to the KFPA11886-E message. | -886 |
40525 | Refer to the KFPA11892-E message. | -892 |
40526 | Refer to the KFPA11945-E message. | -945 |
40527 | Refer to the KFPA11958-E message. | -958 |
40528 | Refer to the KFPA11959-E message. | -959 |
40529 | Refer to the KFPA11981-E message. | -981 |
40530 | Refer to the KFPA11986-E message. | -986 |
40531 | Refer to the KFPA11989-E message. | -989 |
40532 | Refer to the KFPA11992-E message. | -992 |
40533 | Refer to the KFPA19311-E message. | -1311 |
40534 | Refer to the KFPA19313-E message. | -1313 |
40535 | Refer to the KFPA19400-E message. | -1400 |
40537 | Refer to the KFPA19455-E message | -1455 |
40538 | Refer to the KFPA19703-E message. | -1703 |
40539 | Refer to the KFPA19716-E message. | -1716 |
40540 | Refer to the KFPA19633-E message. | -1633 |
40541 | Refer to the KFPA11898-E message. | -898 |
40542 | The following SQL statements cannot be executed on a shared table unless the LOCK statement with IN EXCLUSIVE MODE specified is executed:
| -296 |
40543 | Refer to the KFPA19713-E message. | -1713 |
40544 | Refer to the KFPA19721-E message. | -1721 |
40601 | Refer to the KFPA11917-E message. | -917 |
40602 | Refer to the KFPA11918-E message. | -918 |
40603 | Refer to the KFPA11891-E message. | -891 |
40620 | Refer to the KFPA11920-E message. | -920 |
40621 | Refer to the KFPA11928-I message. | -928 |
40622 | Refer to the KFPA19701-E message. | -1701 |
40623 | Refer to the KFPA19702-E message. | -1702 |
40701 | Refer to the KFPA11934-E message. | -934 |
40702 | Refer to the KFPA11953-E message. | -953 |
40703 | Refer to the KFPA11342-E message. | -342 |
40A01 | The transaction rolled back due to an integrity error in the dictionary. For details, refer to the message corresponding to the SQLCODE. | -- |
40A02 | The transaction rolled back due to a basic unit error in SQL. For details, refer to the message corresponding to the SQLCODE. | -- |
40B01 | The transaction rolled back due to a list processing error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B02 | The transaction rolled back due to an index processing error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B03 | The transaction rolled back due to an inner replica error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B04 | The transaction rolled back due to a cursor processing error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B05 | The transaction rolled back due to a transaction error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B08 | The transaction rolled back due to a resource release failure. For details, refer to the message corresponding to the SQLCODE. | -- |
40B09 | The transaction rolled back due to a routine processing error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B10 | The transaction rolled back due to a privilege manipulation error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B11 | The transaction rolled back due to an update processing error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B12 | The transaction rolled back due to a constraint processing error. For details, refer to the message corresponding to SQLCODE. | -- |
40B13 | The transaction rolled back due to a preprocessing error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B14 | The transaction rolled back due to an intermediate result acquisition failure. For details, refer to the message corresponding to the SQLCODE. | -- |
40B15 | The transaction rolled back due to an abstract data type error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B16 | The transaction rolled back due to a communication processing error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B17 | The transaction rolled back due to a lock error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B18 | The transaction rolled back due to an array processing error. For details, refer to the message corresponding to the SQLCODE. | -- |
40B19 | The transaction rolled back due to a memory allocation failure. For details, refer to the message corresponding to the SQLCODE. | -- |
40B20 | The transaction rolled back due to an embedded language syntax error. For details, refer to the message corresponding to the SQLCODE. | -- |
40C01 | The transaction rolled back due to an error in the definition SQL. For details, refer to the message corresponding to the SQLCODE. | -- |
40C02 | The transaction rolled back because there is already a resource to be defined. For details, refer to the KFPA11601-E message. | -601 |
40C03 | One of the following errors is present:
| -204 -529 -624 |
40C04 | One of the following errors is present:
| -204 -224 -529 -624 -660 |
40C05 | One of the following errors is present:
| -204 -224 -529 -624 -656 -721 -909 -1633 |
40C06 | The transaction rolled back because the same index was already defined during a CREATE INDEX operation. For details, refer to the KFPA11601-E message. | -601 |
40C07 | One of the following errors is present:
| -601 -664 -721 -908 -1633 |
40C08 | One of the following errors is present:
| -548 -551 -552 -573 -579 -607 -656 -905 -1633 |
40D01 | Refer to the KFPA11940-E message. | -940 |
40D10 | Refer to the KFPA19451-E message. | -1451 |
40D30 | Refer to the KFPA11948-E message. | -948 |
40D31 | Refer to the KFPA11950-E message. | -950 |
40D50 | Refer to the KFPA11404-E message. | -404 |
40D51 | Refer to the KFPA11801-E message. | -801 |
40D52 | Refer to the KFPA11223-E message. | -223 |
40D53 | Refer to the KFPA11321-E message. | -321 |
40D70 | Refer to the KFPA11210-E message. | -210 |
40D71 | Refer to the KFPA11603-E message. | -603 |
40D72 | Refer to the KFPA11451-E message. | -451 |
40D73 | One of the following errors is present:
| -451 -1582 |
40D90 | Refer to the KFPA11996-E message. | -996 |
40DB0 | Refer to the KFPA11492-E message. | -492 |
40DB1 | Refer to the KFPA11493-E message. | -493 |
40DD0 | Refer to the KFPA11204-E message. | -204 |
40DD1 | Refer to the KFPA11224-E message. | -224 |
40DD2 | Refer to the KFPA11101-E message. | -101 |
40DD3 | There is no column in a WITH clause or correlation name query of a table or of a derived table in the FROM clause. For details, refer to the KFPA11205-E message. | -205 |
40DD4 | Refer to the KFPA19727-E message. | -1727 |
40DH0 | Refer to the KFPA11206-E message. | -206 |
40DH1 | Refer to the KFPA11601-E message. | -601 |
40DH2 | Refer to the KFPA11656-E message. | -656 |
40DH3 | Refer to the KFPA11660-E message. | -660 |
40DH4 | Refer to the KFPA11664-E message. | -664 |
40DH5 | Refer to the KFPA11743-E message. | -743 |
40DH6 | Refer to the KFPA11744-E message. | -744 |
40DH7 | Refer to the KFPA11749-E message. | -749 |
40DH8 | Refer to the KFPA11741-E message. | -741 |
40DH9 | Refer to the KFPA11624-E message. | -624 |
40DHA | Refer to the KFPA11893-E message. | -893 |
40DHB | Refer to the KFPA11894-E message. | -894 |
40DHC | CLUSTER KEY, PRIMARY KEY, or PRIMARY CLUSTER KEY is not defined for the table. For details, refer to the KFPA11207-E message. | -207 |
40DHD | The specified data type does not have the specified attribute. For details, refer to the KFPA11228-E message. | -228 |
40DHE | PUBLIC, MASTER, HiRDB, or ALL is specified for the authorization identifier. For details, refer to the KFPA11549-E message. | -549 |
40DHF | One of the following errors is present:
| -574 |
40DHG | A plug-in index cannot be applied to routines. A plug-in index can be applied to a plug-in function that has been implemented by a plug-in and for which SCAN TYPE is specified as the operation qualifier of the plug-in IDL. For details, refer to the KFPA11583-E message. | -583 |
40DHH | The column specified as an index is not appropriate for the index type. For details, refer to the KFPA11584-E message. | -584 |
40DHI | NULL cannot be specified in the column definition for a table with FIX specified. For details, refer to the KFPA11591-E message. | -591 |
40DHJ | NULL cannot be specified in the column definition for a column for which a single column uniqueness constraint definition or a multicolumn uniqueness constraint definition is defined. For details, refer to the KFPA11592-E message. | -592 |
40DHK | ALTER TABLE cannot delete a column for which BLOB or abstract is specified as its data type. For details, refer to the KFPA11597-E message. | -597 |
40DHL | Another plug-in index has already been applied to the routine. For details, refer to the KFPA11600-E message. | -600 |
40DHM | The total number of columns per table has already exceeded the permitted maximum value (30,000). For details, refer to the KFPA11602-E message. | -602 |
40DHN | SUPPRESS cannot be specified for a table with the FIX attribute. For details, refer to the KFPA11605-E message. | -605 |
40DHP | Neither a variable-length column, nor a column with a user-defined type, nor a repetition column can be defined for a table with the FIX attribute. For details, refer to the KFPA11609-E message. | -609 |
40DHQ | Because this is not a hash row-partitioned table, the hash function cannot be renamed nor can an RDAREA be added. For details, refer to the KFPA11611-E message. | -611 |
40DHR | The same column name cannot be defined more than once for the same table. For details, refer to the KFPA11612-E message. | -612 |
40DHT | A FLOAT or SMALLFLT type column cannot be specified for a multicolumn index, multicolumn primary key, or multicolumn cluster key. For details, refer to the KFPA11615-E message. | -615 |
40DHU | The column name or the column name constituting a primary key or cluster key specified in CREATE INDEX is duplicated. For details, refer to the KFPA11619-E message. | -619 |
40DHV | Neither UNIQUE nor PRIMARY KEY can be specified for a flexible hash-partitioned table or a matrix partitioning table using flexible hash partitioning. For details, refer to the KFPA11620-E message. | -620 |
40DHW | An index with UNIQUE specified cannot be defined for a repetition column. For details, refer to the KFPA11621-E message. | -621 |
40DHX | One of the following errors is present with regard to the hash function name:
| -622 |
40DHY | The following table restriction definitions cannot be specified for a repetition column:
| -625 |
40DHZ | When a table is defined or a table definition is changed, neither a NOT NULL constraint nor a character set can be specified for a repetition column. For details, refer to the KFPA11628-E message. | -628 |
40DI0 | If the column type is not abstract data, neither change nor drop processing can be performed on the column. If the column type is abstract data, neither change nor drop processing can be performed on the table that contains the column. The column types are as follows:
| -631 |
40DI1 | The column cannot be deleted because it is the only column in the table. For details, refer to the KFPA11632-E message. | -632 |
40DI2 | The storage condition column, boundary-value partitioning column, or hash partitioning key column does not have the NOT NULL constraint. For details, refer to the KFPA11633-E message. | -633 |
40DI3 | ALL cannot be used for a table identifier. For details, refer to the KFPA11658-E message. | -658 |
40DI4 | The data type and data length specified in the CHANGE clause are invalid. For details, refer to the KFPA11659-E message. | -659 |
40DI5 | The index has already been defined in HiRDB. For details, refer to the KFPA11661-E message. | -661 |
40DI6 | The information specified in the CHANGE clause in ALTER TABLE (maximum number of elements in the repetition column, data type, data length, default value (WITH DEFAULT, SET DEFAULT clause, or DROP DEFAULT clause), or variable-length character string data storage method) is the same as before the change. For details, refer to the KFPA11665-E message. | -665 |
40DI7 | The maximum number of elements specified in the CHANGE clause in ALTER TABLE contains one of the following errors:
| -667 |
40DI8 | A referenced table for a reference constraint cannot be deleted. For details, refer to the KFPA11690-E message. | -690 |
40DI9 | A cluster key clause cannot be specified together with a primary key clause for the same column structure. For details, refer to the KFPA11693-E message. | -693 |
40DIA | When the attribute of a cluster key was changed, one of the following errors occurred:
| -694 |
40DIB | When a table is defined or a table definition is changed, WITH DEFAULT cannot be specified for a column without the NOT NULL constraint. For details, refer to the KFPA11697-E message. | -697 |
40DIC | NOT NULL cannot be specified for a column configured for the abstract data type. For details, refer to the KFPA11698-E message. | -698 |
40DID | WITH DEFAULT has already been specified for the column. For details, refer to the KFPA11699-E message. | -699 |
40DIF | An index with UNIQUE specified cannot be defined for one of the following reasons:
| -702 |
40DIG | Neither BLOB nor BINARY can be specified as the data type for a table with the FIX attribute, nor can any character set be specified for an attribute name in a type definition. For details, refer to the KFPA11704-E message. | -704 |
40DIH | The PCTFREE or SEGMENT REUSE option value exceeds the maximum value in CREATE TABLE, CREATE INDEX, or ALTER TABLE. For details, refer to the KFPA11705-E message. | -705 |
40DII | The name of an attribute that constitutes a single data type must be unique in all abstract data types that have inheritance relationships. For details, refer to the KFPA11712-E message. | -712 |
40DIJ | The table or column cannot be renamed for one of the following reasons:
| -717 |
40DIK | The definition for column data control contains one of the following errors:
| -718 |
40DIN | None of the following columns can be specified for a partitioning key:
| -745 |
40DIO | The condition value for the storage condition specified for a column contains one of the following errors:
| -746 |
40DIP | The storage condition specified for a partitioning key contains one of the following errors:
| -747 |
40DIQ | The ALLOCATE clause specified for a column is invalid. For details, refer to the KFPA11750-E message. | -750 |
40DIR | The option specified for a column is invalid. For details, refer to the KFPA11753-E message. | -753 |
40DIS | A duplicate routine name is specified in the FOR clause in CREATE INDEX. For details, refer to the KFPA11754-E message. | -754 |
40DIT | The specified exceptional key value for the index contains one of the following errors:
| -758 |
40DIU | That SQL statement cannot be executed because the plug-in has not been registered. For details, refer to the KFPA11761-E message. | -761 |
40DIV | The number of columns constituting the index does not match the number of values constituting the exceptional key value. For details, refer to the KFPA11764-E message. | -764 |
40DIW | One of the following errors is present:
| -766 |
40DIX | The specified function cannot be defined because it has the same name and the same SQL parameter structure as a system-provided function. For details, refer to the KFPA11775-E message. | -775 |
40DIY | There is an error in the number of RDAREAs specified for the index. For details, refer to the KFPA11791-E message. | -791 |
40DIZ | The RDAREA in the index definition with partitioning specified does not correspond to the RDAREA for the boundary value-partitioned or hash row-partitioned table. For details, refer to the KFPA11793-E message. | -793 |
40DJ0 | The DEFAULT clause is invalid at one of the following locations:
| -798 |
40DJ1 | The audit event specified in CREATE AUDIT has already been defined. For details, refer to the KFPA11908-E message. | -908 |
40DJ2 | The audit event specified in DROP AUDIT is not defined. For details, refer to the KFPA11909-E message. | -909 |
40DJ3 | The total length of attributes defined with abstract data types is too large. For details, refer to the KFPA11939-E message. | -939 |
40DJ4 | There is an error in the shared table or shared index definition. For details, refer to the KFPA19575-E message. | -1575 |
40DJ5 | There is an error in the reference constraint definition or check constraint definition. For details, refer to the KFPA19581-E message. | -1581 |
40DJ6 | In a reference constraint, the primary key of the same referenced table cannot be referenced from the same set of columns (the order might not be the same). For details, refer to the KFPA19602-E message. | -1602 |
40DJ7 | The column cannot be changed for one of the following reasons:
| -1603 |
40DJ8 | The specified matrix partitioning table is invalid. For details, refer to the KFPA19612-E message. | -1612 |
40DJ9 | A definition SQL statement cannot be executed on a falsification prevented table that stores data. For details, refer to the KFPA19615-E message. | -1615 |
40DJA | The insert history maintenance column specified in the deletion prevented duration for a falsification prevented table cannot be deleted. For details, refer to the KFPA19616-E message. | -1616 |
40DJB | Only a column of DATE type with SYSTEM GENERATED specified can be specified for the insert history maintenance column of a falsification prevented table. For details, refer to the KFPA19617-E message. | -1617 |
40DJC | The deletion prevented duration specified for a falsification prevented table is invalid. For details, refer to the KFPA19620-E message. | -1620 |
40DJD | There is an error in the specified ALTER TABLE CHANGE RDAREA. For details, refer to the KFPA19625-E message. | -1625 |
40DJH | A sequence generator cannot be created. For details, refer to the KFPA19624-E message. | -1624 |
40DJI | The table cannot be set to be expanded to or released from the memory database. For details, refer to the KFPA19864-E message. | -1864 |
40DJJ | The definition SQL statement cannot be executed because this table is to be expanded to the memory database. For details, refer to the KFPA19865-E message. | -1865 |
40DJK | There is an error in the definition of a temporary table or temporary table index. For details, refer to the KFPA19621-E or KFPA19622-E message. | -1621 -1622 |
40DJL | Refer to the KFPA19604-E message. | -1604 |
40DJM | There is an error specifying a reserved column definition, or adding, dropping, or excising a column. For details, refer to the following messages:
| -626 -632 -681 -682 -683 -684 -695 -696 |
40DJN | ALTER TABLE cannot be executed. For details, refer to the KFPA19613-E message. | -1613 |
40DJO | ALTER TABLE cannot change the table definition due to the free space reusage facility. For details, refer to the KFPA11751-E message. | -751 |
40DL0 | Refer to the KFPA11552-E message. | -552 |
40DL1 | Refer to the KFPA11559-E message. | -559 |
40DL2 | Refer to the KFPA11576-E message. | -576 |
40DL3 | Refer to the KFPA11577-E message. | -577 |
40DL4 | Refer to the KFPA11578-E message. | -578 |
40DL5 | Refer to the KFPA11579-E message. | -579 |
40DL6 | Refer to the KFPA11580-E message. | -580 |
40DL7 | Refer to the KFPA11562-E message. | -562 |
40DL8 | Refer to the KFPA19683-E message. | -1683 |
40DL9 | Refer to the KFPA11571-E message. | -571 |
40DLA | Refer to the KFPA11903-E message. | -903 |
40DLB | Refer to the KFPA11905-E message. | -905 |
40DLC | One of the following errors is present:
| -548 |
40DLD | Because the executor is not the owner of the table, the executor cannot execute the SQL statement or grant another user a privilege that the executor does not have. For details, refer to the KFPA11551-E message. | -551 |
40DLE | The user cannot grant a privilege to him/herself. For details, refer to the KFPA11554-E message. | -554 |
40DLF | The user cannot revoke his/her own privilege. For details, refer to the KFPA11555-E message. | -555 |
40DLG | The list of authorization identifiers specified in the GRANT statement (defining privileges) or the REVOKE statement (revoking privileges) contains the table owner's authorization identifier. For details, refer to the KFPA11556-E message. | -556 |
40DLH | One or more ofhe following cannot be executed:
| -607 |
40DLJ | The following SQL statements cannot be executed because the rebalancing utility is executing:
| -823 |
40DLK | The INSERT, UPDATE, and DELETE privileges for an audit trail table or a viewed table based on the audit trail table cannot be granted to a user who is not the auditor. For details, refer to the KFPA11902-E message. | -902 |
40DLL | Usage privileges for an RDAREA storing an audit trail table cannot be granted to a user who is not the auditor. For details, refer to the KFPA11904-E message. | -904 |
40DLM | The auditor's schema cannot be deleted because there is an audit trail table. For details, refer to the KFPA11906-E message. | -906 |
40DLN | The auditor's schema definition privileges and CONNECT privileges cannot be revoked. For details, refer to the KFPA11907-E message. | -907 |
40DLO | An error occurred in a definition related to a falsification prevented table. For details, refer to the KFPA19631-E message. | -1631 |
40DLP | The GRANT statement could not be executed due to one of the following password violations: Minimum length in bytes, prohibition of authorization identifier specification, prohibition of specification in a single character type For details, refer to the KFPA19634-E message. | -1634 |
40DLQ | The GRANT DBA statement cannot be used to grant DBA privileges or change the password, due to the password-invalid account lock state. For details, refer to the KFPA19635-E message. | -1635 |
40DLR | In the audit event definition, a combination of operation type, event type, and other operands is invalid. For details, refer to the KFPA19680-E message. | -1680 |
40DLS | The specified privilege cannot be granted or revoked. For details, refer to the KFPA19610-E message. | -1610 |
40DN0 | Refer to the KFPA11307-E message. | -307 |
40DN1 | Refer to the KFPA11209-E message. | -209 |
40DP0 | Refer to the KFPA11787-E message. | -787 |
40DR0 | No new update transaction is accepted while both-system operation is being restored. For details, refer to the KFPA19726-E message. | -1726 |
40DT0 | Refer to the KFPA11692-E message. | -692 |
40DT1 | Refer to the KFPA11777-E message. | -777 |
40DT2 | Refer to the KFPA11930-E message. | -930 |
40DT3 | Refer to the KFPA11929-E message. | -929 |
40DT4 | Refer to the KFPA11811-E message. | -811 |
40DT5 | Refer to the KFPA11814-E message. | -814 |
40DT6 | Refer to the KFPA19718-E message. | -1718 |
40DT7 | Refer to the KFPA11919-E message. | -919 |
40DT8 | Refer to the KFPA11531-E message. | -531 |
40DT9 | Refer to the KFPA19705-E message. | -1705 |
40DTA | Because the data dictionary LOB RDAREA is not defined, the following SQL statements cannot be executed:
| -596 |
40DTB | None of the following operations can be executed on a table containing data:
| -613 |
40DTC | Because the specified RDAREA is a shared RDAREA, none of the following operations can be performed:
| -1576 |
40DTD | There is a shortage of shared memory for locking. For details, refer to the KFPA11914-E message. | -914 |
40DTE | The resource cannot be accessed because one of the following resources is in use by a definition SQL statement or utility:
| -1670 -1671 |
40DTG | Refer to the KFPA19724-E message. | -1724 |
40DTH | Refer to the KFPA19725-E message. | -1725 |
40DX0 | Refer to the KFPA11812-E message. | -812 |
40DX1 | Refer to the KFPA11657-E message. | -657 |
40DX2 | Refer to the KFPA11827-E message. | -827 |
40DX3 | Refer to the KFPA11952-E message. | -952 |
40DX4 | Refer to the KFPA19706-E message. | -1706 |
40DX5 | The key length of an index exceeds the maximum value. For details, refer to the KFPA11616-E message. | -616 |
40DX6 | The number of partitions exceeds the system limit (1,024 for a rebalancing table, 4,096 otherwise). Alternatively, the number of RDAREA names specified for storage exceeds the system limit (4,096). For details, refer to the KFPA11634-E message. | -634 |
40DX7 | The number of tables in an RDAREA, the total number of sequence generators, or the number of indexes exceeds the permitted maximum value. For details, refer to the KFPA11654-E message. | -654 |
40DX8 | changedata length or add rdarea cannot be executed because the key length of an index exceeds the permitted maximum value. For details, refer to the KFPA11662-E message. | -662 |
40DX9 | A single table cannot be partitioned and defined in 4,097 or more back-end servers. For details, refer to the KFPA11703-E message. | -703 |
40DXA | The number of indexes specified for a single table exceeds the maximum value (255). For details, refer to the KFPA11706-E message. | -706 |
40DXB | The ADT LEVEL value (number of generations of abstract data type) exceeds 30,000, which is the maximum value permitted for the system. For details, refer to the KFPA11714-E message. | -714 |
40DXC | The number of foreign keys referencing the primary key of a referenced table exceeds the maximum value (255). For details, refer to the KFPA11748-E message. | -748 |
40DXD | The number of RDAREAs with duplicates excluded that can be specified when a table or index is partitioned exceeds the maximum value. For details, refer to the KFPA11795-E message. | -795 |
40DXE | The number of foreign keys that can be specified for a single table exceeds the maximum value (255). For details, refer to the KFPA19583-E message. | -1583 |
40DXF | The check constraint cannot be defined because the number of check constraints defined for the table (total number of Boolean operators specified in the check constraint search condition (number of ANDs and ORs excluding the ANDs and ORs in the WHEN search condition in the CASE expression) and the total number of check constraints) exceeds the maximum value (254). For details, refer to the KFPA19584-E message. | -1584 |
40E01 | Refer to the KFPA11528-E message. | -528 |
40E02 | Refer to the KFPA11529-E message. | -529 |
40E03 | Refer to the KFPA11537-E message. | -537 |
40E20 | Refer to the KFPA11652-E message. | -652 |
40E21 | Refer to the KFPA11653-E message. | -653 |
40E22 | Refer to the KFPA11358-E message. | -358 |
40E23 | Refer to the KFPA11511-E message. | -511 |
40E24 | Refer to the KFPA11737-E message. | -737 |
40E25 | Refer to the KFPA11738-E message. | -738 |
40E26 | Refer to the KFPA11815-E message. | -815 |
40E27 | The table or index cannot be dropped or the table definition cannot be changed because a copied RDAREA is defined. For details, refer to the KFPA11513-E message. | -513 |
40E28 | The specified RDAREA is not a user LOB RDAREA. For details, refer to the KFPA11599-E message. | -599 |
40E29 | The user is not authorized to use the specified RDAREA. Therefore, the table, sequence generator, or index cannot be created. For details, refer to the KFPA11608-E message. | -608 |
40E2A | There is no available public user RDAREA. For details, refer to the KFPA11610-E message. | -610 |
40E2B | If the name of an RDAREA for a table is duplicated or an RDAREA for a table that is already in use for the target table is specified in ALTER TABLE ADD RDAREA, the specification for the RDAREA for the table does not match the specification for the following items:
| -707 |
40E2C | The specified LOB RDAREA is not on the same server as the RDAREA for the table. For details, refer to the KFPA11708-E message. | -708 |
40E2D | The specified LOB RDAREA is already in use for another table. For details, refer to the KFPA11709-E message. | -709 |
40E2E | The specified RDAREA for the index is not on the server that contains the RDAREA for the table. For details, refer to the KFPA11771-E message. | -771 |
40E2F | The same RDAREA as the immediately preceding RDAREA cannot be specified. For details, refer to the KFPA11796-E message. | -796 |
40E2G | The specified RDAREA contains one of the following errors:
| -845 |
40E2I | Refer to the KFPA19704-E message. | -1704 |
40E40 | Refer to the KFPA11431-E message. | -431 |
40E41 | Refer to the KFPA11897-E message. | -897 |
40E42 | Refer to the KFPA11964-E message. | -964 |
40E43 | No SQL statement other than ROLLBACK or DISCONNECT can be executed. For details, refer to the KFPA11987-E message. | -987 |
40E60 | Refer to the KFPA11810-E message. | -810 |
40E61 | One of the following errors is present:
| -875 -883 |
40E62 | Refer to the KFPA11882-E message. | -882 |
40E63 | Refer to the KFPA11884-E message. | -884 |
40E64 | Refer to the KFPA19523-E message. | -1523 |
Table 8-24 SQLSTATE class 42
SQLSTATE | Explanation | SQLCODE |
---|---|---|
42000 | One of the following errors is present:
| -639 -643 -644 -645 -646 -647 -648 -649 -669 -1198 -1522 |
42501 | The number of characters specified in the character string literal exceeds the permitted maximum value. For details, refer to the KFPA11102-E message. | -102 |
42502 | Refer to the KFPA11145-E message. | -145 |
42503 | The number of characters specified in the national character string literal or the number of characters in the result of a concatenation operation between national character string literals exceeds the permitted maximum value. For details, refer to the KFPA11104-E and KFPA11141-E messages. | -104 -141 |
42504 | The number of characters specified in the mixed character string literal exceeds the permitted maximum value. For details, refer to the KFPA11102-E and KFPA11140-E messages. | -102 -140 |
42505 | The character string literal is not complete. For details, refer to the KFPA11106-E message. | -106 |
42506 | The hexadecimal character string literal is not complete. For details, refer to the KFPA11106-E message. | -106 |
42507 | Refer to the KFPA11140-E message. | -140 |
42508 | The mixed character string literal is not complete. For details, refer to the KFPA11106-E message. | -106 |
42509 | Refer to the KFPA11144-E message. | -144 |
42510 | There are one or more characters that violate the syntax rules. For details, refer to the KFPA11104-E message. | -104 |
42511 | Refer to the KFPA11410-E message. | -410 |
42512 | Refer to the KFPA11103-E message. | -103 |
42513 | The value of the specified numeric literal falls beyond the permitted value range. For details, refer to the KFPA11405-E message. | -405 |
42514 | Refer to the KFPA11142-E message. | -142 |
42520 | Refer to the KFPA11107-E message. | -107 |
42529 | The authorization identifier is longer than 8 characters. For details, refer to the Refer to the KFPA11564-E message. | -564 |
42530 | The identifier does not begin with an alphabetic character, or the delimited identifier is not complete. For details, refer to the KFPA11104-E message. | -104 |
42539 | There is a syntax error in the authorization identifier. For details, refer to the KFPA11564-E message. | -564 |
42550 | Refer to the KFPA11418-E message. | -418 |
42551 | Refer to the KFPA11217-E message. | -217 |
42561 | There is an error in the left-hand operand of the NULL predicate. For details, refer to the KFPA11114-E message. | -114 |
42562 | There is an error in the left-hand operand of the LIKE predicate. For details, refer to the KFPA11114-E message. | -114 |
42563 | The XMLEXISTS predicate is specified outside the WHERE clause. For details, refer to the KFPA11114-E message. | -114 |
42570 | The UPDATE or DELETE statement using the cursor cannot be preprocessed by the PREPARE statement. For details, refer to the KFPA11157-E message. | -157 |
42572 | Refer to the KFPA11149-E message. | -149 |
42573 | Refer to the KFPA11164-E message. | -164 |
42580 | The subscript specified for a repetition column is invalid. For details, refer to the KFPA11186-E message. | -186 |
42581 | In the column definition in CREATE TABLE or ALTER TABLE, there is an error in the maximum number of elements or the number of elements specified for a repetition column. For details, refer to the KFPA11189-E message. | -189 |
42590 | Refer to the KFPA11604-E message. | -604 |
42591 | Refer to the KFPA11131-E message. | -131 |
425A0 | The number of specified embedded variables, parameters, ? parameters, SQL variables, and SQL parameters exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425A2 | Refer to the KFPA11139-E message. | -139 |
425A4 | The number of simple WHEN clauses or searched WHEN clauses and ELSE clauses specified in the CASE expression exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425A6 | The number of specified row value constructor elements exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425B0 | The number of tables specified in the query exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425B1 | The number of specified selection expressions exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425B2 | Refer to the KFPA11122-E message. | -122 |
425B3 | Refer to the KFPA11124-E message. | -124 |
425B4 | The number of column specifications in the FOR UPDATE clause exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425B5 | The number of specified insertion values exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425B6 | The number of columns to be inserted exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425B7 | The number of columns to be updated exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425B8 | The number of arguments specified in the arguments list exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425B9 | The number of table names specified in the LOCK statement exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425BB | The number of column names specified in the derived columns list exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425BC | The number of list names exceeds the permitted maximum value. For details, refer to the KFPA11773-E message. | -773 |
425C0 | Refer to the KFPA11602-E message. | -602 |
425C1 | The number of columns in the view columns list specified in the view definition exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425C2 | The number of foreign keys specified in the table definition or the number of foreign keys resulting from the addition made by altering the table definition exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425C3 | The number of predicates specified in a check constraint exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425C6 | The number of columns specified in the index definition exceeds the permitted maximum value. For details, refer to the KFPA11617-E message. | -617 |
425C7 | The number of tables specified in the index definition exceeds the permitted maximum value. For details, refer to the KFPA11617-E message. | -617 |
425C8 | The number of exception values specified in the index definition exceeds the permitted maximum value. For details, refer to the KFPA11617-E message. | -617 |
425C9 | The number of exception key values specified in the index definition exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
425CA | Refer to the KFPA11570-E message. | -570 |
425CB | Refer to the KFPA11585-E message. | -585 |
425CC | The number of columns for the primary key in CREATE TABLE exceeds the permitted maximum value. For details, refer to the KFPA11674-E message. | -674 |
425CD | The number of columns specified for multicolumn hash partitioning in CREATE TABLE exceeds the permitted maximum value. For details, refer to the KFPA11674-E message. | -674 |
425CE | The number of columns for the cluster key in CREATE TABLE exceeds the permitted maximum value. For details, refer to the KFPA11674-E message. | -674 |
425D0 | Refer to the KFPA11678-E message. | -678 |
425D3 | There is one of the following syntax errors in ALTER TABLE:
| -189 -676 |
425D4 | Refer to the KFPA11673-E message. | -673 |
425D5 | There is an error in the specified table options or index options. For details, refer to the KFPA11705-E message. | -705 |
425D7 | Refer to the KFPA11572-E message. | -572 |
425DP | Refer to the KFPA11136-E message. | -136 |
425E0 | Refer to the KFPA11633-E message. | -633 |
425L0 | Refer to the KFPA11778-E message. | -778 |
425L1 | Refer to the KFPA11781-E message. | -781 |
425L2 | Refer to the KFPA11782-E message. | -782 |
425L5 | Refer to the KFPA11191-E message. | -191 |
42601 | There is an excess character string at the end of the SQL statement, or the first keyword is invalid in the SQL statement. For details, refer to the KFPA11104-E message. | -104 |
42602 | Refer to the KFPA11105-E message. | -105 |
42603 | Refer to the KFPA11106-E message. | -106 |
42604 | Refer to the KFPA11116-E message. | -116 |
42605 | Refer to the KFPA11138-E message. | -138 |
42606 | Refer to the KFPA11173-E message. | -173 |
42607 | Refer to the KFPA11175-E message. | -175 |
42608 | Refer to the KFPA11289-E message. | -289 |
42609 | Refer to the KFPA11292-E message. | -292 |
42610 | Refer to the KFPA11355-E message. | -355 |
42611 | Refer to the KFPA11461-E message. | -461 |
42613 | Refer to the KFPA11508-E message. | -508 |
42614 | Refer to the KFPA11638-E message. | -638 |
42615 | Refer to the KFPA11641-E message. | -641 |
42618 | Refer to the KFPA19323-E message. | -1323 |
42619 | Refer to the KFPA19407-E message. | -1407 |
42620 | Refer to the KFPA19408-E message. | -1408 |
42621 | A column that is not the last column of the table was specified as a reserved column. For details, refer to the KFPA19106-E message. | -1106 |
42701 | The number of literals exceeds the permitted maximum value. For details, refer to the KFPA11102-E and KFPA11141-E messages. | -102 -141 |
42702 | Refer to the KFPA11161-E message. | -161 |
42703 | The value specified for a numeric literal falls beyond the permitted value range (this is an integer literal specified for a labeled duration). For details, refer to the KFPA11405-E message. | -405 |
42704 | Refer to the KFPA11128-E message. | -128 |
42710 | Refer to the KFPA11112-E message. | -112 |
42711 | Refer to the KFPA11113-E message. | -113 |
42712 | Refer to the KFPA11402-E message. | -402 |
42713 | Refer to the KFPA11403-E message. | -403 |
42714 | Refer to the KFPA11120-E message. | -120 |
42716 | Refer to the KFPA11127-E message. | -127 |
42720 | Refer to the KFPA11117-E message. | -117 |
42721 | Refer to the KFPA11195-E message. | -195 |
42722 | Refer to the KFPA11192-E message. | -192 |
42723 | Refer to the KFPA11650-E message. | -650 |
42730 | Refer to the KFPA11211-E message. | -211 |
42731 | Refer to the KFPA11121-E message. | -121 |
42732 | Refer to the KFPA11123-E message. | -123 |
42733 | Refer to the KFPA11458-E message. | -458 |
42734 | Refer to the KFPA11459-E message. | -459 |
42740 | One of the following errors is present:
| -201 -241 -251 |
42741 | Refer to the KFPA11204-E message. | -204 |
42742 | One of the following errors is present:
| -202 -205 -227 -242 -252 -255 -256 |
42743 | One of the following errors is present:
| -125 -208 |
42744 | One of the following errors is present:
| -203 -213 |
42745 | One of the following errors is present:
| -218 -220 |
42746 | Refer to the KFPA11119-E message. | -119 |
42747 | Refer to the KFPA11224-E message. | -224 |
42748 | Refer to the KFPA11260-E message. | -260 |
42749 | Refer to the KFPA11239-E message. | -239 |
42750 | Refer to the KFPA11214-E message. | -214 |
42751 | Refer to the KFPA11215-E message. | -215 |
42752 | Refer to the KFPA11216-E message. | -216 |
42754 | Refer to the KFPA11180-E message. | -180 |
42755 | One of the following errors is present:
| -181 -182 -183 |
42756 | Refer to the KFPA11184-E message. | -184 |
42757 | Refer to the KFPA11185-E message. | -185 |
42758 | Refer to the KFPA11186-E message. | -186 |
42759 | Refer to the KFPA11187-E message. | -187 |
4275A | Refer to the KFPA11188-E message. | -188 |
42760 | There is an error in the base table specification for the list to be created. For details, refer to the KFPA11773-E message. | -773 |
42762 | Refer to the KFPA11776-E message. | -776 |
42763 | Refer to the KFPA11783-E message. | -783 |
42770 | One of the following errors is present:
| -114 -417 |
42771 | Refer to the KFPA11419-E message. | -419 |
42772 | Refer to the KFPA11422-E message. | -422 |
42773 | Refer to the KFPA11428-E message. | -428 |
42774 | Refer to the KFPA11445-E message. | -445 |
42780 | One of the following errors is present:
| -413 -414 |
42781 | Refer to the KFPA11421-E message. | -421 |
42782 | There is an error in the operands specified in a scalar function. For details, refer to the KFPA11425-E message. | -425 |
42783 | Refer to the KFPA11427-E message. | -427 |
42784 | There is one of the following errors:
| -444 -448 |
42785 | There is an error in operands in the CAST specification. For details, refer to the KFPA11453-E message. | -453 |
42786 | Refer to the KFPA11177-E message. | -177 |
42787 | Refer to the KFPA11475-E message. | -475 |
42792 | One of the following errors is present:
| -155 -156 |
42793 | Refer to the KFPA11118-E message. | -118 |
42794 | Refer to the KFPA11148-E message. | -148 |
42795 | No RDAREA can be specified for the following tables:
| -1277 |
42796 | The RDAREA specification contains one of the following errors:
| -497 |
427A0 | Refer to the KFPA11101-E message. | -101 |
427A1 | Refer to the KFPA11196-E message. | -196 |
427A2 | Refer to the KFPA11137-E message. | -137 |
427B2 | Refer to the KFPA11194-E message. | -194 |
427B3 | Refer to the KFPA11677-E message. | -677 |
427C1 | Refer to the KFPA19290-E message. | -1290 |
427D0 | Refer to the KFPA11169-E message. | -169 |
427DA | Refer to the KFPA19203-E message. | -1203 |
427E0 | Refer to the KFPA11237-E message. | -237 |
427F0 | Refer to the KFPA11259-E message. | -259 |
427FA | Refer to the KFPA11262-E message. | -262 |
427FB | Refer to the KFPA11263-E message. | -263 |
42801 | One of the following errors is present:
| -401 -407 |
42802 | One of the following errors is present:
| -163 -406 -411 -412 -415 -426 -465 -409 |
42803 | Refer to the KFPA11408-E message. | -408 |
42804 | Refer to the KFPA11197-E message. | -197 |
42806 | One of the following errors is present:
| -446 -447 |
42807 | There is an error in the combination of the data type and data length resulting from a value expression, and the data type and data length obtained after conversion. For details, refer to the KFPA11453-E message. | -453 |
42809 | Refer to the KFPA11238-E message. | -238 |
4280B | Refer to the KFPA11236-E message. | -236 |
4280C | Refer to the KFPA11440-E message. | -440 |
4280E | Refer to the KFPA11468-E message. | -468 |
42810 | Refer to the KFPA11134-E message. | -134 |
42812 | The length of a long data item falls beyond the permitted value range. For details, refer to the KFPA11420-E message. | -420 |
42814 | Refer to the KFPA11441-E message. | -441 |
4281A | Refer to the KFPA11132-E message. | -132 |
42820 | Refer to the KFPA11548-E message. | -548 |
42830 | Refer to the KFPA11230-E message. | -230 |
42850 | One of the following errors is present:
| -467 -651 |
42851 | Refer to the KFPA11671-E message. | -671 |
42870 | Refer to the KFPA11670-E message. | -670 |
42871 | Refer to the KFPA11672-E message. | -672 |
428A0 | Refer to the KFPA11456-E message. | -456 |
428A1 | Refer to the KFPA11640-E message. | -640 |
428A2 | Refer to the KFPA11642-E message. | -642 |
428D1 | Refer to the KFPA19150-E message. | -1150 |
428D2 | Refer to the KFPA19617-E message. | -1617 |
428D3 | Refer to the KFPA19620-E message. | -1620 |
42907 | Refer to the KFPA11146-E message. | -146 |
42908 | Refer to the KFPA11162-E message. | -162 |
42909 | Refer to the KFPA11174-E message. | -174 |
42910 | Refer to the KFPA11231-E message. | -231 |
42911 | Refer to the KFPA11232-E message. | -232 |
42912 | Refer to the KFPA11234-E message. | -234 |
42913 | Refer to the KFPA11240-E message. | -240 |
42914 | Refer to the KFPA11158-E message. | -158 |
42915 | Refer to the KFPA11282-E message. | -282 |
42916 | Refer to the KFPA11283-E message. | -283 |
42917 | Refer to the KFPA11284-E message. | -284 |
42918 | Refer to the KFPA11285-E message. | -285 |
42919 | Refer to the KFPA11286-E message. | -286 |
42920 | Refer to the KFPA11287-E message. | -287 |
42921 | Refer to the KFPA11288-E message. | -288 |
42922 | Refer to the KFPA11291-E message. | -291 |
42924 | Refer to the KFPA11294-E message. | -294 |
42925 | Refer to the KFPA11295-E message. | -295 |
42927 | Refer to the KFPA11382-E message. | -382 |
42928 | Refer to the KFPA11442-E message. | -442 |
42929 | Refer to the KFPA11460-E message. | -460 |
42930 | Refer to the KFPA11565-E message. | -565 |
42931 | Refer to the KFPA11600-E message. | -600 |
42932 | Refer to the KFPA11724-E message. | -724 |
42933 | Refer to the KFPA11780-E message. | -780 |
42934 | Refer to the KFPA11824-E message. | -824 |
42937 | Refer to the KFPA19330-E message. | -1330 |
42938 | Refer to the KFPA19458-E message. | -1458 |
42939 | Refer to the KFPA19633-E message. | -1633 |
42941 | Refer to the KFPA11126-E message. | -126 |
42942 | Refer to the KFPA11133-E message. | -133 |
42943 | Refer to the KFPA11154-E message. | -154 |
42946 | Refer to the KFPA11168-E message. | -168 |
42947 | Refer to the KFPA11171-E message. | -171 |
42948 | Refer to the KFPA11172-E message. | -172 |
42949 | Refer to the KFPA11176-E message. | -176 |
42950 | Refer to the KFPA11179-E message. | -179 |
42951 | Refer to the KFPA11198-E message. | -198 |
42952 | Refer to the KFPA11228-E message. | -228 |
42953 | Refer to the KFPA11235-E message. | -235 |
42954 | Refer to the KFPA11243-E message. | -243 |
42955 | Refer to the KFPA11249-E message. | -249 |
42956 | Refer to the KFPA11254-E message. | -254 |
42958 | Refer to the KFPA11266-E message. | -266 |
42959 | Refer to the KFPA11267-E message. | -267 |
42960 | Refer to the KFPA11273-E message. | -273 |
42961 | Refer to the KFPA11274-E message. | -274 |
42962 | Refer to the KFPA11276-E message. | -276 |
42963 | Refer to the KFPA11277-E message. | -277 |
42964 | Refer to the KFPA11296-E message. | -296 |
42965 | Refer to the KFPA11299-E message. | -299 |
42966 | Refer to the KFPA11314-E message. | -314 |
42967 | Refer to the KFPA11351-E message. | -351 |
42968 | Refer to the KFPA11443-E message. | -443 |
42970 | Refer to the KFPA11462-E message. | -462 |
42971 | Refer to the KFPA11463-E message. | -463 |
42972 | Refer to the KFPA11470-E message. | -470 |
42973 | Refer to the KFPA11471-E message. | -471 |
42974 | Refer to the KFPA11472-E message. | -472 |
42975 | Refer to the KFPA11473-E message. | -473 |
42976 | Refer to the KFPA11474-E message. | -474 |
42978 | Refer to the KFPA11477-E message. | -477 |
42979 | Refer to the KFPA11479-E message. | -479 |
42980 | Refer to the KFPA11504-E message. | -504 |
42981 | Refer to the KFPA11583-E message. | -583 |
42983 | Refer to the KFPA11746-E message. | -746 |
42984 | Refer to the KFPA11750-E message. | -750 |
42985 | Refer to the KFPA11753-E message. | -753 |
42986 | Refer to the KFPA11774-E message. | -774 |
42987 | Refer to the KFPA11807-E message. | -807 |
42988 | Refer to the KFPA11829-E message. | -829 |
42989 | Refer to the KFPA11839-E message. | -839 |
429A2 | Refer to the KFPA19101-E message. | -1101 |
429A5 | Refer to the KFPA19110-E message. | -1110 |
429A6 | Refer to the KFPA19111-E message. | -1111 |
429A7 | Refer to the KFPA19130-E message. | -1130 |
429A8 | Refer to the KFPA19170-E message. | -1170 |
429A9 | Refer to the KFPA19180-E message. | -1180 |
429B0 | Refer to the KFPA19181-E message. | -1181 |
429B1 | Refer to the KFPA19182-E message. | -1182 |
429B2 | Refer to the KFPA19184-E message. | -1184 |
429B3 | Refer to the KFPA19185-E message. | -1185 |
429B4 | Refer to the KFPA19187-E message. | -1187 |
429B5 | Refer to the KFPA19188-E message. | -1188 |
429B6 | Refer to the KFPA19189-E message. | -1189 |
429B9 | Refer to the KFPA19212-E message. | -1212 |
429C0 | Refer to the KFPA19220-E message. | -1220 |
429C1 | Refer to the KFPA19221-E message. | -1221 |
429C2 | Refer to the KFPA19254-E message. | -1254 |
429C3 | Refer to the KFPA19270-E message. | -1270 |
429C4 | Refer to the KFPA19271-E message. | -1271 |
429C5 | Refer to the KFPA19272-E message. | -1272 |
429C6 | Refer to the KFPA19273-E message. | -1273 |
429C7 | Refer to the KFPA19274-E message. | -1274 |
429C8 | Refer to the KFPA19275-E message. | -1275 |
429C9 | Refer to the KFPA19291-E message. | -1291 |
429D0 | Refer to the KFPA19292-E message. | -1292 |
429D1 | Refer to the KFPA19295-E message. | -1295 |
429D2 | Refer to the KFPA19319-E message. | -1319 |
429D3 | Refer to the KFPA19321-E message. | -1321 |
429D4 | Refer to the KFPA19322-E message. | -1322 |
429D5 | Refer to the KFPA19324-E message. | -1324 |
429D6 | Refer to the KFPA19327-E message. | -1327 |
429D7 | Refer to the KFPA19328-E message. | -1328 |
429D8 | Refer to the KFPA19329-E message. | -1329 |
429D9 | Refer to the KFPA19405-E message. | -1405 |
429E0 | Refer to the KFPA19409-E message. | -1409 |
429E2 | Refer to the KFPA19452-E message. | -1452 |
429E3 | Refer to the KFPA19453-E message. | -1453 |
429E4 | Refer to the KFPA19454-E message. | -1454 |
429E5 | Refer to the KFPA19577-E message. | -1577 |
429E6 | The number of columns in INTO clauses specified in the SQL statement exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
429E7 | The number of java.sql.ResultSet[] in EXTERNAL NAME clauses specified in the SQL statement exceeds the permitted maximum value. For details, refer to the KFPA11129-E message. | -129 |
429E8 | Refer to the KFPA11188-E message. | -188 |
429E9 | Refer to the KFPA11553-E message. | -553 |
429F0 | Refer to the KFPA11836-E message. | -836 |
429F1 | Refer to the KFPA19105-E message. | -1105 |
429F2 | Refer to the KFPA19140-E message. | -1140 |
429F3 | Refer to the KFPA19171-E message. | -1171 |
429F4 | Refer to the KFPA19186-E message. | -1186 |
429F5 | Refer to the KFPA19406-E message. | -1406 |
429F6 | Refer to the KFPA19603-E message. | -1603 |
429F8 | Refer to the KFPA19318-E message. | -1318 |
429F9 | Defined information cannot be changed for the columns of the base table specified in the concatenation operation or scalar function in the view definition. For details, refer to the KFPA11716-E message. | -716 |
429FA | A function execution does not end with the RETURN statement. For details, refer to the KFPA11986-E message. | -986 |
42E28 | Refer to the KFPA11455-E message. | -455 |
42E29 | Refer to the KFPA19459-E message. | -1459 |
42I02 | Refer to the KFPA11207-E message. | -207 |
42I03 | Refer to the KFPA11432-E message. | -432 |
42I08 | One of the following errors is present:
| -549 -658 |
42I0A | Refer to the KFPA11766-E message. | -766 |
42I12 | Refer to the KFPA11574-E message. | -574 |
42I13 | Refer to the KFPA11601-E message. | -601 |
42I14 | Refer to the KFPA11609-E message. | -609 |
42I15 | Refer to the KFPA11612-E message. | -612 |
42I16 | Refer to the KFPA11614-E message. | -614 |
42I17 | Refer to the KFPA11615-E message. | -615 |
42I18 | Refer to the KFPA11619-E message. | -619 |
42I19 | Refer to the KFPA11621-E message. | -621 |
42I20 | Refer to the KFPA11625-E message. | -625 |
42I23 | Refer to the KFPA11628-E message. | -628 |
42I24 | Refer to the KFPA11631-E message. | -631 |
42I25 | Refer to the KFPA11632-E message. | -632 |
42I26 | Refer to the KFPA11656-E message. | -656 |
42I27 | Refer to the KFPA11659-E message. | -659 |
42I29 | Refer to the KFPA11661-E message. | -661 |
42I30 | Refer to the KFPA11664-E message. | -664 |
42I31 | One of the following errors is present:
| -665 -699 |
42I32 | Refer to the KFPA11667-E message. | -667 |
42I37 | Tables cannot be defined with only reserved columns. For details, refer to the KFPA11685-E message. | -685 |
42I41 | Refer to the KFPA11690-E message. | -690 |
42I42 | Refer to the KFPA11693-E message. | -693 |
42I43 | Refer to the KFPA11694-E message. | -694 |
42I46 | Refer to the KFPA11697-E message. | -697 |
42I47 | Refer to the KFPA11698-E message. | -698 |
42I54 | Refer to the KFPA11743-E message. | -743 |
42I55 | Refer to the KFPA11744-E message. | -744 |
42I56 | Refer to the KFPA11745-E message. | -745 |
42I58 | Refer to the KFPA11747-E message. | -747 |
42I60 | Refer to the KFPA11758-E message. | -758 |
42I65 | Refer to the KFPA11764-E message. | -764 |
42I68 | Refer to the KFPA11791-E message. | -791 |
42I70 | Refer to the KFPA11793-E message. | -793 |
42I77 | Refer to the KFPA19602-E message. | -1602 |
42I79 | Refer to the KFPA11741-E message. | -741 |
42I80 | Refer to the KFPA11775-E message. | -775 |
42I82 | Refer to the KFPA11712-E message. | -712 |
42I86 | Refer to the KFPA19612-E message. | -1612 |
42I88 | Refer to the KFPA11591-E message. | -591 |
42I89 | Refer to the KFPA11592-E message. | -592 |
42I90 | Refer to the KFPA11165-E message. | -165 |
42I93 | Refer to the KFPA11478-E message. | -478 |
42I9A | Refer to the KFPA19615-E message. | -1615 |
42I9B | Refer to the KFPA19616-E message. | -1616 |
42IA0 | A sequence generator cannot be created. For details, refer to the KFPA19624-E message. | -1624 |
42J02 | Refer to the KFPA11584-E message. | -584 |
42J03 | Refer to the KFPA11605-E message. | -605 |
42J04 | Refer to the KFPA11606-E message. | -606 |
42J05 | Refer to the KFPA11611-E message. | -611 |
42J06 | Refer to the KFPA11620-E message. | -620 |
42J07 | Refer to the KFPA11622-E message. | -622 |
42J08 | Refer to the KFPA11624-E message. | -624 |
42J10 | Refer to the KFPA11702-E message. | -702 |
42J11 | Refer to the KFPA11704-E message. | -704 |
42J12 | Refer to the KFPA11710-E message. | -710 |
42J13 | Refer to the KFPA11717-E message. | -717 |
42J14 | Refer to the KFPA11718-E message. | -718 |
42J15 | Refer to the KFPA11721-E message. | -721 |
42J16 | Refer to the KFPA19331-E message. | -1331 |
42J17 | Refer to the KFPA19575-E message. | -1575 |
42J18 | Refer to the KFPA19625-E message. | -1625 |
42J21 | Refer to the KFPA11200-E message. | -200 |
42J22 | Refer to the KFPA11369-E message. | -369 |
42J23 | Refer to the KFPA11597-E message. | -597 |
42J24 | Refer to the KFPA11754-E message. | -754 |
42J29 | Refer to the KFPA11908-E message. | -908 |
42J30 | Refer to the KFPA11909-E message. | -909 |
42J31 | Refer to the KFPA11939-E message. | -939 |
42J33 | Refer to the KFPA19200-E message. | -1200 |
42J34 | Refer to the KFPA19581-E message. | -1581 |
42J35 | Refer to the KFPA19681-E message. | -1681 |
42JA1 | The ? parameter cannot be specified in an SQL statement for a trigger. For details, refer to the KFPA19450-E message. | -1450 |
42JA2 | A trigger cannot be defined for other schemas. For details, refer to the KFPA19450-E message. | -1450 |
42JA4 | Trigger can be defined only for a base table. For details, refer to the KFPA19450-E message. | -1450 |
42JA5 | The table for which a trigger is to be defined does not exist. For details, refer to the KFPA19450-E message. | -1450 |
42JA6 | OLD ROW or NEW ROW can be specified only once in the old or new values alias list, respectively. For details, refer to the KFPA19450-E message. | -1450 |
42JA7 | If INSERT is specified as the trigger execution timing, OLD ROW cannot be specified. For details, refer to the KFPA19450-E message. | -1450 |
42JA8 | If DELETE is specified as the trigger execution timing, NEW ROW cannot be specified. For details, refer to the KFPA19450-E message. | -1450 |
42JA9 | The same name cannot be specified in OLD ROW and NEW ROW. For details, refer to the KFPA19450-E message. | -1450 |
42JAA | If FOR EACH STATEMENT is specified, NEW ROW and OLD ROW cannot be specified. For details, refer to the KFPA19450-E message. | -1450 |
42JAB | More than 30,000 columns are specified in the trigger execution timing. For details, refer to the KFPA19450-E message. | -1450 |
42JAC | The column name specified in the trigger execution timing is duplicated. For details, refer to the KFPA19450-E message. | -1450 |
42JAD | The column specified in the trigger execution timing was not found in the table for which a trigger is to be defined. For details, refer to the KFPA19450-E message. | -1450 |
42JAE | In the trigger definition in which BEFORE is specified as the trigger action time, an update SQL statement cannot be specified as the triggered SQL statement. For details, refer to the KFPA19450-E message. | -1450 |
42JAF | Repetition columns and abstract data type columns cannot be referenced by the old or new values correlation name. For details, refer to the KFPA19450-E message. | -1450 |
42JAH | A table for which a trigger is defined cannot be specified in the triggered SQL statement. For details, refer to the KFPA19450-E message. | -1450 |
42JAJ | A reserved column cannot be specified as a trigger event column. For details, refer to the KFPA19450-E message. | -1450 |
42JAL | The user cannot define another user's table. For details, refer to the KFPA19450-E message. | -1450 |
42JAM | ROW cannot be specified for the old or new values correlation name. For details, refer to the KFPA19450-E message. | -1450 |
42JAN | If a CURRENT_TIMESTAMP column with USING BES as its default value is specified as the target of an assignment statement, DEFAULT cannot be assigned as a value. For details, refer to the KFPA19450-E message. | -1450 |
42JAO | In the trigger definition in which BEFORE is specified as the trigger action time, only the default constructor can be specified as the function call in the triggered SQL statement. For details, refer to the KFPA19450-E message. | -1450 |
42JAP | Neither a Java function nor a Java procedure can be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message. | -1450 |
42JAQ | ROLLBACK cannot be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message. | -1450 |
42JAR | COMMIT cannot be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message. | -1450 |
42JAS | PURGE cannot be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message. | -1450 |
42JAT | GET_JAVA_STORED_ROUTINE_SOURCE cannot be specified in a triggered SQL statement. For details, refer to the KFPA19450-E message. | -1450 |
42JD1 | Refer to the KFPA19293-E message. | -1293 |
42K01 | Refer to the KFPA11550-E message. | -550 |
42K02 | Refer to the KFPA11551-E message. | -551 |
42K03 | Refer to the KFPA11552-E message. | -552 |
42K04 | Refer to the KFPA11554-E message. | -554 |
42K05 | Refer to the KFPA11555-E message. | -555 |
42K06 | Refer to the KFPA11556-E message. | -556 |
42K14 | Refer to the KFPA11607-E message. | -607 |
42K20 | Refer to the KFPA11663-E message. | -663 |
42K21 | Refer to the KFPA11680-E message. | -680 |
42K22 | Refer to the KFPA11823-E message. | -823 |
42K25 | Refer to the KFPA11514-E message. | -514 |
42K26 | Refer to the KFPA11547-E message. | -547 |
42K27 | Refer to the KFPA19219-E message. | -1219 |
42K28 | Refer to the KFPA11573-E message. | -573 |
42K29 | Refer to the KFPA11590-E message. | -590 |
42K30 | Refer to the KFPA11902-E message. | -902 |
42K32 | Refer to the KFPA11904-E message. | -904 |
42K33 | Refer to the KFPA11905-E message. | -905 |
42K34 | Refer to the KFPA11906-E message. | -906 |
42K35 | Refer to the KFPA11907-E message. | -907 |
42K36 | Refer to the KFPA19518-E message. | -1518 |
42K37 | Refer to the KFPA19631-E message. | -1631 |
42K38 | Refer to the KFPA19634-E message. | -1634 |
42K39 | Refer to the KFPA19635-E message. | -1635 |
42K40 | Refer to the KFPA19680-E message. | -1680 |
42K41 | Refer to the KFPA19296-E message. | -1296 |
42K42 | Refer to the KFPA11925-E message. | -925 |
Table 8-25 SQLSTATE class 45
SQLSTATE | Explanation | SQLCODE |
---|---|---|
45501 | Refer to the KFPA19404-E message. | -1404 |
Table 8-26 SQLSTATE class 51
SQLSTATE | Explanation | SQLCODE |
---|---|---|
51001 | Refer to the KFPA11307-E message. | -307 |
51003 | Refer to the KFPA11769-E message. | -769 |
51004 | Refer to the KFPA11838-E message. | -838 |
51006 | Refer to the KFPA11804-E message. | -804 |
5100F | Refer to the KFPA11997-E message. | -997 |
5100H | Refer to the KFPA11359-E message. | -359 |
Table 8-27 SQLSTATE class 52
SQLSTATE | Explanation | SQLCODE |
---|---|---|
52002 | Refer to the KFPA11787-E message. | -787 |
52003 | Refer to the KFPA11558-E message. | -558 |
52004 | Refer to the KFPA11727-E message. | -727 |
52005 | Refer to the KFPA11734-E message. | -734 |
52006 | Refer to the KFPA19456-E message. | -1456 |
52007 | Refer to the KFPA19503-E message. | -1503 |
52008 | Refer to the KFPA11948-E message. | -948 |
52009 | Refer to the KFPA11569-E message. | -569 |
5200B | Refer to the KFPA11937-E message. | -937 |
52010 | Refer to the KFPA11494-E message. | -494 |
52011 | An error occurred during transaction control processing. For details, refer to the KFPA19703-E message. | -1703 |
52014 | Refer to the KFPA11990-E message. | -990 |
52206 | Refer to the KFPA19802-E message. | -1802 |
52208 | Refer to the KFPA19102-E message. | -1102 |
52209 | Refer to the KFPA19518-E message. | -1518 |
52301 | Refer to the KFPA11395-E message. | -395 |
52302 | Refer to the KFPA11722-E message. | -722 |
52303 | Refer to the KFPA11723-E message. | -723 |
Table 8-28 SQLSTATE class 53
SQLSTATE | Explanation | SQLCODE |
---|---|---|
53001 | Refer to the KFPA11356-E message. | -356 |
53002 | Refer to the KFPA11546-E message. | -546 |
53004 | Refer to the KFPA11900-E message. | -900 |
53005 | Refer to the KFPA19587-E message. | -1587 |
53006 | Refer to the KFPA19800-E message. | -1800 |
53021 | Refer to the KFPA11613-E message. | -613 |
53201 | Refer to the KFPA11930-E message. | -930 |
53202 | Refer to the KFPA11729-E message. | -729 |
53203 | Refer to the KFPA11914-E message. | -914 |
53204 | Refer to the KFPA11929-E message. | -929 |
53208 | Refer to the KFPA11395-E message. | -395 |
53209 | The SQL statement cannot be executed because the resource indicated by its resource ID is in use exclusively by another transaction. For details, refer to the KFPA11770-I message. | -770 |
53210 | There is not enough work area for locking. For details, refer to the KFPA11912-E message. | -912 |
53212 | An attempt to expand the thread stack area failed. For details, refer to the KFPA11945-E message. | -945 |
53301 | Refer to the KFPA11596-E message. | -596 |
53302 | Refer to the KFPA19576-E message. | -1576 |
53305 | Refer to the KFPA19705-E message. | -1705 |
53401 | Refer to the KFPA11342-E message. | -342 |
53402 | Refer to the KFPA11531-E message. | -531 |
53601 | Refer to the KFPA19719-E message. | -1719 |
53602 | Refer to the KFPA19724-E message. | -1724 |
53603 | Refer to the KFPA19725-E message. | -1725 |
Table 8-29 SQLSTATE class 54
SQLSTATE | Explanation | SQLCODE |
---|---|---|
54001 | Refer to the KFPA11159-E message. | -159 |
54002 | Refer to the KFPA11315-E message. | -315 |
54003 | Refer to the KFPA11935-E message. | -935 |
54005 | Refer to the KFPA19411-E message. | -1411 |
54006 | Refer to the KFPA19502-E message. | -1502 |
54007 | Refer to the KFPA19510-E message. | -1510 |
54008 | Refer to the KFPA19511-E message. | -1511 |
54009 | Refer to the KFPA19512-E message. | -1512 |
54201 | Refer to the KFPA11563-E message. | -563 |
54202 | Refer to the KFPA11725-E message. | -725 |
Table 8-30 SQLSTATE class 55
SQLSTATE | Explanation | SQLCODE |
---|---|---|
55001 | An error occurred on the Java Virtual Machine. For details, refer to the KFPA11491-E message. | -491 |
Table 8-31 SQLSTATE class 56
SQLSTATE | Explanation | SQLCODE |
---|---|---|
56001 | Refer to the KFPA11312-E message. | -312 |
56007 | Refer to the KFPA11616-E message. | -616 |
56008 | Refer to the KFPA11654-E message. | -654 |
56009 | Refer to the KFPA11657-E message. | -657 |
5600B | Refer to the KFPA11706-E message. | -706 |
5600C | Refer to the KFPA11748-E message. | -748 |
5600E | The length of the SQL statement to be dynamically preprocessed is invalid. For details, refer to the KFPA11821-E message. | -821 |
5600F | The length of the SQL statement specified in the view definition exceeds the permitted maximum value. For details, refer to the KFPA11821-E message. | -821 |
5600G | The length of the SQL statement specified in the check constraint definition exceeds the permitted maximum value. For details, refer to the KFPA11821-E message. | -821 |
5600H | The length of the SQL statement specified in the procedure definition exceeds the permitted maximum value. For details, refer to the KFPA11821-E message. | -821 |
5600I | Refer to the KFPA19450-E message. | -1450 |
56010 | Refer to the KFPA11662-E message. | -662 |
56011 | Refer to the KFPA11167-E message. | -167 |
56012 | Refer to the KFPA11250-E message. | -250 |
56013 | Refer to the KFPA11343-E message. | -343 |
56014 | Refer to the KFPA11634-E message. | -634 |
56015 | Refer to the KFPA11636-E message. | -636 |
56016 | Refer to the KFPA11637-E message. | -637 |
56017 | Refer to the KFPA11703-E message. | -703 |
56018 | Refer to the KFPA11714-E message. | -714 |
56019 | Refer to the KFPA11795-E message. | -795 |
56020 | Refer to the KFPA11805-E message. | -805 |
56022 | Refer to the KFPA11952-E message. | -952 |
56026 | Refer to the KFPA19513-E message. | -1513 |
56027 | Refer to the KFPA19583-E message. | -1583 |
56028 | Refer to the KFPA19584-E message. | -1584 |
56030 | The result of serialization (conversion to character string) of an XML-type value is too long. For details, refer to the KFPA19313-E message. | -1313 |
56031 | The size of an SQL object exceeds 32 MB. For details, refer to the KFPA11992-E message. | -992 |
56032 | The SQL statement cannot be executed for one of the following reasons
| -813 |
Table 8-32 SQLSTATE class 57
SQLSTATE | Explanation | SQLCODE |
---|---|---|
57008 | Refer to the KFPA11528-E message. | -528 |
57009 | Refer to the KFPA11529-E message. | -529 |
Table 8-33 SQLSTATE class 58
SQLSTATE | Explanation | SQLCODE |
---|---|---|
58004 | Refer to the KFPA11610-E message. | -610 |
58005 | Refer to the KFPA11652-E message. | -652 |
58006 | Refer to the KFPA11653-E message. | -653 |
58008 | Refer to the KFPA11608-E message. | -608 |
58009 | Refer to the KFPA19704-E message. | -1704 |
58011 | Refer to the KFPA11513-E message. | -513 |
58012 | Refer to the KFPA11599-E message. | -599 |
58013 | Refer to the KFPA11707-E message. | -707 |
58014 | Refer to the KFPA11708-E message. | -708 |
58015 | Refer to the KFPA11709-E message. | -709 |
58018 | Refer to the KFPA11771-E message. | -771 |
58019 | Refer to the KFPA11796-E message. | -796 |
58021 | Refer to the KFPA11844-E message. | -844 |
58022 | Refer to the KFPA11845-E message. | -845 |
58023 | Refer to the KFPA11848-E message. | -848 |
Table 8-34 SQLSTATE class 59
SQLSTATE | Explanation | SQLCODE |
---|---|---|
59001 | Refer to the KFPA11280-E message. | -280 |
59002 | Refer to the KFPA11281-E message. | -281 |
59003 | Refer to the KFPA11761-E message. | -761 |
59004 | Refer to the KFPA11890-E message. | -890 |
59005 | Refer to the KFPA11895-E message. | -895 |
59006 | Refer to the KFPA11896-E message. | -896 |
Table 8-35 SQLSTATE class 5A
SQLSTATE | Explanation | SQLCODE |
---|---|---|
5A001 | Refer to the KFPA11329-E message. | -329 |
5A003 | Refer to the KFPA11785-E message. | -785 |
Table 8-36 SQLSTATE class 5B
SQLSTATE | Explanation | SQLCODE |
---|---|---|
5B001 | Refer to the KFPA11735-E message. | -735 |
5B002 | The SIGNAL or RESIGNAL statement resulted in an error. For details, refer to the KFPA19400-E message. | -1400 |
Table 8-37 SQLSTATE class 5C
SQLSTATE | Explanation | SQLCODE |
---|---|---|
5C006 | Refer to the KFPA11431-E message. | -431 |
5C007 | Refer to the KFPA11476-E message. | -476 |
5C008 | Refer to the KFPA11484-E message. | -484 |
5C009 | Refer to the KFPA11485-E message. | -485 |
5C010 | Refer to the KFPA11553-E message. | -553 |
5C011 | Refer to the KFPA11720-E message. | -720 |
5C012 | Refer to the KFPA11728-E message. | -728 |
5C013 | Refer to the KFPA11731-E message. | -731 |
5C014 | Refer to the KFPA11732-E message. | -732 |
5C015 | Refer to the KFPA11733-E message. | -733 |
5C016 | Refer to the KFPA11736-E message. | -736 |
5C021 | Refer to the KFPA11941-E message. | -941 |
5C024 | Refer to the KFPA11984-E message. | -984 |
5C025 | Refer to the KFPA11987-E message. | -987 |
5C026 | Refer to the KFPA19332-E message. | -1332 |
5C027 | Refer to the KFPA19333-E message. | -1333 |
5C030 | Refer to the KFPA19700-E message. | -1700 |
5C031 | Refer to the KFPA19517-E message. | -1517 |
5C032 | Refer to the KFPA19520-E message. | -1520 |
Table 8-38 SQLSTATE class 5E
SQLSTATE | Explanation | SQLCODE |
---|---|---|
5E101 | Refer to the KFPA19222-E message. | -1222 |
Table 8-39 SQLSTATE class IZ
SQLSTATE | Explanation | SQLCODE |
---|---|---|
IZ003 | An attempt was made to execute index batch creation for an index that had already been created. For details, refer to the KFPA11875-E message. | -875 |
Table 8-40 SQLSTATE class R2
SQLSTATE | Explanation | SQLCODE |
---|---|---|
R2000 | During a list search, a row that existed at the time of list creation was not returned. For details, refer to the KFPA12110-I message. | 110 |