DB2的常见SQLCODE所表示负数的含义.docx
《DB2的常见SQLCODE所表示负数的含义.docx》由会员分享,可在线阅读,更多相关《DB2的常见SQLCODE所表示负数的含义.docx(34页珍藏版)》请在冰豆网上搜索。
![DB2的常见SQLCODE所表示负数的含义.docx](https://file1.bdocx.com/fileroot1/2022-11/17/1ab6fb0f-c1a9-43c7-b041-780b57efafe8/1ab6fb0f-c1a9-43c7-b041-780b57efafe81.gif)
DB2的常见SQLCODE所表示负数的含义
DB2的常见SQLCODE所表示负数的含义
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.
SQL0