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

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

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

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