DB2的常見SQLCODE所表示負數(shù)的含義

DB2的常見SQLCODE所表示負數(shù)的含義DB2的常見SQLCODE所表示負數(shù)的含義/NUMPAGES90DB2的常見SQLCODE所表示負數(shù)的含義DB2的常見SQLCODE所表示負數(shù)的含義

DB2的常見SQLCODE所表示負數(shù)的含義

SQL0007SQLCODE-07

SQLSTATE42601

Explanation:Character&1(HEX&2)notvalidinSQLstatement.

SQL0010SQLCODE-10

SQLSTATE42603

Explanation:Stringconstantbeginning&1notdelimited.

SQL0029SQLCODE-29

SQLSTATE42601

Explanation:INTOclausemissingfromembeddedSELECTstatement.

SQL0051SQLCODE-51

SQLSTATE3C000

Explanation:Cursororprocedure&1previouslydeclared.

SQL0060SQLCODE-60

SQLSTATE42815

Explanation:Value&3forargument&1of&2functionnotvalid.

SQL0078SQLCODE-78

SQLSTATE42629

Explanation:Parameternamerequiredforroutine&1in&2.

SQL0080SQLCODE-80

SQLSTATE42978

Explanation:Indicatorvariable&1notSMALLINTtype.

SQL0084SQLCODE-84

SQLSTATE42612

Explanation:SQLstatementnotallowed.

SQL0090SQLCODE-90

SQLSTATE42618

Explanation:Hostvariablenotpermittedhere.

SQL0097SQLCODE-97

SQLSTATE42601

Explanation:Useofdatatypenotvalid.

SQL0099SQLCODE-99

SQLSTATE42992

Explanation:Operatorinjoinconditionnotvalid.

SQL0101SQLCODE-101

SQLSTATE54001,54010,54011

Explanation:SQLstatementtoolongorcomplex.

SQL0102SQLCODE-102

SQLSTATE54002

Explanation:Stringconstantbeginningwith&1toolong.

SQL0103SQLCODE-103

SQLSTATE42604

Explanation:Numericconstant&1notvalid.

SQL0104SQLCODE-104

SQLSTATE42601

Explanation:Token&1wasnotvalid.Validtokens:&2.

SQL0105SQLCODE-105

SQLSTATE42604

Explanation:Mixedorgraphicstringconstantnotvalid.

SQL0106SQLCODE-106

SQLSTATE42611

Explanation:PrecisionspecifiedforFLOATcolumnnotvalid.

SQL0107SQLCODE-107

SQLSTATE42622

Explanation:&1toolong.Maximum&2characters.

SQL0109SQLCODE-109

SQLSTATE42601

Explanation:&1clausenotallowed.

SQL0110SQLCODE-110

SQLSTATE42606

Explanation:Hexadecimalconstantbeginningwith&1notvalid.

SQL0112SQLCODE-112

SQLSTATE42607

Explanation:Argumentoffunction&1isanotherfunction.

SQL0113SQLCODE-113

SQLSTATE28000,2E000,42602

Explanation:Name&1notallowed.

SQL0114SQLCODE-114

SQLSTATE42961

Explanation:Relationaldatabase&1notthesameascurrentserver&2.

SQL0115SQLCODE-115

SQLSTATE42601

Explanation:Comparisonoperator&1notvalid.

SQL0117SQLCODE-117

SQLSTATE42802

Explanation:Statementinsertswrongnumberofvalues.

SQL0118SQLCODE-118

SQLSTATE42902

Explanation:Table&1in&2alsospecifiedinaFROMclause.

SQL0119SQLCODE-119

SQLSTATE42803

Explanation:Column&1inHAVINGclausenotinGROUPBY.

SQL0120SQLCODE-120

SQLSTATE42903

Explanation:Useofcolumnfunction&2notvalid.

SQL0121SQLCODE-121

SQLSTATE42701

Explanation:Duplicatecolumnname&1inINSERTorUPDATE.

SQL0122SQLCODE-122

SQLSTATE42803

Explanation:ColumnspecifiedinSELECTlistnotvalid.

SQL0125SQLCODE-125

SQLSTATE42805

Explanation:ORDERBYcolumnnumber&1notvalid.

SQL0128SQLCODE-128

SQLSTATE42601

Explanation:UseofNULLisnotvalid.

SQL0129SQLCODE-129

SQLSTATE54004

Explanation:ToomanytablesinSQLstatement.

SQL0130SQLCODE-130

SQLSTATE22019,22025

Explanation:Escapecharacter&1orLIKEpatternnotvalid.

SQL0131SQLCODE-131

SQLSTATE42818

Explanation:OperandsofLIKEnotcompatibleornotvalid.

SQL0132SQLCODE-132

SQLSTATE42824

Explanation:LIKEpredicatenotvalid.

SQL0133SQLCODE-133

SQLSTATE42906

Explanation:OperatoroncorrelatedcolumninSQLfunctionnotvalid.

SQL0134SQLCODE-134

SQLSTATE42907

Explanation:Argumentoffunctiontoolong.

SQL0136SQLCODE-136

SQLSTATE54005

Explanation:ORDERBYorGROUPBYcolumnstoolong.

SQL0137SQLCODE-137

SQLSTATE54006

Explanation:Resulttoolong.

SQL0138SQLCODE-138

SQLSTATE22011

Explanation:Argument&1ofSUBSTRfunctionnotvalid.

SQL0144SQLCODE-144

SQLSTATE58003

Explanation:Sectionnumbernotvalid.

SQL0145SQLCODE-145

SQLSTATE55005

Explanation:RecursionnotsupportedforanapplicationserverotherthantheAS/400system.

SQL0150SQLCODE-150

SQLSTATE42807

Explanation:Vieworlogicalfile&1in&2read-only.

SQL0151SQLCODE-151

SQLSTATE42808

Explanation:Column&1intable&2in&3read-only.

SQL0152SQLCODE-152

SQLSTATE42809

Explanation:Constrainttypenotvalidforconstraint&1in&2.

SQL0153SQLCODE-153

SQLSTATE42908

Explanation:ColumnlistrequiredforCREATEVIEW.

SQL0154SQLCODE-154

SQLSTATE42909

Explanation:UNIONandUNIONALLforCREATEVIEWnotvalid.

SQL0156SQLCODE-156

SQLSTATE42809

Explanation:&1in&2notatable.

SQL0157SQLCODE-157

SQLSTATE42810

Explanation:View&1in&2notvalidinFOREIGNKEYclause.

SQL0158SQLCODE-158

SQLSTATE42811

Explanation:Numberofcolumnsspecifiednotconsistent.

SQL0159SQLCODE-159

SQLSTATE42809

Explanation:&1in&2notcorrecttype.

SQL0160SQLCODE-160

SQLSTATE42813

Explanation:WITHCHECKOPTIONnotallowedforview&1in&2.

SQL0161SQLCODE-161

SQLSTATE44000

Explanation:INSERT/UPDATEnotallowedduetoWITHCHECKOPTION.

SQL0170SQLCODE-170

SQLSTATE42605

Explanation:Numberofargumentsforfunction&1notvalid.

SQL0171SQLCODE-171

SQLSTATE42815

Explanation:Argument&1offunction&2notvalid.

SQL0175SQLCODE-175

SQLSTATE58028

Explanation:COMMITfailed.

SQL0180SQLCODE-180

SQLSTATE22007

Explanation:Syntaxofdate,time,ortimestampvaluenotvalid.

SQL0181SQLCODE-181

SQLSTATE22007

Explanation:Valueindate,time,ortimestampstringnotvalid.

SQL0182SQLCODE-182

SQLSTATE42816

Explanation:Adate,time,ortimestampexpressionnotvalid.

SQL0183SQLCODE-183

SQLSTATE22008

Explanation:Theresultofadateortimestampexpressionnotvalid.

SQL0184SQLCODE-184

SQLSTATE42610

Explanation:Parametermarkernotvalidinexpression.

SQL0187SQLCODE-187

SQLSTATE42816

Explanation:Useoflabeleddurationisnotvalid.

SQL0188SQLCODE-188

SQLSTATE22503,28000,2E000

Explanation:&1isnotavalidstringrepresentationofanauthorizationnameorarelationaldatabasename.

SQL0189SQLCODE-189

SQLSTATE22522

Explanation:CodedCharacterSetIdentifier&1isnotvalid.

SQL0190SQLCODE-190

SQLSTATE42837

Explanation:Attributesofcolumn&3in&1in&2notcompatible.

SQL0191SQLCODE-191

SQLSTATE22504

Explanation:MIXEDdatanotproperlyformed.

SQL0192SQLCODE-192

SQLSTATE42937

Explanation:ArgumentofTRANSLATEfunctionnotvalid.

SQL0194SQLCODE-194

SQLSTATE42848

Explanation:KEEPLOCKSnotallowed.

SQL0195SQLCODE-195

SQLSTATE42814

Explanation:Lastcolumnof&1in&2cannotbedropped.

SQL0196SQLCODE-196

SQLSTATE42817

Explanation:Column&3in&1in&2cannotbedroppedwithRESTRICT.

SQL0197SQLCODE-197

SQLSTATE42877

Explanation:Column&1cannotbequalified.

SQL0198SQLCODE-198

SQLSTATE42617

Explanation:SQLstatementemptyorblank.

SQL0199SQLCODE-199

SQLSTATE42601

Explanation:Keyword&1notexpected.Validtokens:&2.

SQL0203SQLCODE-203

SQLSTATE42702

Explanation:Column&1isambiguous.

SQL0204SQLCODE-204

SQLSTATE42704

Explanation:&1in&2type*&3notfound.

SQL0205SQLCODE-205

SQLSTATE42703

Explanation:Column&1notintable&2.

SQL0206SQLCODE-206

SQLSTATE42703

Explanation:Column&1notinspecifiedtables.

SQL0208SQLCODE-208

SQLSTATE42707

Explanation:ORDERBYcolumn&1notinresultstable.

SQL0212SQLCODE-212

SQLSTATE42712

Explanation:Duplicatetabledesignator&1notvalid.

SQL0214SQLCODE-214

SQLSTATE42822

Explanation:ORDERBYexpressionisnotvalid.

SQL0221SQLCODE-221

SQLSTATE42873

Explanation:Numberofrows&2notvalid.

SQL0225SQLCODE-225

SQLSTATE42872

Explanation:FETCHnotvalid;cursor&1notdeclaredwithSCROLL.

SQL0226SQLCODE-226

SQLSTATE24507

Explanation:Currentrowdeletedormovedforcursor&1.

SQL0227SQLCODE-227

SQLSTATE24513

Explanation:FETCHnotvalid,cursor&1inunknownposition.

SQL0228SQLCODE-228

SQLSTATE42620

Explanation:FORUPDATEOFclausenotvalidwithSCROLLforcursor&1.

SQL0231SQLCODE-231

SQLSTATE22006

Explanation:Positionofcursor&1notvalidforFETCHofcurrentrow.

SQL0250SQLCODE-250

SQLSTATE42718

Explanation:Localrelationaldatabasenotdefinedinthedirectory.

SQL0251SQLCODE-251

SQLSTATE2E000,42602

Explanation:Characterinrelationaldatabasename&1isnotvalid.

SQL0255SQLCODE-255

SQLSTATE42999

Explanation:DB2Multisystemqueryerror.

SQL0256SQLCODE-256

SQLSTATE42998

Explanation:Constraint&1in&2notallowedondistributedfile.

SQL0270SQLCODE-270

SQLSTATE42997

Explanation:Uniqueindexnotallowed.

SQL0301SQLCODE-301

SQLSTATE07006,42895

Explanation:Inputhostvariable&2orargument&1notvalid.

SQL0302SQLCODE-302

SQLSTATE22001,22003,22023,22024

Explanation:Conversionerroroninputhostvariable&2.

SQL0303SQLCODE-303

SQLSTATE22001,42806

Explanation:Hostvariable&1notcompatiblewithSELECTitem.

SQL0304SQLCODE-304

SQLSTATE22003,22023,22504

Explanation:Conversionerrorinassignmenttohostvariable&2.

SQL0305SQLCODE-305

SQLSTATE22002

Explanation:Indicatorvariablerequired.

SQL0306SQLCODE-306

SQLSTATE42863

Explanation:UndefinedhostvariableinREXX.

SQL0311SQLCODE-311

SQLSTATE22501

Explanation:Lengthinavarying-lengthhostvariablenotvalid.

SQL0312SQLCODE-312

SQLSTATE42618

Explanation:Hostvariable&1notdefinedornotusable.

SQL0313SQLCODE-313

SQLSTATE07001,07004

Explanation:Numberofhostvariablesnotvalid.

SQL0328SQLCODE-328

SQLSTATE42996

Explanation:Column&1notallowedinpartitioningkey.

SQL0329SQLCODE-329

SQLSTATE0E000

Explanation:TheSETPATHnamelistisnotvalid.

SQL0330SQLCODE-330

SQLSTATE22021

Explanation:Characterconversioncannotbeperformed.

SQL0331SQLCODE-331

SQLSTATE22021

Explanation:Characterconversioncannotbeperformed.

SQL0332SQLCODE-332

SQLSTATE57017

Explanation:CharacterconversionbetweenCCSID&1andCCSID&2notvalid.

SQL0334SQLCODE-334

SQLSTATE22524

Explanation:Characterconversionhasresultedintruncation.

SQL0338SQLCODE-338

SQLSTATE42972

Explanation:JOINexpressionnotvalid.

SQL0340SQLCODE-340

SQLSTATE42726

Explanation:Duplicatename&1forcommontableexpression.

SQL0341SQLCODE-341

SQLSTATE42835

Explanation:Cyclicreferencesbetweencommontableexpressions.

SQL0346SQLCODE-346

SQLSTATE42836

Explanation:Recursionnotallowedforcommontableexpressions.

SQL0350SQLCODE-350

SQLSTATE42962

Explanation:Column&1isnotvalidaskeyfieldforindexorconstraint.

SQL0351SQLCODE-351

SQLSTATE56084

Explanation:TheARisnotatthesamelevelandDB2/400cannottransformthedatatypetoacompatibletype.

SQL0352SQLCODE-352

SQLSTATE56084

Explanation:TheASisnotatthesamelevelandDB2/400cannottransformthedatatypetoacompatibletype.

SQL0357SQLCODE-357

SQLSTATE57050

Explanation:Fileserver&1usedinDataLinknotcurrentlyavailable.

SQL0358SQLCODE-358

SQLSTATE428D1

Explanation:Error&1occurredusingDataLinkdatatype.

SQL0392SQLCODE-392

SQLSTATE42855

Explanation:AssignmentofLOBtospecifiedhostvariablenotallowed.

SQL0398SQLCODE-398

SQLSTATE428D2

Explanation:ASLOCATORcannotbespecifiedforanon-LOBparameter.

SQL0401SQLCODE-401

SQLSTATE42818

Explanation:Comparisonoperator&1operandsnotcompatible.

SQL0402SQLCODE-402

SQLSTATE42819

Explanation:&1usenotvalid.

SQL0404SQLCODE-404

SQLSTATE22001

Explanation:Valueforcolumn&1toolong.

SQL0405SQLCODE-405

SQLSTATE42820

Explanation:Numericconstant&1outofrange.

SQL0406SQLCODE-406

SQLSTATE22003,22023,22504

Explanation:Conversionerroronassignmenttocolumn&2.

SQL0407SQLCODE-407

SQLSTATE23502

Explanation:Nullvaluesarenotallowedincolumn&1.

SQL0408SQLCODE-408

SQLSTATE42821

Explanation:INSERTorUPDATEvalueforcolumn&1notcompatible.

SQL0410SQLCODE-410

SQLSTATE42820

Explanation:Floatingpointliteral&1notvalid.

SQL0412SQLCODE-412

SQLSTATE42823

Explanation:Subquerywithmorethanoneresultcolumnnotvalid.

SQL0414SQLCODE-414

SQLSTATE42824

Explanation:Column&1notvalidinLIKEpredicate.

SQL0415SQLCODE-415

SQLSTATE42825

Explanation:UNIONoperandsnotcompatible.

SQL0417SQLCODE-417

SQLSTATE42609

Explanation:Combinationofparametermarkersnotvalid.

SQL0418SQLCODE-418

SQLSTATE42610

Explanation:Useofparametermarkerisnotvalid.

SQL0419SQLCODE-419

SQLSTATE42911

Explanation:Negativescalenotvalid.

SQL0420SQLCODE-420

SQLSTATE22018

Explanation:CharacterinCASTargumentnotvalid.

SQL0421SQLCODE-421

SQLSTATE42826

Explanation:NumberofUNIONoperandsnotequal.

SQL0423SQLCODE-423

SQLSTATE0F001

Explanation:LOBlocator&1notvalid.

SQL0428SQLCODE-428

SQLSTATE25501

Explanation:SQLstatementcannotberun.

SQL0429SQLCODE-429

SQLSTATE54028

Explanation:ThemaximumnumberofconcurrentLOBlocatorshasbeenreached.

SQL0432SQLCODE-432

SQLSTATE42841

Explanation:Aparametermarkercannothavetheuser-definedtypename&1.

SQL0433SQLCODE-433

SQLSTATE22001

Explanation:SignificantdigitstruncatedduringCASTfromnumerictocharacter.

SQL0440SQLCODE-440

SQLSTATE42884

Explanation:NumberofargumentsonCALLmustmatchprocedure.

SQL0441SQLCODE-441

SQLSTATE42601

Explanation:Clauseorkeyword&1notvalidwherespecified.

SQL0442SQLCODE-442

SQLSTATE54023

Explanation:Maximum#ofparametersonCALLexceeded.

SQL0443SQLCODE-443

SQLSTATE2Fxxx,38501

Explanation:Triggerprogramorexternalproceduredetectedonerror.

SQL0444SQLCODE-444

SQLSTATE42724

Explanation:Externalprogram&4in&1notfound.

SQL0446SQLCODE-446

SQLSTATE22003

Explanation:Conversionerrorinassignmentofargument&2.

SQL0448SQLCODE-448

SQLSTATE54023

Explanation:MaximumparametersonDECLAREPROCEDUREexceeded.

SQL0449SQLCODE-449

SQLSTATE42878

Explanation:Externalprogramnameforprocedure&1in&2notvalid.

SQL0451SQLCODE-451

SQLSTATE42815

Explanation:Attributesofparameter&1notvalidforprocedure.

SQL0452SQLCODE-452

SQLSTATE428A1

Explanation:Unabletoaccessafilethatisreferredtobyafilereferencevariable.

SQL0453SQLCODE-453

SQLSTATE42880

Explanation:Returntypeforfunction&1in&2notcompatiblewithCASTTOtype.

SQL0454SQLCODE-454

SQLSTATE42723

Explanation:Function&1in&2withthesamesignaturealreadyexists.

SQL0455SQLCODE-455

SQLSTATE42882

Explanation:Specificnamenotsameasprocedurename.

SQL0456SQLCODE-456

SQLSTATE42710

Explanation:Specificname&3in&2alreadyexists.

SQL0457SQLCODE-457

SQLSTATE42939

Explanation:Name&1in&2notallowedforfunction.

SQL0458SQLCODE-458

SQLSTATE42883

Explanation:Function&1in&2notfoundwithmatchingsignature.

SQL0461SQLCODE-461

SQLSTATE42846

Explanation:Castfrom&1to&2notsupported.

SQL0463SQLCODE-463

SQLSTATE39001

Explanation:SQLSTATE&4returnedfromroutine&1in&2notvalid..

SQL0469SQLCODE-469

SQLSTATE42886

Explanation:IN,OUT,INOUTnotvalidforparameter&4inprocedure&1in&2.

SQL0470SQLCODE-470

SQLSTATE39002

Explanation:NULLvaluesnotallowedforparameter&4inprocedure.

SQL0473SQLCODE-473

SQLSTATE42918

Explanation:User-definedtype&1cannotbecreated.

SQL0475SQLCODE-475

SQLSTATE42866

Explanation:RETURNSdatatypeforfunction&3in&4notvalid.

SQL0476SQLCODE-476

SQLSTATE42725

Explanation:Function&1in&2notunique.

SQL0478SQLCODE-478

SQLSTATE42893

Explanation:Object&1in&2oftype&3cannotbedropped.

SQL0483SQLCODE-483

SQLSTATE42885

Explanation:Parametersforfunction&1in&2notsameassourcedfunction.

SQL0484SQLCODE-484

SQLSTATE42733

Explanation:Routine&1in&2alreadyexists.

SQL0487SQLCODE-487

SQLSTATE38001

Explanation:SQLstatementsnotallowed.

SQL0490SQLCODE-490

SQLSTATE428B7

Explanation:Numericvalue&1notvalid.

SQL0491SQLCODE-491

SQLSTATE42601

Explanation:RETURNSclauserequiredonCREATEFUNCTIONstatement.

SQL0492SQLCODE-492

SQLSTATE42879

Explanation:Datatypeforfunction&1in&2notvalidforsourcetype.

SQL0501SQLCODE-501

SQLSTATE24501

Explanation:Cursor&1notopen.

SQL0502SQLCODE-502

SQLSTATE24502

Explanation:Cursor&1alreadyopen.

SQL0503SQLCODE-503

SQLSTATE42912

Explanation:Column&3cannotbeupdated.

SQL0504SQLCODE-504

SQLSTATE34000

Explanation:Cursor&1notdeclared.

SQL0507SQLCODE-507

SQLSTATE24501

Explanation:Cursor&1notopen.

SQL0508SQLCODE-508

SQLSTATE24504

Explanation:Cursor&1notpositionedonlockedrow.

SQL0509SQLCODE-509

SQLSTATE42827

Explanation:Table&2in&3notsameastableincursor&1.

SQL0510SQLCODE-510

SQLSTATE42828

Explanation:Cursor&1forfile&2isread-only.

SQL0511SQLCODE-511

SQLSTATE42829

Explanation:FORUPDATEOFclausenotvalid.

SQL0513SQLCODE-513

SQLSTATE42924

Explanation:Alias&1in&2cannotreferenceanotheralias.

SQL0514SQLCODE-514

SQLSTATE26501

Explanation:Preparedstatement&2notfound.

SQL0516SQLCODE-516

SQLSTATE26501

Explanation:Preparedstatement&2notfound.

SQL0517SQLCODE-517

SQLSTATE07005

Explanation:Preparedstatement&2notSELECTstatement.

SQL0518SQLCODE-518

SQLSTATE07003

Explanation:Preparedstatement&1notfound.

SQL0519SQLCODE-519

SQLSTATE24506

Explanation:Preparedstatement&2inuse.

SQL0520SQLCODE-520

SQLSTATE42828

Explanation:CannotUPDATEorDELETEoncursor&1.

SQL0525SQLCODE-525

SQLSTATE51015

Explanation:Statementnotvalidonapplicationserver.

SQL0527SQLCODE-527

SQLSTATE42874

Explanation:ALWCPYDTA(*NO)specifiedbuttemporaryresultrequiredfor&1.

SQL0530SQLCODE-530

SQLSTATE23503

Explanation:InsertorUPDATEvaluenotallowedbyreferentialconstraint.

SQL0531SQLCODE-531

SQLSTATE23001,23504

Explanation:Updatepreventedbyreferentialconstraint.

SQL0532SQLCODE-532

SQLSTATE23001,23504

Explanation:Deletepreventedbyreferentialconstraint.

SQL0536SQLCODE-536

SQLSTATE42914

Explanation:Deletenotallowedbecausetablereferencedinsubquerycanbeaffected.

SQL0537SQLCODE-537

SQLSTATE42709

Explanation:Duplicatecolumnnameindefinitionofkey.

SQL0538SQLCODE-538

SQLSTATE42830

Explanation:Foreignkeyattributesdonotmatchparentkey.

SQL0539SQLCODE-539

SQLSTATE42888

Explanation:Tabledoesnothaveprimarykey.

SQL0541SQLCODE-541

SQLSTATE42891

Explanation:DuplicateUNIQUEconstraintalreadyexists.

SQL0543SQLCODE-543

SQLSTATE23511

Explanation:Constraint&1conflictswithSETNULLorSETDEFAULTrule.

SQL0544SQLCODE-544

SQLSTATE23512

Explanation:CHECKconstraint&1cannotbeadded.

SQL0545SQLCODE-545

SQLSTATE23513

Explanation:INSERTorUPDATEnotallowedbyCHECKconstraint.

SQL0546SQLCODE-546

SQLSTATE42621

Explanation:CHECKconditionofconstraint&1notvalid.

SQL0551SQLCODE-551

SQLSTATE42501

Explanation:Notauthorizedtoobject&1in&2type*&3.

SQL0552SQLCODE-552

SQLSTATE42502

Explanation:Notauthorizedto&1.

SQL0557SQLCODE-557

SQLSTATE42852

Explanation:Privilegenotvalidfortableorview&1in&2.

SQL0573SQLCODE-573

SQLSTATE42890

Explanation:Tabledoesnothavematchingparentkey.

SQL0574SQLCODE-574

SQLSTATE42894

Explanation:Defaultvaluenotvalid.

SQL0577SQLCODE-577

SQLSTATE38002,2F002

Explanation:ModifyingSQLdatanotpermitted.

SQL0578SQLCODE-578

SQLSTATE2F005

Explanation:RETURNstatementnotexecutedforSQLfunction&1in&2.

SQL0579SQLCODE-579

SQLSTATE38004,2F004

Explanation:ReadingSQLdatanotpermitted.

SQL0580SQLCODE-580

SQLSTATE42625

Explanation:AtleastoneresultinCASEexpressionmustbenotNULL.

SQL0581SQLCODE-581

SQLSTATE42804

Explanation:TheresultsinaCASEexpressionarenotcompatible.

SQL0583SQLCODE-583

SQLSTATE42845

Explanation:Useoffunction&1in&2notvalid.

SQL0585SQLCODE-585

SQLSTATE42732

Explanation:Library&1isusedincorrectlyontheSETPATHstatement

SQL0590SQLCODE-590

SQLSTATE42734

Explanation:Name&1specifiedin&2notunique.

SQL0601SQLCODE-601

SQLSTATE42710

Explanation:Object&1in&2type*&3alreadyexists.

SQL0602SQLCODE-602

SQLSTATE54008

Explanation:Morethan120columnsspecifiedforCREATEINDEX.

SQL0603SQLCODE-603

SQLSTATE23515

Explanation:Uniqueindexcannotbecreatedbecauseofduplicatekeys.

SQL0604SQLCODE-604

SQLSTATE42611

Explanation:Attributesofcolumnnotvalid.

SQL0607SQLCODE-607

SQLSTATE42832

Explanation:Operationnotallowedonsystemtable&1in&2.

SQL0612SQLCODE-612

SQLSTATE42711

Explanation:&1isaduplicatecolumnname.

SQL0613SQLCODE-613

SQLSTATE54008

Explanation:Primaryoruniquekeyconstrainttoolong.

SQL0614SQLCODE-614

SQLSTATE54008

Explanation:LengthofcolumnsforCREATEINDEXtoolong.

SQL0615SQLCODE-615

SQLSTATE55006

Explanation:Object&1in&2type*&3notdropped.Itisinuse.

SQL0616SQLCODE-616

SQLSTATE42893

Explanation:&1in&2type&3cannotbedroppedwithRESTRICT.

SQL0624SQLCODE-624

SQLSTATE42889

Explanation:Tablealreadyhasprimarykey.

SQL0628SQLCODE-628

SQLSTATE42613

Explanation:Clausesaremutuallyexclusive.

SQL0629SQLCODE-629

SQLSTATE42834

Explanation:SETNULLnotallowedforreferentialconstraint.

SQL0631SQLCODE-631

SQLSTATE54008

Explanation:Foreignkeyforreferentialconstrainttoolong.

SQL0637SQLCODE-637

SQLSTATE42614

Explanation:Duplicate&1keyword.

SQL0642SQLCODE-642

SQLSTATE54021

Explanation:Maximumnumberofconstraintsexceeded.

SQL0658SQLCODE-658

SQLSTATE42917

Explanation:Functioncannotbedropped.

SQL0666SQLCODE-666

SQLSTATE57005

Explanation:Estimatedqueryprocessingtimeexceedslimit.

SQL0667SQLCODE-667

SQLSTATE23520

Explanation:Foreignkeydoesnotmatchavalueintheparentkey.

SQL0675SQLCODE-675

SQLSTATE42892

Explanation:Specifieddeleterulenotallowedwithexistingtrigger.

SQL0679SQLCODE-679

SQLSTATE57006

Explanation:Object&1in&2type*&3notcreatedduetopendingoperation.

SQL0683SQLCODE-683

SQLSTATE42842

Explanation:FORDATAorCCSIDclausenotvalidforspecifiedtype.

SQL0707SQLCODE-707

SQLSTATE42939

Explanation:Name&1in&2notallowedfordistincttype.

SQL0713SQLCODE-713

SQLSTATE42815

Explanation:Hostvariablefor&2isNULL.

SQL0724SQLCODE-724

SQLSTATE54038

Explanation:Toomanycascadedtriggerprograms.

SQL0751SQLCODE-751

SQLSTATE42987

Explanation:SQLstatement&1notallowedinstoredprocedureortrigger.

SQL0752SQLCODE-752

SQLSTATE0A001

Explanation:Connectioncannotbechanged.Reasoncodeis&1.

SQL0773SQLCODE-773

SQLSTATE20000

Explanation:CasenotfoundforCASEstatement.

SQL0774SQLCODE-774

SQLSTATE2D522

Explanation:StatementcannotbeexecutedwithinacompoundSQLstatement.

SQL0775SQLCODE-775

SQLSTATE42910

Explanation:StatementnotallowedinacompoundSQLstatement.

SQL0776SQLCODE-776

SQLSTATE428D4

Explanation:Cursor&1specifiedinFORstatementnotallowed.

SQL0777SQLCODE-777

SQLSTATE42919

Explanation:Nestedcompoundstatementsnotallowed.

SQL0778SQLCODE-778

SQLSTATE428D5

Explanation:Endlabel&1notsameasbeginlabel.

SQL0779SQLCODE-779

SQLSTATE42736

Explanation:Label&1specifiedonLEAVEstatementnotvalid.

SQL0780SQLCODE-780

SQLSTATE428D6

Explanation:UNDOspecifiedforahandlerandATOMICnotspecified.

SQL0781SQLCODE-781

SQLSTATE42737

Explanation:Condition&1specifiedinhandlernotdefined.

SQL0782SQLCODE-782

SQLSTATE428D7

Explanation:Conditionvalue&1specifiedinhandlernotvalid.

SQL0783SQLCODE-783

SQLSTATE42738

Explanation:Selectlistforcursor&1inFORstatementnotvalid.

SQL0784SQLCODE-784

SQLSTATE42860

Explanation:Checkconstraint&1cannotbedropped.

SQL0785SQLCODE-785

SQLSTATE428D8

Explanation:UseofSQLCODEorSQLSTATEnotvalid.

SQL0802SQLCODE-802

SQLSTATE22003,22012,22023,22504

Explanation:Dataconversionordatamappingerror.

SQL0803SQLCODE-803

SQLSTATE23505

Explanation:Duplicatekeyvaluespecified.

SQL0804SQLCODE-804

SQLSTATE07002

Explanation:SQLDAnotvalid.

SQL0805SQLCODE-805

SQLSTATE51002

Explanation:SQLpackage&1in&2notfound.

SQL0811SQLCODE-811

SQLSTATE21000

Explanation:ResultofSELECTINTOorsubquerymorethanonerow.

SQL0818SQLCODE-818

SQLSTATE51003

Explanation:Consistencytokensdonotmatch.

SQL0822SQLCODE-822

SQLSTATE51004

Explanation:AddressinSQLDAnotvalid.

SQL0827SQLCODE-827

SQLSTATE42862

Explanation:&1in&2type*SQLPKGcannotbeaccessed.

SQL0840SQLCODE-840

SQLSTATE54004

Explanation:Numberofselecteditemsexceeds8000.

SQL0842SQLCODE-842

SQLSTATE08002

Explanation:Connectionalreadyexists.

SQL0843SQLCODE-843

SQLSTATE08003

Explanation:Connectiondoesnotexist.

SQL0858SQLCODE-858

SQLSTATE08501

Explanation:CannotdisconnectrelationaldatabaseduetoLU6.2protectedconversation.

SQL0862SQLCODE-862

SQLSTATE55029

Explanation:Localprogramattemptedtoconnecttoaremoterelationaldatabase.

SQL0871SQLCODE-871

SQLSTATE54019

Explanation:ToomanyCCSIDvaluesspeci