This table lists the SQLSTATEs in numerical order and the SQL return code(s) that equate to them. For information about the defined classes of SQLSTATEs, see SQL State Classes.
|
SQL State |
SQL Return Code(s) |
|---|---|
|
00000 |
0, -985, -986, -987, -988, -989, -990, -991, -992, -993, -994, -995, -996, -997, -998 |
|
01S01 |
+170 |
|
01S02 |
-243 |
|
07003 |
-134 |
|
07S01 |
-301 |
|
07S02 |
-302 |
|
07S03 |
-303 |
|
07S04 |
-304 |
|
07S05 |
-300 |
|
07S06 |
-306 |
|
07S07 |
-307 |
|
07S08 |
-308 |
|
07S09 |
-309 |
|
07S10 |
-311 |
|
07S11 |
-312 |
|
09S01 |
-533 |
|
09S02 |
-532 |
|
0AS01 |
-023, -024, -027, -029, -031, -109, |
|
0AS02 |
-087 |
|
0AS03 |
-101 |
|
0AS04 |
-241 |
|
0AS05 |
-285 |
|
0AS06 |
-299 |
|
0AS07 |
-269 |
|
02000 |
+100 |
|
21000 |
-142, -148 |
|
2200C |
-042 |
|
22001 |
-053 |
|
22002 |
-001 |
|
22003 |
-004 |
|
22007 |
-218, -219, -223, -224, -225, -226, -227, -228, -229, -230, -231, -232, -233, -234, -235, -236, -238 |
|
22008 |
-193, -198, -199, -200, -201, -202, -203, -204, -230, -237 |
|
22504 |
-294, -296, -297, -298 |
|
22512 |
-293 |
|
22S01 |
-039 |
|
22S02 |
-295 |
|
22S03 |
-161 |
|
23502 |
-086 |
|
23503 |
-176 |
|
23504 |
-175 |
|
23505 |
-263 |
|
23513 |
-167 |
|
23515 |
-267 |
|
24S01 |
-180 |
|
24S02 |
-181 |
|
24S03 |
-183 |
|
24S04 |
-317 |
|
24S05 |
-130 |
|
24501 |
-135 |
|
24502 |
-502 |
|
25S01 |
-147 |
|
25004 |
-144 |
|
25501 |
-122 |
|
34S01 |
-153 |
|
34000 |
-133 |
|
38S01 |
-530 |
|
38S02 |
-531 |
|
2FS04 |
-534 |
|
39S01 |
-535 |
|
39001 |
-321, -322 |
|
3FS01 |
-146 |
|
3FS02 |
-150 |
|
42S01 |
-025 |
|
42S02 |
-244 |
|
42S03 |
-245 |
|
42S04 |
-246 |
|
42S05 |
-270 |
|
42S06 |
-273 |
|
42S07 |
-313 |
|
42S08 |
-314 |
|
42S09 |
-315 |
|
42S10 |
-172 |
|
42S11 |
-563 |
|
42S12 |
-316 |
|
42S13 |
-075 |
|
42S14 |
-209 |
|
42501 |
-185 |
|
42502 |
-003, -008, -247, -248 |
|
42601 |
-020, -110 |
|
42603 |
-007 |
|
42604 |
-105, -284 |
|
42606 |
-565, -566 |
|
42607 |
-072 |
|
42611 |
-151 |
|
42612 |
-002 |
|
42622 |
-030 |
|
42625 |
-208 |
|
42701 |
-055, -069 |
|
42702 |
-033 |
|
42703 |
-009 |
|
42703 |
-261 |
|
42704 |
-014, -015, -034, -127, -179, -250 |
|
42707 |
-070 |
|
42710 |
-165 |
|
42802 |
-054, -057 |
|
42803 |
-073, -076, -103 |
|
42804 |
-207 |
|
42805 |
-066 |
|
42806 |
-159 |
|
42807 |
-079, -111 |
|
42808 |
-113 |
|
42811 |
-155 |
|
42815 |
-044, -278 |
|
42816 |
-277 |
|
42818 |
-041, -194, -195 |
|
42820 |
-289 |
|
42821 |
-058 |
|
42823 |
-071 |
|
42824 |
-290 |
|
42825 |
-083 |
|
42826 |
-082 |
|
42830 |
-173 |
|
42831 |
-182 |
|
42837 |
-255 |
|
42889 |
-168, -564 |
|
42890 |
-169 |
|
42902 |
-162, -174 |
|
42903 |
-067 |
|
42905 |
-080 |
|
42908 |
-184 |
|
44S01 |
-178 |
|
44S02 |
-018 |
|
44000 |
-156 |
|
51S01 |
-129 |
|
51S02 |
-210 |
|
51002 |
-124 |
|
51003 |
-120 |
|
53S01 |
-017 |
|
53S02 |
-019 |
|
53S03 |
-036 |
|
53S04 |
-043 |
|
53S05 |
-045 |
|
53S06 |
-084 |
|
53S07 |
-085 |
|
53S08 |
-132 |
|
53S09 |
-138 |
|
53S10 |
-139 |
|
53S11 |
-140 |
|
53S12 |
-141 |
|
53S13 |
-145 |
|
53S14 |
-143 |
|
53S15 |
-149 |
|
53S16 |
-163 |
|
53S17 |
-189 |
|
53S18 |
-190 |
|
53S19 |
-191 |
|
53S20 |
-192 |
|
53S21 |
-205 |
|
53S22 |
-206 |
|
53S23 |
-242 |
|
53S24 |
-254 |
|
53S25 |
-257 |
|
53S26 |
-260 |
|
53S27 |
-274 |
|
53S28 |
-286 |
|
53S29 |
-310 |
|
53S30 |
-503 |
|
53S31 |
-504 |
|
53S32 |
-505 |
|
53S33 |
-136 |
|
53S34 |
-275 |
|
53S35 |
-276 |
|
53S36 |
-305 |
|
53S37 |
-320 |
|
53S38 |
-562 |
|
53S39 |
-292 |
|
53S40 |
-215 |
|
53S41 |
-214 |
|
53S42 |
-216 |
|
54S01 |
-021 |
|
54S02 |
-164 |
|
54S03 |
-256 |
|
54S04 |
-319 |
|
54001 |
-032 |
|
54002 |
-006, -012 |
|
54004 |
-026, -152 |
|
54010 |
-061 |
|
54010 |
-131 |
|
54011 |
-060 |
|
55S01 |
-166, -249, -262 |
|
55S02 |
-252 |
|
55S03 |
-251 |
|
55S04 |
-037 |
|
55S05 |
-158 |
|
55S06 |
-171 |
|
55S07 |
-177 |
|
55S08 |
-188 |
|
55S09 |
-291 |
|
55S10 |
-318 |
|
56S01 |
-056 |
|
56S02 |
-123 |
|
56S04 |
-264 |
|
56S05 |
-038 |
|
56S06 |
-119 |
|
56S07 |
-121 |
|
56S08 |
-128 |
|
56S09 |
-265 |
|
56S10 |
-266 |
|
56S11 |
-272 |
|
56S12 |
-279 |
|
56S13 |
-280 |
|
56S14 |
-281 |
|
56S15 |
-282 |
|
56S16 |
-283 |
|
56S17 |
-287 |
|
56S18 |
-288 |
|
56SNO |
-064 |
|
56S19 |
-999 |
|
57S01 |
-040 |
|
57S02 |
-125 |
|
57S03 |
-137 |
|
57S04 |
-259 |
|
57S05 |
-560, -561 |
|
57S06 |
-258 |
|
57S07 |
-016 |
|
57002 |
-559 |
|
57011 |
-010, -157 |
|
58S01 |
-126 |
|
58S02 |
-035 |
|
80S01 |
-005 |
|
REEII |
-118 |
|
SEEII |
-117 |
The unnumbered messages that are documented in this section can be displayed with an associated return code. If other errors were issued, the return codes shown may not appear in the output. The condition code returned to the operating system for the step matches the return code. Most of these messages are related to options processing or environmental issues such as the print or option file.
|
Copyright © 2014 CA.
All rights reserved.
|
|