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:

SQLstatementtoolongorplex.

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:

parisonoperator&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:

OperandsofLIKEnotpatibleornotvalid.

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.

SQL0156SQLCODE-156  SQLSTATE42809 

Explanation:

&1in&2notatable.

SQL0157SQLCODE-157  SQLSTATE42810 

Explanation:

View&1in&2notvalidinFOREIGNKEYclause.

SQL0158SQLCODE-158  SQLSTATE42811 

Explanation:

Numberofcolumnsspecifiednotconsistent.

SQL0159SQLCODE-159  SQLSTATE42809 

Explanation:

&1in&2notcorrecttype.

SQL0160SQLCODE-160  SQLSTATE42813 

Explanation:

WITHCHECKOPTIONnotallowedforview&1in&2.

SQL0161SQLCODE-161  SQLSTATE44000 

Explanation:

INSERT/UPDATEnotallowedduetoWITHCHECKOPTION.

SQL0170SQLCODE-170  SQLSTATE42605 

Explanation:

Numberofargumentsforfunction&1notvalid.

SQL0171SQLCODE-171  SQLSTATE42815 

Explanation:

Argument&1offunction&2notvalid.

SQL0175SQLCODE-175  SQLSTATE58028 

Explanation:

MITfailed.

SQL0180SQLCODE-180  SQLSTATE22007 

Explanation:

Syntaxofdate,time,ortimestampvaluenotvalid.

SQL0181SQLCODE-181  SQLSTATE22007 

Explanation:

Valueindate,time,ortimestampstringnotvalid.

SQL0182SQLCODE-182  SQLSTATE42816 

Explanation:

Adate,time,ortimestampexpressionnotvalid.

SQL0183SQLCODE-183  SQLSTATE22008 

Explanation:

Theresultofadateortimestampexpressionnotvalid.

SQL0184SQLCODE-184  SQLSTATE42610 

Explanation:

Parametermarkernotvalidinexpression.

SQL0187SQLCODE-187  SQLSTATE42816 

Explanation:

Useoflabeleddurationisnotvalid.

SQL0188SQLCODE-188  SQLSTATE22503,28000,2E000 

Explanation:

&1isnotavalidstringrepresentationofanauthorizationnameorarelationaldatabasename.

SQL0189SQLCODE-189  SQLSTATE22522 

Explanation:

CodedCharacterSetIdentifier&1isnotvalid.

SQL0190SQLCODE-190  SQLSTATE42837 

Explanation:

Attributesofcolumn&3in&1in&2notpatible.

SQL0191SQLCODE-191  SQLSTATE22504 

Explanation:

MIXEDdatanotproperlyformed.

SQL0192SQLCODE-192  SQLSTATE42937 

Explanation:

ArgumentofTRANSLATEfunctionnotvalid.

SQL0194SQLCODE-194  SQLSTATE42848 

Explanation:

KEEPLOCKSnotallowed.

SQL0195SQLCODE-195  SQLSTATE42814 

Explanation:

Lastcolumnof&1in&2cannotbedropped.

SQL0196SQLCODE-196  SQLSTATE42817 

Explanation:

Column&3in&1in&2cannotbedroppedwithRESTRICT.

SQL0197SQLCODE-197  SQLSTATE42877 

Explanation:

Column&1cannotbequalified.

SQL0198SQLCODE-198  SQLSTATE42617 

Explanation:

SQLstatementemptyorblank.

SQL0199SQLCODE-199  SQLSTATE42601 

Explanation:

Keyword&1notexpected.Validtokens:

&2.

SQL0203SQLCODE-203  SQLSTATE42702 

Explanation:

Column&1isambiguous.

SQL0204SQLCODE-204  SQLSTATE42704 

Explanation:

&1in&2type*&3notfound.

SQL0205SQLCODE-205  SQLSTATE42703 

Explanation:

Column&1notintable&2.

SQL0206SQLCODE-206  SQLSTATE42703 

Explanation:

Column&1notinspecifiedtables.

SQL0208SQLCODE-208  SQLSTATE42707 

Explanation:

ORDERBYcolumn&1notinresultstable.

SQL0212SQLCODE-212  SQLSTATE42712 

Explanation:

Duplicatetabledesignator&1notvalid.

SQL0214SQLCODE-214  SQLSTATE42822 

Explanation:

ORDERBYexpressionisnotvalid.

SQL0221SQLCODE-221  SQLSTATE42873 

Explanation:

Numberofrows&2notvalid.

SQL0225SQLCODE-225  SQLSTATE42872 

Explanation:

FETCHnotvalid;cursor&1notdeclaredwithSCROLL.

SQL0226SQLCODE-226  SQLSTATE24507 

Explanation:

Currentrowdeletedormovedforcursor&1.

SQL0227SQLCODE-227  SQLSTATE24513 

Explanation:

FETCHnotvalid,cursor&1inunknownposition.

SQL0228SQLCODE-228  SQLSTATE42620 

Explanation:

FORUPDATEOFclausenotvalidwithSCROLLforcursor&1.

SQL0231SQLCODE-231  SQLSTATE22006 

Explanation:

Positionofcursor&1notvalidforFETCHofcurrentrow.

SQL0250SQLCODE-250  SQLSTATE42718 

Explanation:

Localrelationaldatabasenotdefinedinthedirectory.

SQL0251SQLCODE-251  SQLSTATE2E000,42602 

Explanation:

Characterinrelationaldatabasename&1isnotvalid.

SQL0255SQLCODE-255  SQLSTATE42999 

Explanation:

DB2Multisystemqueryerror.

SQL0256SQLCODE-256  SQLSTATE42998 

Explanation:

Constraint&1in&2notallowedondistributedfile.

SQL0270SQLCODE-270  SQLSTATE42997 

Explanation:

Uniqueindexnotallowed.

SQL0301SQLCODE-301  SQLSTATE07006,42895 

Explanation:

Inputhostvariable&2orargument&1notvalid.

SQL0302SQLCODE-302  SQLSTATE22001,22003,22023,22024 

Explanation:

Conversionerroroninputhostvariable&2.

SQL0303SQLCODE-303  SQLSTATE22001,42806 

Explanation:

Hostvariable&1notpatiblewithSELECTitem.

SQL0304SQLCODE-304  SQLSTATE22003,22