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 |