SQLSTATE Values

The following table describes the ANSI equivalents to XDB mode and DB2 error codes. The ANSI error value is stored in the SQLSTATE element of SQLCA.

XDB mode SQLCODE DB2 SQLCODE ANSI SQLSTATE
+100 N/A 02000
0 N/A 00000
-2 -198 37517
-4 -405 53020
-6 -102 54002
-7 -10 37503
-9 -206 52003
-11 -401 53018
-12 -401 53018
-16 -501 24501
-18 -803 23505
-19 -101 54001
-20 -84 37512
-23 -302 22001
-26 -129 54004
-28 -159 52004
-32 -913 40502
-35 -913 40502
-40 -803 23505
-43 -402 53019
-44 -685 58002
-46 -602 54008
-47 -107 54003
-48 -601 52010
-50 -614 N/A
-51 -603 22515
-54 -117 53002
-55 -121 52001
-56 -601 52010
-57 -117 53002
-58 -408 53021
-59 -404 22001
-61 -680 54011
-66 -125 53005
-71 -412 53023
-72 -112 37507
-73 -122 53003
-75 -122 53003
-76 -913 40502
-79 -150 56013
-80 -127 56005
-82 -421 53026
-83 -415 53025
-86 -407 23502
-87 -107 54003
-88 -107 54003
-91 -551 42501
-103 -119 53003
-104 -607 53032
-106 -155 N/A
-108 -153 56008
-118 -601 52010
-119 -107 54003
-124 -607 53032
-125 -514 26501
-127 -414 53024
-130 -618 53032
-138 -156 53009
-140 -160 53013
-141 -161 23501
-144 -652 23501
-146 -616 23503
-153 -913 40502
-154 -913 40502
-155 -913 40502
-156 -911 40000
-157 -913 40502
-158 -913 40502
-159 -913 40502
-160 -913 40502
-174 -601 52010
-177 -107 54003
-179 -604 37511
-185 -126 53029
-188 -305 22002
-212 -104 37501
-214 -502 24502
-215 -501 24501
-227 -531 23504
-228 -532 23504
-229 -530 23503
-231 -510 53028
-244 -118 56002
-246 -534 21502
-247 -181 22007
-277 -551 42501
-278 -553 42503
-279 -107 54003
-280 -204 52004
-281 -601 52010
-284 -637 37514
-287 -513 56024
-288 -512 56023
-289 -644 37515
-290 -620 53001
-291 -199 37501
-305 N/A 22002
-343 -925 56201
-344 -926 40502
-803 N/A 23505
-811 N/A 21000