Previous Topic: SQL State ClassesNext Topic: Application Tasks Using Embedded SQL


SQL States Table

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

-193, -198, -199, -200, -201, -202, -203, -204, -218, -219, -223, -224, -225, -226, -227, -228, -229, -230, -231, -232, -233, -234, -235, -236, -237, -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

38S04

-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