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

本文格式為Word版，下載可任意編輯——DB2的常見SQLCODE所表示負(fù)數(shù)的含義

Explanation:Vieworlogicalfilecursor&1notdeclaredwithSCROLL.

SQL0226SQLCODE-226SQLSTATE24507

Explanation:Currentrowdeletedormovedforcursor&1.

SQL0227SQLCODE-227SQLSTATE24513

Explanation:FETCHnotvalid,cursor&1inunknownposition.

SQL0228SQLCODE-228SQLSTATE42620

Explanation:FORUPDATEOFclausenotvalidwithSCROLLforcursor&1.

SQL0231SQLCODE-231SQLSTATE22023

Explanation:Positionofcursor&1notvalidforFETCHofcurrentrow.

SQL0250SQLCODE-250SQLSTATE42718

Explanation:Localrelationaldatabasenotdefinedinthedirectory.

SQL0251SQLCODE-251SQLSTATE2E000,42602

Explanation:Characterinrelationaldatabasename&1isnotvalid.

SQL0255SQLCODE-255SQLSTATE42999

Explanation:DB2Multisystemqueryerror.

SQL0256SQLCODE-256SQLSTATE42998

Explanation:Constraint&1in&2notallowedondistributedfile.

SQL0270SQLCODE-270SQLSTATE42997

Explanation:Uniqueindexnotallowed.

SQL0301SQLCODE-301SQLSTATE07006,42895

Explanation:Inputhostvariable&2orargument&1notvalid.

SQL0302SQLCODE-302SQLSTATE22023,22023,22023,22024

Explanation:Conversionerroroninputhostvariable&2.

SQL0303SQLCODE-303SQLSTATE22023,42806

Explanation:Hostvariable&1notcompatiblewithSELECTitem.

SQL0304SQLCODE-304SQLSTATE22023,22023,22504

Explanation:Conversionerrorinassignmenttohostvariable&2.

SQL0305SQLCODE-305SQLSTATE22023

Explanation:Indicatorvariablerequired.

SQL0306SQLCODE-306SQLSTATE42863

Explanation:UndefinedhostvariableinREXX.

SQL0311SQLCODE-311SQLSTATE22501

Explanation:Lengthinavarying-lengthhostvariablenotvalid.

SQL0312SQLCODE-312SQLSTATE42618

Explanation:Hostvariable&1notdefinedornotusable.

SQL0313SQLCODE-313SQLSTATE07001,07004

Explanation:Numberofhostvariablesnotvalid.

SQL0328SQLCODE-328SQLSTATE42996

Explanation:Column&1notallowedinpartitioningkey.

SQL0329SQLCODE-329SQLSTATE0E000

Explanation:TheSETPATHnamelistisnotvalid.

SQL0330SQLCODE-330SQLSTATE22023

Explanation:Characterconversioncannotbeperformed.

SQL0331SQLCODE-331SQLSTATE22023

Explanation:Characterconversioncannotbeperformed.

SQL0332SQLCODE-332SQLSTATE57017

Explanation:CharacterconversionbetweenCCSID&1andCCSID&2notvalid.

SQL0334SQLCODE-334SQLSTATE22524

Explanation:Characterconversionhasresultedintruncation.

SQL0338SQLCODE-338SQLSTATE42972

Explanation:JOINexpressionnotvalid.

SQL0340SQLCODE-340SQLSTATE42726

Explanation:Duplicatename&1forcommontableexpression.

SQL0341SQLCODE-341SQLSTATE42835

Explanation:Cyclicreferencesbetweencommontableexpressions.

SQL0346SQLCODE-346SQLSTATE42836

Explanation:Recursionnotallowedforcommontableexpressions.

SQL0350SQLCODE-350SQLSTATE42962

Explanation:Column&1isnotvalidaskeyfieldforindexorconstraint.

SQL0351SQLCODE-351SQLSTATE56084

Explanation:TheARisnotatthesamelevelandDB2/400cannottransformthedatatypetoacompatibletype.

SQL0352SQLCODE-352SQLSTATE56084

Explanation:TheASisnotatthesamelevelandDB2/400cannottransformthedatatypetoacompatibletype.

SQL0357SQLCODE-357SQLSTATE57050

Explanation:Fileserver&1usedinDataLinknotcurrentlyavailable.

SQL0358SQLCODE-358SQLSTATE428D1

Explanation:Error&1occurredusingDataLinkdatatype.

SQL0392SQLCODE-392SQLSTATE42855

Explanation:AssignmentofLOBtospecifiedhostvariablenotallowed.

SQL0398SQLCODE-398SQLSTATE428D2

Explanation:ASLOCATORcannotbespecifiedforanon-LOBparameter.

SQL0401SQLCODE-401SQLSTATE42818

Explanation:Comparisonoperator&1operandsnotcompatible.

SQL0402SQLCODE-402SQLSTATE42819

Explanation:&1usenotvalid.

SQL0404SQLCODE-404SQLSTATE22023

Explanation:Valueforcolumn&1toolong.

SQL0405SQLCODE-405SQLSTATE42820

Explanation:Numericconstant&1outofrange.

SQL0406SQLCODE-406SQLSTATE22023,22023,22504

Explanation:Conversionerroronassignmenttocolumn&2.

SQL0407SQLCODE-407SQLSTATE23502

Explanation:Nullvaluesarenotallowedincolumn&1.

SQL0408SQLCODE-408SQLSTATE42821

Explanation:INSERTorUPDATEvalueforcolumn&1notcompatible.

SQL0410SQLCODE-410SQLSTATE42820

Explanation:Floatingpointliteral&1notvalid.

SQL0412SQLCODE-412SQLSTATE42823

Explanation:Subquerywithmorethanoneresultcolumnnotvalid.

SQL0414SQLCODE-414SQLSTATE42824

Explanation:Column&1notvalidinLIKEpredicate.

SQL0415SQLCODE-415SQLSTATE42825

Explanation:UNIONoperandsnotcompatible.

SQL0417SQLCODE-417SQLSTATE42609

Explanation:Combinationofparametermarkersnotvalid.

SQL0418SQLCODE-418SQLSTATE42610

Explanation:Useofparametermarkerisnotvalid.

SQL0509SQLCODE-509SQLSTATE42827

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

SQL0510SQLCODE-510SQLSTATE42828

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

SQL0511SQLCODE-511SQLSTATE42829

Explanation:FORUPDATEOFclausenotvalid.

SQL0513SQLCODE-513SQLSTATE42924

Explanation:Alias&1in&2cannotreferenceanotheralias.

SQL0514SQLCODE-514SQLSTATE26501

Explanation:Preparedstatement&2notfound.

SQL0516SQLCODE-516SQLSTATE26501

Explanation:Preparedstatement&2notfound.

SQL0517SQLCODE-517SQLSTATE07005

Explanation:Preparedstatement&2notSELECTstatement.

SQL0518SQLCODE-518SQLSTATE07003

Explanation:Preparedstatement&1notfound.

SQL0519SQLCODE-519SQLSTATE24506

Explanation:Preparedstatement&2inuse.

SQL0520SQLCODE-520SQLSTATE42828

Explanation:CannotUPDATEorDELETEoncursor&1.

SQL0525SQLCODE-525SQLSTATE51015

Explanation:Statementnotvalidonapplicationserver.

SQL0527SQLCODE-527SQLSTATE42874

Explanation:ALWCPYDTA(*NO)specifiedbuttemporaryresultrequiredfor&1.

SQL0530SQLCODE-530SQLSTATE23503

Explanation:InsertorUPDATEvaluenotallowedbyreferentialconstraint.

SQL0531SQLCODE-531SQLSTATE23001,23504

Explanation:Updatepreventedbyreferentialconstraint.

SQL0532SQLCODE-532SQLSTATE23001,23504

Explanation:Deletepreventedbyreferentialconstraint.

SQL0536SQLCODE-536SQLSTATE42914

Explanation:Deletenotallowedbecausetablereferencedinsubquerycanbeaffected.

SQL0537SQLCODE-537SQLSTATE42709

Explanation:Duplicatecolumnnameindefinitionofkey.

SQL0538SQLCODE-538SQLSTATE42830

Explanation:Foreignkeyattributesdonotmatchparentkey.

SQL0539SQLCODE-539SQLSTATE42888

Explanation:Tabledoesnothaveprimarykey.

SQL0541SQLCODE-541SQLSTATE42891

Explanation:DuplicateUNIQUEconstraintalreadyexists.

SQL0543SQLCODE-543SQLSTATE23511

Explanation:Constraint&1conflictswithSETNULLorSETDEFAULTrule.

SQL0544SQLCODE-544SQLSTATE23512

Explanation:CHECKconstraint&1cannotbeadded.

SQL0545SQLCODE-545SQLSTATE23513

Explanation:INSERTorUPDATEnotallowedbyCHECKconstraint.

SQL0546SQLCODE-546SQLSTATE42621

Explanation:CHECKconditionofconstraint&1notvalid.

SQL0551SQLCODE-551SQLSTATE42501

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

SQL0552SQLCODE-552SQLSTATE42502

Explanation:Notauthorizedto&1.

SQL0557SQLCODE-557SQLSTATE42852

Explanation:Privilegenotvalidfortableorview&1in&2.

SQL0573SQLCODE-573SQLSTATE42890

Explanation:Tabledoesnothavematchingparentkey.

SQL0574SQLCODE-574SQLSTATE42894

Explanation:Defaultvaluenotvalid.

SQL0577SQLCODE-577SQLSTATE38002,2F002

Explanation:ModifyingSQLdatanotpermitted.

SQL0578SQLCODE-578SQLSTATE2F005

Explanation:RETURNstatementnotexecutedforSQLfunction&1in&2.

SQL0579SQLCODE-579SQLSTATE38004,2F004

Explanation:ReadingSQLdatanotpermitted.

SQL0580SQLCODE-580SQLSTATE42625

Explanation:AtleastoneresultinCASEexpressionmustbenotNULL.

SQL0581SQLCODE-581SQLSTATE42804

Explanation:TheresultsinaCASEexpressionarenotcompatible.

SQL0583SQLCODE-583SQLSTATE42845

Explanation:Useoffunction&1in&2notvalid.

SQL0585SQLCODE-585SQLSTATE42732

Explanation:Library&1isusedincorrectlyontheSETPATHstatement

SQL0590SQLCODE-590SQLSTATE42734

Explanation:Name&1specifiedin&2notunique.

SQL0601SQLCODE-601SQLSTATE42710

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

SQL0602SQLCODE-602SQLSTATE54008

Explanation:Morethan120columnsspecifiedforCREATEINDEX.

SQL0603SQLCODE-603SQLSTATE23515

Explanation:Uniqueindexcannotbecreatedbecauseofduplicatekeys.

SQL0604SQLCODE-604SQLSTATE42611

Explanation:Attributesofcolumnnotvalid.

SQL0607SQLCODE-607SQLSTATE42832

Explanation:Operationnotallowedonsystemtable&1in&2.

SQL0612SQLCODE-612SQLSTATE42711

Explanation:&1isaduplicatecolumnname.

SQL0613SQLCODE-613SQLSTATE54008

Explanation:Primaryoruniquekeyconstrainttoolong.

SQL0614SQLCODE-614SQLSTATE54008

Explanation:LengthofcolumnsforCREATEINDEXtoolong.

SQL0615SQLCODE-615SQLSTATE55006

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

SQL0616SQLCODE-616SQLSTATE42893

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

SQL0624SQLCODE-624SQLSTATE42889

Explanation:Tablealreadyhasprimarykey.

SQL0628SQLCODE-628SQLSTATE42613

Explanation:Clausesaremutuallyexclusive.

SQL0629SQLCODE-629SQLSTATE42834

Explanation:SETNULLnotallowedforreferentialconstraint.

SQL0631SQLCODE-631SQLSTATE54008

Explanation:Foreignkeyforreferentialconstrainttoolong.

SQL0637SQLCODE-637SQLSTATE42614

Explanation:Duplicate&1keyword.

SQL0642SQLCODE-642SQLSTATE54021

Explanation:Maximumnumberofconstraintsexceeded.

SQL0658SQLCODE-658SQLSTATE42917

Explanation:Functioncannotbedropped.

SQL0666SQLCODE-666SQLSTATE57005

Explanation:Estimatedqueryprocessingtimeexceedslimit.

SQL0667SQLCODE-667SQLSTATE23520

Explanation:Foreignkeydoesnotmatchavalueintheparentkey.

SQL0675SQLCODE-675SQLSTATE42892

Explanation:Specifieddeleterulenotallowedwithexistingtrigger.

SQL0679SQLCODE-679SQLSTATE57006

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

SQL0683SQLCODE-683SQLSTATE42842

Explanation:FORDATAorCCSIDclausenotvalidforspecifiedtype.

SQL0707SQLCODE-707SQLSTATE42939

Explanation:Name&1in&2notallowedfordistincttype.

SQL0713SQLCODE-713SQLSTATE42815

Explanation:Hostvariablefor&2isNULL.

SQL0724SQLCODE-724SQLSTATE54038

Explanation:Toomanycascadedtriggerprograms.

SQL0751SQLCODE-751SQLSTATE42987

Explanation:SQLstatement&1notallowedinstoredprocedureortrigger.

SQL0752SQLCODE-752SQLSTATE0A001

Explanation:Connectioncannotbechanged.Reasoncodeis&1.

SQL0773SQLCODE-773SQLSTATE20000

Explanation:CasenotfoundforCASEstatement.

SQL0774SQLCODE-774SQLSTATE2D522

Explanation:StatementcannotbeexecutedwithinacompoundSQLstatement.

SQL0775SQLCODE-775SQLSTATE42910

Explanation:StatementnotallowedinacompoundSQLstatement.

SQL0776SQLCODE-776SQLSTATE428D4

Explanation:Cursor&1specifiedinFORstatementnotallowed.

SQL0777SQLCODE-777SQLSTATE42919

Explanation:Nestedcompoundstatementsnotallowed.

SQL0778SQLCODE-778SQLSTATE428D5

Explanation:Endlabel&1notsameasbeginlabel.

SQL0779SQLCODE-779SQLSTATE42736

Explanation:Label&1specifiedonLEAVEstatementnotvalid.

SQL0780SQLCODE-780SQLSTATE428D6

Explanation:UNDOspecifiedforahandlerandATOMICnotspecified.

SQL0781SQLCODE-781SQLSTATE42737

Explanation:Condition&1specifiedinhandlernotdefined.

SQL0782SQLCODE-782SQLSTATE428D7

Explanation:Conditionvalue&1specifiedinhandlernotvalid.

SQL0783SQLCODE-783SQLSTATE42738

Explanation:Selectlistforcursor&1inFORstatementnotvalid.

SQL0784SQLCODE-784SQLSTATE42860

Explanation:Checkconstraint&1cannotbedropped.

SQL0785SQLCODE-785SQLSTATE428D8

Explanation:UseofSQLCODEorSQLSTATEnotvalid.

SQL0802SQLCODE-802SQLSTATE22023,22023,22023,22504

Explanation:Dataconversionordatamappingerror.

SQL0803SQLCODE-803SQLSTATE23505

Explanation:Duplicatekeyvaluespecified.

SQL0804SQLCODE-804SQLSTATE07002

Explanation:SQLDAnotvalid.

SQL0805SQLCODE-805SQLSTATE51002

Explanation:SQLpackage&1in&2notfound.

SQL0811SQLCODE-811SQLSTATE21000

Explanation:ResultofSELECTINTOorsubquerymorethanonerow.

SQL0818SQLCODE-818SQLSTATE51003

Explanation:Consistencytokensdonotmatch.

SQL0822SQLCODE-822SQLSTATE51004

Explanation:AddressinSQLDAnotvalid.

SQL0827SQLCODE-827SQLSTATE42862

Explanation:&1in&2type*SQLPKGcannotbeaccessed.

SQL0840SQLCODE-840SQLSTATE54004

Explanation:Numberofselecteditemsexceeds8000.

SQL0842SQLCODE-842SQLSTATE08002

Explanation:Connectionalreadyexists.

SQL0843SQLCODE-843SQLSTATE08003

Explanation:Connectiondoesnotexist.

SQL0858SQLCODE-858SQLSTATE08501

Explanation:CannotdisconnectrelationaldatabaseduetoLU6.2protectedconversation.

SQL0862SQLCODE-862SQLSTATE55029

Explanation:Localprogramattemptedtoconnecttoaremoterelationaldatabase.

SQL0871SQLCODE-871SQLSTATE54019

Explanation:ToomanyCCSIDvaluesspecified.

SQL0900SQLCODE-900SQLSTATE08003

Explanation:Applicationprocessnotinaconnectedstate.

SQL0901SQLCODE-901SQLSTATE58004

Explanation:SQLsystemerror.

SQL0904SQLCODE-904SQLSTATE57011

Explanation:Resourcelimitexceeded.

SQL0906SQLCODE-906SQLSTATE24514

Explanation:Operationnotperformedbecauseofpreviouserror.

SQL0907SQLCODE-907SQLSTATE27000

Explanation:Attempttochangesamerowtwice.

SQL0910SQLCODE-910SQLSTATE57007

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

SQL0913SQLCODE-913SQLSTATE57033

Explanation:Roworobject&1in&2type*&3inuse.

SQL0917SQLCODE-917SQLSTATE42969

Explanation:Packagenotcreated.

SQL0918SQLCODE-918SQLSTATE51021

Explanation:Rollbackrequired.

SQL0950SQLCODE-950SQLSTATE42705

Explanation:Relationaldatabase&1notinrelationaldatabasedirectory.

SQL0951SQLCODE-951SQLSTATE55007

Explanation:Object&1in&2notaltered.Itisinuse.

SQL0952SQLCODE-952SQLSTATE57014

Explanation:ProcessingoftheSQLstatementendedbyENDRDBRQScommand.

SQL0969SQLCODE-969SQLSTATE58033

Explanation:Unexpectedclientdrivererror.

SQL0971SQLCODE-971SQLSTATE57011

Explanation:Referentialconstraint&4incheckpendingstate.

SQL5001SQLCODE-5001SQLSTATE42703

Explanation:Columnqualifier&2undefined.

SQL5002SQLCODE-5002SQLSTATE42812

Explanation:Collectionmustbespecifiedfortable&1.

SQL5003SQLCODE-5003SQLSTATE42922

Explanation:Cannotperformoperationundercommitmentcontrol.

SQL5005SQLCODE-5005SQLSTATE42815

Explanation:Operator&4notconsistentwithoperands.

SQL5012SQLCODE-5012SQLSTATE42618

Explanation:Hostvariablenotanumericwithzeroscale.

SQL5016SQLCODE-5016SQLSTATE42833

Explanation:Objectname&1notvalidfornamingoption.

SQL5021SQLCODE-5021SQLSTATE42930

Explanation:FORUPDATEOFcolumn&1alsoinORDERBY.

SQL5023SQLCODE-5023SQLSTATE26510

Explanation:DuplicatestatementnameinDECLARECURSOR.

SQL5024SQLCODE-5024SQLSTATE42618

Explanat