DB2的常见SQLCODE所表示负数的含义

《DB2的常见SQLCODE所表示负数的含义》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、DB2的常见SQLCODE所表示负数的含义SQL0007SQLCODE-07SQLSTATE42601Explanation：Character&1(HEX&2)notvalidinSQLstatement.SQL0010SQLCODETOSQLSTATE42603Explanation：Stringconstantbeginning&1notdelimited.SQL0029SQLCODE-29SQLSTATE42601Explanation：INTOclausemissingfromembedde

2、dSELECTstatement.SQL0051SQLCODE-51SQLSTATE3C000Explanation：Cursororprocedure&1previouslydeclared.SQL0060SQLCODE-60SQLSTATE42815Explanation：Value&3forargument&1of&2functionnotvalid.SQL0078SQLCODE-78SQLSTATE42629Explanation：Parameternamerequiredforroutine

3、&1in&2・SQL0080SQLCODE-80SQLSTATE42978Explanation：Indicatorvariable&1notSMALLINTtype.SQL0084SQLCODE-84SQLSTATE42612Explanation：SQLstatementnotallowed.SQL0090SQLCODE-90SQLSTATE42618Explanation：Hostvariablenotpermittedhere.SQL0097SQLCODE-97SQLSTATE42601Exp

4、lanation：Useofdatatypenotvalid.SQL0099SQLCODE-99SQLSTATE42992Explanation：Relationaldatabase&1notthesameascurrentserver&2・Explanation：Operatorinjoinconditionnotvalid.SQLO1O1SQLCODETOISQLSTATE54001,54010,54011Explanation：SQLstatementtoolongorcomplex.SQL01

5、02SQLCODET02SQLSTATE54002Explanation：Stringconstantbeginningwith&1toolong.SQL0103SQLCODET03SQLSTATE42604Explanation：Numericconstant&1notvalid.SQL0104SQLCODET04SQLSTATE42601Explanation：Token&1wasnotvalid.Validtokens：&2.SQL0105SQLCODET05SQLSTATE42604Expla

6、nation：Mixedorgraphicstringconstantnotvalid.SQL0106SQLCODE706SQLSTATE42611Explanation：PrecisionspecifiedforFLOATcolumnnotvalid.SQL0107SQLCODE-107SQLSTATE42622Explanation：&1toolong.Maximum&2characters.SQL0109SQLCODE-109SQLSTATE42601Explanation：&1clauseno

7、tallowed.SQL0110SQLCODE-110SQLSTATE42606Explanation：Hexadecimalconstantbeginningwith&1notvalid.SQL0U2SQLCODET12SQLSTATE42607Explanation:Argumentoffunction&1isanotherfunction.SQL0113SQLCODET13SQLSTATE28000,2E000,42602Explanation：Name&1notallowed.SQL0114S

8、QLCODET14SQLSTATE42961Explanation：Relationaldatabase&1notthesameascurrentserver&2・SQL0U5SQLCODET15SQLSTATE42601Explanation：Comparisonoperator&1notvalid.SQL0117SQLCODET17SQLSTATE42802Explanation：Statementinsertswrongnumberofvalues