DB2错误码及信息Word格式.docx
《DB2错误码及信息Word格式.docx》由会员分享,可在线阅读,更多相关《DB2错误码及信息Word格式.docx(8页珍藏版)》请在冰豆网上搜索。
∙-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.