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

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

《DB2的常见SQLCODE所表示负数的含义.docx》由会员分享，可在线阅读，更多相关《DB2的常见SQLCODE所表示负数的含义.docx（58页珍藏版）》请在冰豆网上搜索。

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

.

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

SQL0007SQLCODE-07SQLSTATE42601

Explanation:

Character&1（HEX&2）notvalidinSQLstatement.

SQL0010SQLCODE-10SQLSTATE42603

Explanation:

Stringconstantbeginning&1notdelimited.

SQL0029SQLCODE-29SQLSTATE42601

Explanation:

INTOclausemissingfromembeddedSELECTstatement.

SQL0051SQLCODE-51SQLSTATE3C000

Explanation:

Cursororprocedure&1previouslydeclared.

SQL0060SQLCODE-60SQLSTATE42815

Explanation:

Value&3forargument&1of&2functionnotvalid.

SQL0078SQLCODE-78SQLSTATE42629

Explanation:

Parameternamerequiredforroutine&1in&2.

SQL0080SQLCODE-80SQLSTATE42978

Explanation:

Indicatorvariable&1notSMALLINTtype.

SQL0084SQLCODE-84SQLSTATE42612

Explanation:

SQLstatementnotallowed.

SQL0090SQLCODE-90SQLSTATE42618

文档Word

.

Explanation:

Hostvariablenotpermittedhere.

SQL0097SQLCODE-97SQLSTATE42601

Explanation:

Useofdatatypenotvalid.

SQL0099SQLCODE-99SQLSTATE42992

Explanation:

Operatorinjoinconditionnotvalid.

SQL0101SQLCODE-101SQLSTATE54001,54010,54011

Explanation:

SQLstatementtoolongorcomplex.

SQL0102SQLCODE-102SQLSTATE54002

Explanation:

Stringconstantbeginningwith&1toolong.

SQL0103SQLCODE-103SQLSTATE42604

Explanation:

Numericconstant&1notvalid.

SQL0104SQLCODE-104SQLSTATE42601

Explanation:

Token&1wasnotvalid.Validtokens:

&2.

SQL0105SQLCODE-105SQLSTATE42604

Explanation:

Mixedorgraphicstringconstantnotvalid.

SQL0106SQLCODE-106SQLSTATE42611

Explanation:

PrecisionspecifiedforFLOATcolumnnotvalid.

文档Word

.

SQL0107SQLCODE-107SQLSTATE42622

Explanation:

&1toolong.Maximum&2characters.

SQL0109SQLCODE-109SQLSTATE42601

Explanation:

&1clausenotallowed.

SQL0110SQLCODE-110SQLSTATE42606

Explanation:

Hexadecimalconstantbeginningwith&1notvalid.

SQL0112SQLCODE-112SQLSTATE42607

Explanation:

Argumentoffunction&1isanotherfunction.

SQL0113SQLCODE-113SQLSTATE28000,2E000,42602

Explanation:

Name&1notallowed.

SQL0114SQLCODE-114SQLSTATE42961

Explanation:

Relationaldatabase&1notthesameascurrentserver&2.

SQL0115SQLCODE-115SQLSTATE42601

Explanation:

Comparisonoperator&1notvalid.

SQL0117SQLCODE-117SQLSTATE42802

Explanation:

Statementinsertswrongnumberofvalues.

SQL0118SQLCODE-118SQLSTATE42902

Explanation:

Table&1in&2alsospecifiedinaFROMclause.

文档Word

.

SQL0119SQLCODE-119SQLSTATE42803

Explanation:

Column&1inHAVINGclausenotinGROUPBY.

SQL0120SQLCODE-120SQLSTATE42903

Explanation:

Useofcolumnfunction&2notvalid.

SQL0121SQLCODE-121SQLSTATE42701

Explanation:

Duplicatecolumnname&1inINSERTorUPDATE.

SQL0122SQLCODE-122SQLSTATE42803

Explanation:

ColumnspecifiedinSELECTlistnotvalid.

SQL0125SQLCODE-125SQLSTATE42805

Explanation:

ORDERBYcolumnnumber&1notvalid.

SQL0128SQLCODE-128SQLSTATE42601

Explanation:

UseofNULLisnotvalid.

SQL0129SQLCODE-129SQLSTATE54004

Explanation:

ToomanytablesinSQLstatement.

SQL0130SQLCODE-130SQLSTATE22019,22025

Explanation:

Escapecharacter&1orLIKEpatternnotvalid.

SQL0131SQLCODE-131SQLSTATE42818

文档Word

.

Explanation:

OperandsofLIKEnotcompatibleornotvalid.

SQL0132SQLCODE-132SQLSTATE42824

Explanation:

LIKEpredicatenotvalid.

SQL0133SQLCODE-133SQLSTATE42906

Explanation:

OperatoroncorrelatedcolumninSQLfunctionnotvalid.

SQL0134SQLCODE-134SQLSTATE42907

Explanation:

Argumentoffunctiontoolong.

SQL0136SQLCODE-136SQLSTATE54005

Explanation:

ORDERBYorGROUPBYcolumnstoolong.

SQL0137SQLCODE-137SQLSTATE54006

Explanation:

Resulttoolong.

SQL0138SQLCODE-138SQLSTATE22011

Explanation:

Argument&1ofSUBSTRfunctionnotvalid.

SQL0144SQLCODE-144SQLSTATE58003

Explanation:

Sectionnumbernotvalid.

SQL0145SQLCODE-145SQLSTATE55005

Explanation:

RecursionnotsupportedforanapplicationserverotherthantheAS/400system.

SQL0150SQLCODE-150SQLSTATE42807

文档Word

.

Explanation:

Vieworlogicalfile&1in&2read-only.

SQL0151SQLCODE-151SQLSTATE42808

Explanation:

Column&1intable&2in&3read-only.

SQL0152SQLCODE-152SQLSTATE42809

Explanation:

Constrainttypenotvalidforconstraint&1in&2.

SQL0153SQLCODE-153SQLSTATE4