DB2的常见SQLCODE所表示负数的含义Word文档格式.docx

DB2的常见SQLCODE所表示负数的含义Word文档格式.docx

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

SQLSTATE3C000 

Cursororprocedure&

1previouslydeclared.

SQL0060SQLCODE-60 

SQLSTATE42815 

Value&

3forargument&

1of&

2functionnotvalid.

SQL0078SQLCODE-78 

SQLSTATE42629 

Parameternamerequiredforroutine&

1in&

2.

SQL0080SQLCODE-80 

SQLSTATE42978 

Indicatorvariable&

1notSMALLINTtype.

SQL0084SQLCODE-84 

SQLSTATE42612 

SQLstatementnotallowed.

SQL0090SQLCODE-90 

SQLSTATE42618 

Hostvariablenotpermittedhere.

SQL0097SQLCODE-97 

Useofdatatypenotvalid.

SQL0099SQLCODE-99 

SQLSTATE42992 

Operatorinjoinconditionnotvalid.

SQL0101SQLCODE-101 

SQLSTATE54001,54010,54011 

SQLstatementtoolongorcomplex.

SQL0102SQLCODE-102 

SQLSTATE54002 

Stringconstantbeginningwith&

1toolong.

SQL0103SQLCODE-103 

SQLSTATE42604 

Numericconstant&

1notvalid.

SQL0104SQLCODE-104 

Token&

1wasnotvalid.Validtokens:

&

SQL0105SQLCODE-105 

Mixedorgraphicstringconstantnotvalid.

SQL0106SQLCODE-106 

SQLSTATE42611 

PrecisionspecifiedforFLOATcolumnnotvalid.

SQL0107SQLCODE-107 

SQLSTATE42622 

1toolong.Maximum&

2characters.

SQL0109SQLCODE-109 

1clausenotallowed.

SQL0110SQLCODE-110 

SQLSTATE42606 

Hexadecimalconstantbeginningwith&

SQL0112SQLCODE-112 

SQLSTATE42607 

Argumentoffunction&

1isanotherfunction.

SQL0113SQLCODE-113 

SQLSTATE28000,2E000,42602 

Name&

1notallowed.

SQL0114SQLCODE-114 

SQLSTATE42961 

Relationaldatabase&

1notthesameascurrentserver&

SQL0115SQLCODE-115 

Comparisonoperator&

SQL0117SQLCODE-117 

SQLSTATE42802 

Statementinsertswrongnumberofvalues.

SQL0118SQLCODE-118 

SQLSTATE42902 

Table&

2alsospecifiedinaFROMclause.

SQL0119SQLCODE-119 

SQLSTATE42803 

Column&

1inHAVINGclausenotinGROUPBY.

SQL0120SQLCODE-120 

SQLSTATE42903 

Useofcolumnfunction&

2notvalid.

SQL0121SQLCODE-121 

SQLSTATE42701 

Duplicatecolumnname&

1inINSERTorUPDATE.

SQL0122SQLCODE-122 

ColumnspecifiedinSELECTlistnotvalid.

SQL0125SQLCODE-125 

SQLSTATE42805 

ORDERBYcolumnnumber&

SQL0128SQLCODE-128 

UseofNULLisnotvalid.

SQL0129SQLCODE-129 

SQLSTATE54004 

ToomanytablesinSQLstatement.

SQL0130SQLCODE-130 

SQLSTATE22019,22025 

Escapecharacter&

1orLIKEpatternnotvalid.

SQL0131SQLCODE-131 

SQLSTATE42818 

OperandsofLIKEnotcompatibleornotvalid.

SQL0132SQLCODE-132 

SQLSTATE42824 

LIKEpredicatenotvalid.

SQL0133SQLCODE-133 

SQLSTATE42906 

OperatoroncorrelatedcolumninSQLfunctionnotvalid.

SQL0134SQLCODE-134 

SQLSTATE42907 

Argumentoffunctiontoolong.

SQL0136SQLCODE-136 

SQLSTATE54005 

ORDERBYorGROUPBYcolumnstoolong.

SQL0137SQLCODE-137 

SQLSTATE54006 

Resulttoolong.

SQL0138SQLCODE-138 

SQLSTATE22011 

Argument&

1ofSUBSTRfunctionnotvalid.

SQL0144SQLCODE-144 

SQLSTATE58003 

Sectionnumbernotvalid.

SQL0145SQLCODE-145 

SQLSTATE55005 

RecursionnotsupportedforanapplicationserverotherthantheAS/400system.

SQL0150SQLCODE-150 

SQLSTATE42807 

Vieworlogicalfile&

2read-only.

SQL0151SQLCODE-151 

SQLSTATE42808 

1intable&

2in&

3read-only.

SQL0152SQLCODE-152 

SQLSTATE42809 

Constrainttypenotvalidforconstraint&

SQL0153SQLCODE-153 

SQLSTATE42908 

ColumnlistrequiredforCREATEVIEW.

SQL0154SQLCODE-154 

SQLSTATE42909 

UNIONandUNIONALLforCREATEVIEWnotvalid.

SQL0