DB2错误码及信息.docx

DB2错误码及信息.docx

《DB2错误码及信息.docx》由会员分享，可在线阅读，更多相关《DB2错误码及信息.docx（8页珍藏版）》请在冰豆网上搜索。

DB2错误码及信息

DB2错误码及信息

∙0

Thisisasuccessfulrun.

∙-60

Thelengthorscaleisnotvalid.

∙-84

TheSQLstatementcannotbeexecuted.

∙-102

Theliteralstringistoolong.Themaximumallowablesizeissize.Thestringbeginswithstring.

∙-104

tokenisanincorrecttoken.

∙-107

Thename,nameistoolong.Themaximumallowablesizeissize.

∙-109

clauseclauseisnotpermitted.

∙-112

Theoperandofacolumnfunctionisanothercolumnfunction.

∙-113

Thereisanincorrectcharacterin:

string,reasoncodennn.

∙-117

Thenumberofinsertcolumnsmustmatchthenumberofinsertvalues.

∙-119

AcolumnthatwasidentifiedinaHAVINGclausemustbeincludedintheGROUPBYclause.

∙-120

AWHEREclauseorSETclauseincludesanaggregatecolumnfunction.

∙-121

AnINSERTorUPDATEstatementreferencesacolumnforupdatemultipletimes.

∙-122

TheSELECTstatementwithanoGROUPBYclausecontainsacolumnnameandacolumnfunctionintheSELECTclause,oracolumnnameiscontainedintheselectclause,butnotintheGROUPBYclause.

∙-125

AnintegerintheORDERBYclausemustidentifyacolumnoftheresult.

∙-126

TheSELECTstatementcontainsbothanORDERBYclauseandanUPDATEclause.

∙-127

TheDISTINCTqualifierisspecifiedmorethanonceinasubselect.

∙-129

Therearetoomanytablesreferencedinasinglequery.

∙-134

ThereisanimproperuseoftheLONGSTRINGCOLUMNorahostvariableofaMAXIMUMLENGTHgreaterthan254.

∙-138

TheSUBSTRINGargumentisnotvalid.

∙-150

AnINSERT,UPDATE,orDELETEstatementwasissuedonaview.

∙-151

AnUPDATEwasissuedonanon-updateablecolumn.

∙-153

ACREATEVIEWstatementmusthaveacolumn-namelist.

∙-156

ThetargetofaMAPINDEXstatementmustbeatable.

∙-158

Thecolumnlistforviewisnotvalid.

∙-170

Thenumberofargumentsisnotvalid.

∙-171

Thefunctionargumentisnotvalid.

∙-181

ThestringrepresentationofaDATETIMEvalueisnotvalid.

∙-182

AnarithmeticexpressionwithaDATETIMEvalueisnotvalid.

∙-183

AnarithmeticoperationonaDATEorTIMESTAMPvalueproducedavaluethatisoutoftherangeofthevaliddates.

∙-185

TheLOCALdateandtimeformatisnotsupported.

∙-199

Thekeyword,keywordisnotvalid.

∙-203

Areferencetoacolumnnameisambiguous.

∙-204

Thenameisanundefinedname.

∙-205

Thecolumn,column-nameisnotacolumninthetable,table-name.

∙-206

Thecolumn-namemustbeacolumninaninsertedtable,updatedtable,oranytablethatisidentifiedinaFROMclause.

∙-208

AcolumnthatisnotvalidisincludedintheORDERBYclause.

∙-300

Thehostvariableisnotnullterminated.

∙-301

Theinput-hostvariabletypeisnotvalid.

∙-302

Thehostvariableisnotvalidortoolargeforthetargetcolumn.

∙-303

Theoutput-hostvariabletypeisnotvalid.

∙-304

ConversionofSQLdatatypewouldresultintruncatedvalue.

∙-305

Anoutput-indicatorvariablewasnotgiven.

∙-312

CREATEVIEWstatementcontainsparametermarkersorhostvariables.

∙-313

Thenumberofhostvariablesisincorrect.

∙-338

TheONclauseforatablejoinisnotvalid.

∙-401

Theoperandsofanarithmeticorcomparisonoperationarenotcomparable.

∙-402

Anexpressioninaselectlistcontainsoperandsthatarenotcompatible.

∙-405

Thenumericliteralisoutofrange.

∙-407

AnUPDATEorINSERTvalueisNULL,andthetargetcolumnisdefinedasNOTNULL.

∙-408

AnUPDATEorINSERTvalueisnotcompatiblewiththedatatypeofthetargetcolumn.

∙-412

TheSELECTCLAUSEofasubqueryspecifiesmultiplecolumns.

∙-415

ThecorrespondingcolumnsineachtableofaUNIONdonothavethecompatibledatatypes.

∙-416

ThereisanoperandofaUNIONthatcontainsalongSQLcolumn.

∙-419

Thedecimal-divideoperationisnotvalid.

∙-420

Thereisanincorrectdecimalstring.

∙-421

TheoperandsofaUNIONdonothavethesamenumberofresultcolumns.

∙-444

Thestoredprocedurefailedtoload.

∙-469

ThestoredproceduredefinitionincludesoneormoreOUTPUTparametersforwhichnohostvariablewaspassed.

∙-501

ThecursorthatisidentifiedinaFETCHorCLOSEstatementisnotopen.

∙-502

ThecursorthatisidentifiedinanOPENstatementisalreadyopen.

∙-504

Thecursornameisnotdefined.

∙-514

Thecursorisnotinapreparedstate.

∙-516

TheDESCRIBEstatementdoesnotidentifyaPREPAREDstatement.

∙-517

ThestatementthatisnamedinthedeclarationforthecursormustbeaSELECTstatement.

∙-518

Thestatementisnotprepared.

∙-519

ThePREPAREstatementidentifiestheSELECTstatementoftheopenedcursor.

∙-530

Theforeignkeywasincorrect.Theinsertpositioningfailedonamulti-recordmappedtable.

∙-537

Theprimarykeyclauseidentifiesthecolumn,column-namemorethanonce.

∙-542

Thecolumn-namecannotbeacolumnofaprimarykeybecauseitcancontainnullvalues.

∙-551

PrivilegesarenecessarytoruntheSQLstatement.

∙-601

Thenameoftheobjecttobecreatedcannotbeidenticaltotheexistingname.

∙-602

TheCREATEINDEXstatementspecifiestoomanycolumns（numberisthemaximum）.

∙-604

Adatatypedefinitionspecifiesanincorrectlength,precision,orscaleattributeforcolumn-name.

∙-607

AnINSERT,UPDATE,orDELETEstatementwasissuedonanon-updateabletable.

∙-612

Aduplicatecolumnnameisspecified.

∙-637

Duplicatekeyword.keyword.

∙-638

Thetable,table,cannotbecreatedbecauseacolumndefinitionismissing.

∙-644

Anincorrectvalue,value,isspecifiedforthekeywordorclause,keyword-or-clauseinthestatement,stmt-type.

∙-681

Anerroroccurredwhileacolumninafieldprocedurewasbeingencodedordecoded.

∙-682

Theprogramcannotloadthefieldprocedure.

∙-802

TheSQLstatementcausedadataexceptionerror.

∙-803

Duplicatekeysweredetectedontabletable-name.

∙-804

TheinputSQLDAisincorrect.

∙-811

Theresultsofasubselectproducedmorethanonerow.

∙-817

Anupdateisprohibited.Atwo-phase-commitsituationoracatalogupdatestatement（DDL）wasissuedwhileanotherconnectortransactionwasincomplete.

∙-870

Thenumberofhostvariablesisincorrect.

∙-904

AnunavailableresourcepreventedtheSQLstatementfromrunning.

∙-922

Authorizationfortheconnectionfailed.

∙-4901

Thecursorlimitwasexceeded.

∙-4902

Thememorylimitwasexceeded.

∙-4903

TheSQLstatementisunsupported.

∙-4904

TheSQLfunctionorexpressionisnotsupported.

∙-4905

Aninternalprocessingerroroccurred.

∙-4906

Theconversionisnotvalid.

∙-4907

Aninternalcatalogerroroccurredwhilereadingorupdatingthesystemcatalog.

∙-4908

Themappeddataisnotvalid.

∙-4909

ADDLEXmappingerroroccurred.

∙-4910

Anerroroccurredduringaconnectorupdatethatrequiredabackoutofthecurrenttransaction.

∙-4911

Thestatementprocessingwascancelled.