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

 

SQL0007 SQLCODE -07   SQLSTATE 42601  


Explanation: Character &1 (HEX &2) not valid in SQL statement. 

SQL0010 SQLCODE -10   SQLSTATE 42603  


Explanation: String constant beginning &1 not delimited. 

SQL0029 SQLCODE -29   SQLSTATE 42601  


Explanation: INTO clause missing from embedded SELECT statement. 

SQL0051 SQLCODE -51   SQLSTATE 3C000  


Explanation: Cursor or procedure &1 previously declared. 

SQL0060 SQLCODE -60   SQLSTATE 42815  


Explanation: Value &3 for argument &1 of &2 function not valid. 

SQL0078 SQLCODE -78   SQLSTATE 42629  


Explanation: Parameter name required for routine &1 in &2. 

SQL0080 SQLCODE -80   SQLSTATE 42978  


Explanation: Indicator variable &1 not SMALLINT type. 

SQL0084 SQLCODE -84   SQLSTATE 42612  


Explanation: SQL statement not allowed. 

SQL0090 SQLCODE -90   SQLSTATE 42618  


Explanation: Host variable not permitted here. 

SQL0097 SQLCODE -97   SQLSTATE 42601  


Explanation: Use of data type not valid. 

SQL0099 SQLCODE -99   SQLSTATE 42992  


Explanation: Operator in join condition not valid. 

SQL0101 SQLCODE -101   SQLSTATE 54001, 54010, 54011  


Explanation: SQL statement too long or complex. 

SQL0102 SQLCODE -102   SQLSTATE 54002  


Explanation: String constant beginning with &1 too long. 

SQL0103 SQLCODE -103   SQLSTATE 42604  


Explanation: Numeric constant &1 not valid. 

SQL0104 SQLCODE -104   SQLSTATE 42601  


Explanation: Token &1 was not valid. Valid tokens: &2. 

SQL0105 SQLCODE -105   SQLSTATE 42604  


Explanation: Mixed or graphic string constant not valid. 

SQL0106 SQLCODE -106   SQLSTATE 42611  


Explanation: Precision specified for FLOAT column not valid. 

SQL0107 SQLCODE -107   SQLSTATE 42622  


Explanation: &1 too long. Maximum &2 characters. 

SQL0109 SQLCODE -109   SQLSTATE 42601  


Explanation: &1 clause not allowed. 

SQL0110 SQLCODE -110   SQLSTATE 42606  


Explanation: Hexadecimal constant beginning with &1 not valid. 

SQL0112 SQLCODE -112   SQLSTATE 42607  


Explanation: Argument of function &1 is another function. 

SQL0113 SQLCODE -113   SQLSTATE 28000, 2E000, 42602  


Explanation: Name &1 not allowed. 

SQL0114 SQLCODE -114   SQLSTATE 42961  


Explanation: Relational database &1 not the same as current server &2. 

SQL0115 SQLCODE -115   SQLSTATE 42601  


Explanation: Comparison operator &1 not valid. 

SQL0117 SQLCODE -117   SQLSTATE 42802  


Explanation: Statement inserts wrong number of values. 

SQL0118 SQLCODE -118   SQLSTATE 42902  


Explanation: Table &1 in &2 also specified in a FROM clause. 

SQL0119 SQLCODE -119   SQLSTATE 42803  


Explanation: Column &1 in HAVING clause not in GROUP BY. 

SQL0120 SQLCODE -120   SQLSTATE 42903  


Explanation: Use of column function &2 not valid. 

SQL0121 SQLCODE -121   SQLSTATE 42701  


Explanation: Duplicate column name &1 in INSERT or UPDATE. 

SQL0122 SQLCODE -122   SQLSTATE 42803  


Explanation: Column specified in SELECT list not valid. 

SQL0125 SQLCODE -125   SQLSTATE 42805  


Explanation: ORDER BY column number &1 not valid. 

SQL0128 SQLCODE -128   SQLSTATE 42601  


Explanation: Use of NULL is not valid. 

SQL0129 SQLCODE -129   SQLSTATE 54004  


Explanation: Too many tables in SQL statement. 

SQL0130 SQLCODE -130   SQLSTATE 22019, 22025  


Explanation: Escape character &1 or LIKE pattern not valid. 

SQL0131 SQLCODE -131   SQLSTATE 42818  


Explanation: Operands of LIKE not compatible or not valid. 

SQL0132 SQLCODE -132   SQLSTATE 42824  


Explanation: LIKE predicate not valid. 

SQL0133 SQLCODE -133   SQLSTATE 42906  


Explanation: Operator on correlated column in SQL function not valid. 

SQL0134 SQLCODE -134   SQLSTATE 42907  


Explanation: Argument of function too long. 

SQL0136 SQLCODE -136   SQLSTATE 54005  


Explanation: ORDER BY or GROUP BY columns too long. 

SQL0137 SQLCODE -137   SQLSTATE 54006  


Explanation: Result too long. 

SQL0138 SQLCODE -138   SQLSTATE 22011  


Explanation: Argument &1 of SUBSTR function not valid. 

SQL0144 SQLCODE -144   SQLSTATE 58003  


Explanation: Section number not valid. 

SQL0145 SQLCODE -145   SQLSTATE 55005  


Explanation: Recursion not supported for an application server other than the AS/400 system. 

SQL0150 SQLCODE -150   SQLSTATE 42807  


Explanation: View or logical file &1 in &2 read-only. 

SQL0151 SQLCODE -151   SQLSTATE 42808  


Explanation: Column &1 in table &2 in &3 read-only. 

SQL0152 SQLCODE -152   SQLSTATE 42809  


Explanation: Constraint type not valid for constraint &1 in &2. 

SQL0153 SQLCODE -153   SQLSTATE 42908  


Explanation: Column list required for CREATE VIEW. 

SQL0154 SQLCODE -154   SQLSTATE 42909  


Explanation: UNION and UNION ALL for CREATE VIEW not valid. 

SQL0156 SQLCODE -156   SQLSTATE 42809  


Explanation: &1 in &2 not a table. 

SQL0157 SQLCODE -157   SQLSTATE 42810  


Explanation: View &1 in &2 not valid in FOREIGN KEY clause. 

SQL0158 SQLCODE -158   SQLSTATE 42811  


Explanation: Number of columns specified not consistent. 

SQL0159 SQLCODE -159   SQLSTATE 42809  


Explanation: &1 in &2 not correct type. 

SQL0160 SQLCODE -160   SQLSTATE 42813  


Explanation: WITH CHECK OPTION not allowed for view &1 in &2. 

SQL0161 SQLCODE -161   SQLSTATE 44000  


Explanation: INSERT/UPDATE not allowed due to WITH CHECK OPTION. 

SQL0170 SQLCODE -170   SQLSTATE 42605  


Explanation: Number of arguments for function &1 not valid. 

SQL0171 SQLCODE -171   SQLSTATE 42815  


Explanation: Argument &1 of function &2 not valid. 

SQL0175 SQLCODE -175   SQLSTATE 58028  


Explanation: COMMIT failed. 

SQL0180 SQLCODE -180   SQLSTATE 22007  


Explanation: Syntax of date, time, or timestamp value not valid. 

SQL0181 SQLCODE -181   SQLSTATE 22007  


Explanation: Value in date, time, or timestamp string not valid. 

SQL0182 SQLCODE -182   SQLSTATE 42816  


Explanation: A date, time, or timestamp expression not valid. 

SQL0183 SQLCODE -183   SQLSTATE 22008  


Explanation: The result of a date or timestamp expression not valid. 

SQL0184 SQLCODE -184   SQLSTATE 42610  


Explanation: Parameter marker not valid in expression. 

SQL0187 SQLCODE -187   SQLSTATE 42816  


Explanation: Use of labeled duration is not valid. 

SQL0188 SQLCODE -188   SQLSTATE 22503, 28000, 2E000  


Explanation: &1 is not a valid string representation of an authorization name or a relational database name. 

SQL0189 SQLCODE -189   SQLSTATE 22522  


Explanation: Coded Character Set Identifier &1 is not valid. 

SQL0190 SQLCODE -190   SQLSTATE 42837  


Explanation: Attributes of column &3 in &1 in &2 not compatible. 

SQL0191 SQLCODE -191   SQLSTATE 22504  


Explanation: MIXED data not properly formed. 

SQL0192 SQLCODE -192   SQLSTATE 42937  


Explanation: Argument of TRANSLATE function not valid. 

SQL0194 SQLCODE -194   SQLSTATE 42848  


Explanation: KEEP LOCKS not allowed. 

SQL0195 SQLCODE -195   SQLSTATE 42814  


Explanation: Last column of &1 in &2 cannot be dropped. 

SQL0196 SQLCODE -196   SQLSTATE 42817  


Explanation: Column &3 in &1 in &2 cannot be dropped with RESTRICT. 

SQL0197 SQLCODE -197   SQLSTATE 42877  


Explanation: Column &1 cannot be qualified. 

SQL0198 SQLCODE -198   SQLSTATE 42617  


Explanation: SQL statement empty or blank. 

SQL0199 SQLCODE -199   SQLSTATE 42601  


Explanation: Keyword &1 not expected. Valid tokens: &2. 

SQL0203 SQLCODE -203   SQLSTATE 42702  


Explanation: Column &1 is ambiguous. 

SQL0204 SQLCODE -204   SQLSTATE 42704  


Explanation: &1 in &2 type *&3 not found. 

SQL0205 SQLCODE -205   SQLSTATE 42703  


Explanation: Column &1 not in table &2. 

SQL0206 SQLCODE -206   SQLSTATE 42703  


Explanation: Column &1 not in specified tables. 

SQL0208 SQLCODE -208   SQLSTATE 42707  


Explanation: ORDER BY column &1 not in results table. 

SQL0212 SQLCODE -212   SQLSTATE 42712  


Explanation: Duplicate table designator &1 not valid. 

SQL0214 SQLCODE -214   SQLSTATE 42822  


Explanation: ORDER BY expression is not valid. 

SQL0221 SQLCODE -221   SQLSTATE 42873  


Explanation: Number of rows &2 not valid. 

SQL0225 SQLCODE -225   SQLSTATE 42872  


Explanation: FETCH not valid; cursor &1 not declared with SCROLL. 

SQL0226 SQLCODE -226   SQLSTATE 24507  


Explanation: Current row deleted or moved for cursor &1. 

SQL0227 SQLCODE -227   SQLSTATE 24513  


Explanation: FETCH not valid, cursor &1 in unknown position. 

SQL0228 SQLCODE -228   SQLSTATE 42620  


Explanation: FOR UPDATE OF clause not valid with SCROLL for cursor &1. 

SQL0231 SQLCODE -231   SQLSTATE 22006  


Explanation: Position of cursor &1 not valid for FETCH of current row. 

SQL0250 SQLCODE -250   SQLSTATE 42718  


Explanation: Local relational database not defined in the directory. 

SQL0251 SQLCODE -251   SQLSTATE 2E000, 42602  


Explanation: Character in relational database name &1 is not valid. 

SQL0255 SQLCODE -255   SQLSTATE 42999  


Explanation: DB2 Multisystem query error. 

SQL0256 SQLCODE -256   SQLSTATE 42998  


Explanation: Constraint &1 in &2 not allowed on distributed file. 

SQL0270 SQLCODE -270   SQLSTATE 42997  


Explanation: Unique index not allowed. 

SQL0301 SQLCODE -301   SQLSTATE 07006,42895  


Explanation: Input host variable &2 or argument &1 not valid. 

SQL0302 SQLCODE -302   SQLSTATE 22001, 22003, 22023, 22024  


Explanation: Conversion error on input host variable &2. 

SQL0303 SQLCODE -303   SQLSTATE 22001, 42806  


Explanation: Host variable &1 not compatible with SELECT item. 

SQL0304 SQLCODE -304   SQLSTATE 22003, 22023, 22504  


Explanation: Conversion error in assignment to host variable &2. 

SQL0305 SQLCODE -305   SQLSTATE 22002  


Explanation: Indicator variable required. 

SQL0306 SQLCODE -306   SQLSTATE 42863  


Explanation: Undefined host variable in REXX. 

SQL0311 SQLCODE -311   SQLSTATE 22501  


Explanation: Length in a varying-length host variable not valid. 

SQL0312 SQLCODE -312   SQLSTATE 42618  


Explanation: Host variable &1 not defined or not usable. 

SQL0313 SQLCODE -313   SQLSTATE 07001, 07004  


Explanation: Number of host variables not valid. 

SQL0328 SQLCODE -328   SQLSTATE 42996  


Explanation: Column &1 not allowed in partitioning key. 

SQL0329 SQLCODE -329   SQLSTATE 0E000  


Explanation: The SET PATH name list is not valid. 

SQL0330 SQLCODE -330   SQLSTATE 22021  


Explanation: Character conversion cannot be performed. 

SQL0331 SQLCODE -331   SQLSTATE 22021  


Explanation: Character conversion cannot be performed. 

SQL0332 SQLCODE -332   SQLSTATE 57017  


Explanation: Character conversion between CCSID &1 and CCSID &2 not valid. 

SQL0334 SQLCODE -334   SQLSTATE 22524  


Explanation: Character conversion has resulted in truncation. 

SQL0338 SQLCODE -338   SQLSTATE 42972  


Explanation: JOIN expression not valid. 

SQL0340 SQLCODE -340   SQLSTATE 42726  


Explanation: Duplicate name &1 for common table expression. 

SQL0341 SQLCODE -341   SQLSTATE 42835  


Explanation: Cyclic references between common table expressions. 

SQL0346 SQLCODE -346   SQLSTATE 42836  


Explanation: Recursion not allowed for common table expressions. 

SQL0350 SQLCODE -350   SQLSTATE 42962  


Explanation: Column &1 is not valid as key field for index or constraint. 

SQL0351 SQLCODE -351   SQLSTATE 56084  


Explanation: The AR is not at the same level and DB2/400 cannot transform the data type to a compatible type. 

SQL0352 SQLCODE -352   SQLSTATE 56084  


Explanation: The AS is not at the same level and DB2/400 cannot transform the data type to a compatible type. 

SQL0357 SQLCODE -357   SQLSTATE 57050  


Explanation: File server &1 used in DataLink not currently available. 

SQL0358 SQLCODE -358   SQLSTATE 428D1  


Explanation: Error &1 occurred using DataLink data type. 

SQL0392 SQLCODE -392   SQLSTATE 42855  


Explanation: Assignment of LOB to specified host variable not allowed. 

SQL0398 SQLCODE -398   SQLSTATE 428D2  


Explanation: AS LOCATOR cannot be specified for a non-LOB parameter. 

SQL0401 SQLCODE -401   SQLSTATE 42818  


Explanation: Comparison operator &1 operands not compatible. 

SQL0402 SQLCODE -402   SQLSTATE 42819  


Explanation: &1 use not valid. 

SQL0404 SQLCODE -404   SQLSTATE 22001  


Explanation: Value for column &1 too long. 

SQL0405 SQLCODE -405   SQLSTATE 42820  


Explanation: Numeric constant &1 out of range. 

SQL0406 SQLCODE -406   SQLSTATE 22003, 22023, 22504  


Explanation: Conversion error on assignment to column &2. 

SQL0407 SQLCODE -407   SQLSTATE 23502  


Explanation: Null values are not allowed in column &1. 

SQL0408 SQLCODE -408   SQLSTATE 42821  


Explanation: INSERT or UPDATE value for column &1 not compatible. 

SQL0410 SQLCODE -410   SQLSTATE 42820  


Explanation: Floating point literal &1 not valid. 

SQL0412 SQLCODE -412   SQLSTATE 42823  


Explanation: Subquery with more than one result column not valid. 

SQL0414 SQLCODE -414   SQLSTATE 42824  


Explanation: Column &1 not valid in LIKE predicate. 

SQL0415 SQLCODE -415   SQLSTATE 42825  


Explanation: UNION operands not compatible. 

SQL0417 SQLCODE -417   SQLSTATE 42609  


Explanation: Combination of parameter markers not valid. 

SQL0418 SQLCODE -418   SQLSTATE 42610  


Explanation: Use of parameter marker is not valid. 

SQL0419 SQLCODE -419   SQLSTATE 42911  


Explanation: Negative scale not valid. 

SQL0420 SQLCODE -420   SQLSTATE 22018  


Explanation: Character in CAST argument not valid. 

SQL0421 SQLCODE -421   SQLSTATE 42826  


Explanation: Number of UNION operands not equal. 

SQL0423 SQLCODE -423   SQLSTATE 0F001  


Explanation: LOB locator &1 not valid. 

SQL0428 SQLCODE -428   SQLSTATE 25501  


Explanation: SQL statement cannot be run. 

SQL0429 SQLCODE -429   SQLSTATE 54028  


Explanation: The maximum number of concurrent LOB locators has been reached. 

SQL0432 SQLCODE -432   SQLSTATE 42841  


Explanation: A parameter marker cannot have the user-defined type name &1. 

SQL0433 SQLCODE -433   SQLSTATE 22001  


Explanation: Significant digits truncated during CAST from numeric to character. 

SQL0440 SQLCODE -440   SQLSTATE 42884  


Explanation: Number of arguments on CALL must match procedure. 

SQL0441 SQLCODE -441   SQLSTATE 42601  


Explanation: Clause or keyword &1 not valid where specified. 

SQL0442 SQLCODE -442   SQLSTATE 54023  


Explanation: Maximum # of parameters on CALL exceeded. 

SQL0443 SQLCODE -443   SQLSTATE 2Fxxx, 38501  


Explanation: Trigger program or external procedure detected on error. 

SQL0444 SQLCODE -444   SQLSTATE 42724  


Explanation: External program &4 in &1 not found. 

SQL0446 SQLCODE -446   SQLSTATE 22003  


Explanation: Conversion error in assignment of argument &2. 

SQL0448 SQLCODE -448   SQLSTATE 54023  


Explanation: Maximum parameters on DECLARE PROCEDURE exceeded. 

SQL0449 SQLCODE -449   SQLSTATE 42878  


Explanation: External program name for procedure &1 in &2 not valid. 

SQL0451 SQLCODE -451   SQLSTATE 42815  


Explanation: Attributes of parameter &1 not valid for procedure. 

SQL0452 SQLCODE -452   SQLSTATE 428A1  


Explanation: Unable to access a file that is referred to by a file reference variable. 

SQL0453 SQLCODE -453   SQLSTATE 42880  


Explanation: Return type for function &1 in &2 not compatible with CAST TO type. 

SQL0454 SQLCODE -454   SQLSTATE 42723  


Explanation: Function &1 in &2 with the same signature already exists. 

SQL0455 SQLCODE -455   SQLSTATE 42882  


Explanation: Specific name not same as procedure name. 

SQL0456 SQLCODE -456   SQLSTATE 42710  


Explanation: Specific name &3 in &2 already exists. 

SQL0457 SQLCODE -457   SQLSTATE 42939  


Explanation: Name &1 in &2 not allowed for function. 

SQL0458 SQLCODE -458   SQLSTATE 42883  


Explanation: Function &1 in &2 not found with matching signature. 

SQL0461 SQLCODE -461   SQLSTATE 42846  


Explanation: Cast from &1 to &2 not supported. 

SQL0463 SQLCODE -463   SQLSTATE 39001  


Explanation: SQLSTATE &4 returned from routine &1 in &2 not valid.. 

SQL0469 SQLCODE -469   SQLSTATE 42886  


Explanation: IN, OUT, INOUT not valid for parameter &4 in procedure &1 in &2. 

SQL0470 SQLCODE -470   SQLSTATE 39002  


Explanation: NULL values not allowed for parameter &4 in procedure. 

SQL0473 SQLCODE -473   SQLSTATE 42918  


Explanation: User-defined type &1 cannot be created. 

SQL0475 SQLCODE -475   SQLSTATE 42866  


Explanation: RETURNS data type for function &3 in &4 not valid. 

SQL0476 SQLCODE -476   SQLSTATE 42725  


Explanation: Function &1 in &2 not unique. 

SQL0478 SQLCODE -478   SQLSTATE 42893  


Explanation: Object &1 in &2 of type &3 cannot be dropped. 

SQL0483 SQLCODE -483   SQLSTATE 42885  


Explanation: Parameters for function &1 in &2 not same as sourced function. 

SQL0484 SQLCODE -484   SQLSTATE 42733  


Explanation: Routine &1 in &2 already exists. 

SQL0487 SQLCODE -487   SQLSTATE 38001  


Explanation: SQL statements not allowed. 

SQL0490 SQLCODE -490   SQLSTATE 428B7  


Explanation: Numeric value &1 not valid. 

SQL0491 SQLCODE -491   SQLSTATE 42601  


Explanation: RETURNS clause required on CREATE FUNCTION statement. 

SQL0492 SQLCODE -492   SQLSTATE 42879  


Explanation: Data type for function &1 in &2 not valid for source type. 

SQL0501 SQLCODE -501   SQLSTATE 24501  


Explanation: Cursor &1 not open. 

SQL0502 SQLCODE -502   SQLSTATE 24502  


Explanation: Cursor &1 already open. 

SQL0503 SQLCODE -503   SQLSTATE 42912  


Explanation: Column &3 cannot be updated. 

SQL0504 SQLCODE -504   SQLSTATE 34000  


Explanation: Cursor &1 not declared. 

SQL0507 SQLCODE -507   SQLSTATE 24501  


Explanation: Cursor &1 not open. 

SQL0508 SQLCODE -508   SQLSTATE 24504  


Explanation: Cursor &1 not positioned on locked row. 

SQL0509 SQLCODE -509   SQLSTATE 42827  


Explanation: Table &2 in &3 not same as table in cursor &1. 

SQL0510 SQLCODE -510   SQLSTATE 42828  


Explanation: Cursor &1 for file &2 is read-only. 

SQL0511 SQLCODE -511   SQLSTATE 42829  


Explanation: FOR UPDATE OF clause not valid. 

SQL0513 SQLCODE -513   SQLSTATE 42924  


Explanation: Alias &1 in &2 cannot reference another alias. 

SQL0514 SQLCODE -514   SQLSTATE 26501  


Explanation: Prepared statement &2 not found. 

SQL0516 SQLCODE -516   SQLSTATE 26501  


Explanation: Prepared statement &2 not found. 

SQL0517 SQLCODE -517   SQLSTATE 07005  


Explanation: Prepared statement &2 not SELECT statement. 

SQL0518 SQLCODE -518   SQLSTATE 07003  


Explanation: Prepared statement &1 not found. 

SQL0519 SQLCODE -519   SQLSTATE 24506  


Explanation: Prepared statement &2 in use. 

SQL0520 SQLCODE -520   SQLSTATE 42828  


Explanation: Cannot UPDATE or DELETE on cursor &1. 

SQL0525 SQLCODE -525   SQLSTATE 51015  


Explanation: Statement not valid on application server. 

SQL0527 SQLCODE -527   SQLSTATE 42874  


Explanation: ALWCPYDTA(*NO) specified but temporary result required for &1. 

SQL0530 SQLCODE -530   SQLSTATE 23503  


Explanation: Insert or UPDATE value not allowed by referential constraint. 

SQL0531 SQLCODE -531   SQLSTATE 23001, 23504  


Explanation: Update prevented by referential constraint. 

SQL0532 SQLCODE -532   SQLSTATE 23001, 23504  


Explanation: Delete prevented by referential constraint. 

SQL0536 SQLCODE -536   SQLSTATE 42914  


Explanation: Delete not allowed because table referenced in subquery can be affected. 

SQL0537 SQLCODE -537   SQLSTATE 42709  


Explanation: Duplicate column name in definition of key. 

SQL0538 SQLCODE -538   SQLSTATE 42830  


Explanation: Foreign key attributes do not match parent key. 

SQL0539 SQLCODE -539   SQLSTATE 42888  


Explanation: Table does not have primary key. 

SQL0541 SQLCODE -541   SQLSTATE 42891  


Explanation: Duplicate UNIQUE constraint already exists. 

SQL0543 SQLCODE -543   SQLSTATE 23511  


Explanation: Constraint &1 conflicts with SET NULL or SET DEFAULT rule. 

SQL0544 SQLCODE -544   SQLSTATE 23512  


Explanation: CHECK constraint &1 cannot be added. 

SQL0545 SQLCODE -545   SQLSTATE 23513  


Explanation: INSERT or UPDATE not allowed by CHECK constraint. 

SQL0546 SQLCODE -546   SQLSTATE 42621  


Explanation: CHECK condition of constraint &1 not valid. 

SQL0551 SQLCODE -551   SQLSTATE 42501  


Explanation: Not authorized to object &1 in &2 type *&3. 

SQL0552 SQLCODE -552   SQLSTATE 42502  


Explanation: Not authorized to &1. 

SQL0557 SQLCODE -557   SQLSTATE 42852  


Explanation: Privilege not valid for table or view &1 in &2. 

SQL0573 SQLCODE -573   SQLSTATE 42890  


Explanation: Table does not have matching parent key. 

SQL0574 SQLCODE -574   SQLSTATE 42894  


Explanation: Default value not valid. 

SQL0577 SQLCODE -577   SQLSTATE 38002, 2F002  


Explanation: Modifying SQL data not permitted. 

SQL0578 SQLCODE -578   SQLSTATE 2F005  


Explanation: RETURN statement not executed for SQL function &1 in &2. 

SQL0579 SQLCODE -579   SQLSTATE 38004, 2F004  


Explanation: Reading SQL data not permitted. 

SQL0580 SQLCODE -580   SQLSTATE 42625  


Explanation: At least one result in CASE expression must be not NULL. 

SQL0581 SQLCODE -581   SQLSTATE 42804  


Explanation: The results in a CASE expression are not compatible. 

SQL0583 SQLCODE -583   SQLSTATE 42845  


Explanation: Use of function &1 in &2 not valid. 

SQL0585 SQLCODE -585   SQLSTATE 42732  


Explanation: Library &1 is used incorrectly on the SET PATH statement 

SQL0590 SQLCODE -590   SQLSTATE 42734  


Explanation: Name &1 specified in &2 not unique. 

SQL0601 SQLCODE -601   SQLSTATE 42710  


Explanation: Object &1 in &2 type *&3 already exists. 

SQL0602 SQLCODE -602   SQLSTATE 54008  


Explanation: More than 120 columns specified for CREATE INDEX. 

SQL0603 SQLCODE -603   SQLSTATE 23515  


Explanation: Unique index cannot be created because of duplicate keys. 

SQL0604 SQLCODE -604   SQLSTATE 42611  


Explanation: Attributes of column not valid. 

SQL0607 SQLCODE -607   SQLSTATE 42832  


Explanation: Operation not allowed on system table &1 in &2. 

SQL0612 SQLCODE -612   SQLSTATE 42711  


Explanation: &1 is a duplicate column name. 

SQL0613 SQLCODE -613   SQLSTATE 54008  


Explanation: Primary or unique key constraint too long. 

SQL0614 SQLCODE -614   SQLSTATE 54008  


Explanation: Length of columns for CREATE INDEX too long. 

SQL0615 SQLCODE -615   SQLSTATE 55006  


Explanation: Object &1 in &2 type *&3 not dropped. It is in use. 

SQL0616 SQLCODE -616   SQLSTATE 42893  


Explanation: &1 in &2 type &3 cannot be dropped with RESTRICT. 

SQL0624 SQLCODE -624   SQLSTATE 42889  


Explanation: Table already has primary key. 

SQL0628 SQLCODE -628   SQLSTATE 42613  


Explanation: Clauses are mutually exclusive. 

SQL0629 SQLCODE -629   SQLSTATE 42834  


Explanation: SET NULL not allowed for referential constraint. 

SQL0631 SQLCODE -631   SQLSTATE 54008  


Explanation: Foreign key for referential constraint too long. 

SQL0637 SQLCODE -637   SQLSTATE 42614  


Explanation: Duplicate &1 keyword. 

SQL0642 SQLCODE -642   SQLSTATE 54021  


Explanation: Maximum number of constraints exceeded. 

SQL0658 SQLCODE -658   SQLSTATE 42917  


Explanation: Function cannot be dropped. 

SQL0666 SQLCODE -666   SQLSTATE 57005  


Explanation: Estimated query processing time exceeds limit. 

SQL0667 SQLCODE -667   SQLSTATE 23520  


Explanation: Foreign key does not match a value in the parent key. 

SQL0675 SQLCODE -675   SQLSTATE 42892  


Explanation: Specified delete rule not allowed with existing trigger. 

SQL0679 SQLCODE -679   SQLSTATE 57006  


Explanation: Object &1 in &2 type *&3 not created due to pending operation. 

SQL0683 SQLCODE -683   SQLSTATE 42842  


Explanation: FOR DATA or CCSID clause not valid for specified type. 

SQL0707 SQLCODE -707   SQLSTATE 42939  


Explanation: Name &1 in &2 not allowed for distinct type. 

SQL0713 SQLCODE -713   SQLSTATE 42815  


Explanation: Host variable for &2 is NULL. 

SQL0724 SQLCODE -724   SQLSTATE 54038  


Explanation: Too many cascaded trigger programs. 

SQL0751 SQLCODE -751   SQLSTATE 42987  


Explanation: SQL statement &1 not allowed in stored procedure or trigger. 

SQL0752 SQLCODE -752   SQLSTATE 0A001  


Explanation: Connection cannot be changed. Reason code is &1. 

SQL0773 SQLCODE -773   SQLSTATE 20000  


Explanation: Case not found for CASE statement. 

SQL0774 SQLCODE -774   SQLSTATE 2D522  


Explanation: Statement cannot be executed within a compound SQL statement. 

SQL0775 SQLCODE -775   SQLSTATE 42910  


Explanation: Statement not allowed in a compound SQL statement. 

SQL0776 SQLCODE -776   SQLSTATE 428D4  


Explanation: Cursor &1 specified in FOR statement not allowed. 

SQL0777 SQLCODE -777   SQLSTATE 42919  


Explanation: Nested compound statements not allowed. 

SQL0778 SQLCODE -778   SQLSTATE 428D5  


Explanation: End label &1 not same as begin label. 

SQL0779 SQLCODE -779   SQLSTATE 42736  


Explanation: Label &1 specified on LEAVE statement not valid. 

SQL0780 SQLCODE -780   SQLSTATE 428D6  


Explanation: UNDO specified for a handler and ATOMIC not specified. 

SQL0781 SQLCODE -781   SQLSTATE 42737  


Explanation: Condition &1 specified in handler not defined. 

SQL0782 SQLCODE -782   SQLSTATE 428D7  


Explanation: Condition value &1 specified in handler not valid. 

SQL0783 SQLCODE -783   SQLSTATE 42738  


Explanation: Select list for cursor &1 in FOR statement not valid. 

SQL0784 SQLCODE -784   SQLSTATE 42860  


Explanation: Check constraint &1 cannot be dropped. 

SQL0785 SQLCODE -785   SQLSTATE 428D8  


Explanation: Use of SQLCODE or SQLSTATE not valid. 

SQL0802 SQLCODE -802   SQLSTATE 22003, 22012, 22023, 22504  


Explanation: Data conversion or data mapping error. 

SQL0803 SQLCODE -803   SQLSTATE 23505  


Explanation: Duplicate key value specified. 

SQL0804 SQLCODE -804   SQLSTATE 07002  


Explanation: SQLDA not valid. 

SQL0805 SQLCODE -805   SQLSTATE 51002  


Explanation: SQL package &1 in &2 not found. 

SQL0811 SQLCODE -811   SQLSTATE 21000  


Explanation: Result of SELECT INTO or subquery more than one row. 

SQL0818 SQLCODE -818   SQLSTATE 51003  


Explanation: Consistency tokens do not match. 

SQL0822 SQLCODE -822   SQLSTATE 51004  


Explanation: Address in SQLDA not valid. 

SQL0827 SQLCODE -827   SQLSTATE 42862  


Explanation: &1 in &2 type *SQLPKG cannot be accessed. 

SQL0840 SQLCODE -840   SQLSTATE 54004  


Explanation: Number of selected items exceeds 8000. 

SQL0842 SQLCODE -842   SQLSTATE 08002  


Explanation: Connection already exists. 

SQL0843 SQLCODE -843   SQLSTATE 08003  


Explanation: Connection does not exist. 

SQL0858 SQLCODE -858   SQLSTATE 08501  


Explanation: Cannot disconnect relational database due to LU 6.2 protected conversation. 

SQL0862 SQLCODE -862   SQLSTATE 55029  


Explanation: Local program attempted to connect to a remote relational database. 

SQL0871 SQLCODE -871   SQLSTATE 54019  


Explanation: Too many CCSID values specified. 

SQL0900 SQLCODE -900   SQLSTATE 08003  


Explanation: Application process not in a connected state. 

SQL0901 SQLCODE -901   SQLSTATE 58004  


Explanation: SQL system error. 

SQL0904 SQLCODE -904   SQLSTATE 57011  


Explanation: Resource limit exceeded. 

SQL0906 SQLCODE -906   SQLSTATE 24514  


Explanation: Operation not performed because of previous error. 

SQL0907 SQLCODE -907   SQLSTATE 27000  


Explanation: Attempt to change same row twice. 

SQL0910 SQLCODE -910   SQLSTATE 57007  


Explanation: Object &1 in &2 type *&3 has a pending change. 

SQL0913 SQLCODE -913   SQLSTATE 57033  


Explanation: Row or object &1 in &2 type *&3 in use. 

SQL0917 SQLCODE -917   SQLSTATE 42969  


Explanation: Package not created. 

SQL0918 SQLCODE -918   SQLSTATE 51021  


Explanation: Rollback required. 

SQL0950 SQLCODE -950   SQLSTATE 42705  


Explanation: Relational database &1 not in relational database directory. 

SQL0951 SQLCODE -951   SQLSTATE 55007  


Explanation: Object &1 in &2 not altered. It is in use. 

SQL0952 SQLCODE -952   SQLSTATE 57014  


Explanation: Processing of the SQL statement ended by ENDRDBRQS command. 

SQL0969 SQLCODE -969   SQLSTATE 58033  


Explanation: Unexpected client driver error. 

SQL0971 SQLCODE -971   SQLSTATE 57011  


Explanation: Referential constraint &4 in check pending state. 

SQL5001 SQLCODE -5001   SQLSTATE 42703  


Explanation: Column qualifier &2 undefined. 

SQL5002 SQLCODE -5002   SQLSTATE 42812  


Explanation: Collection must be specified for table &1. 

SQL5003 SQLCODE -5003   SQLSTATE 42922  


Explanation: Cannot perform operation under commitment control. 

SQL5005 SQLCODE -5005   SQLSTATE 42815  


Explanation: Operator &4 not consistent with operands. 

SQL5012 SQLCODE -5012   SQLSTATE 42618  


Explanation: Host variable not a numeric with zero scale. 

SQL5016 SQLCODE -5016   SQLSTATE 42833  


Explanation: Object name &1 not valid for naming option. 

SQL5021 SQLCODE -5021   SQLSTATE 42930  


Explanation: FOR UPDATE OF column &1 also in ORDER BY. 

SQL5023 SQLCODE -5023   SQLSTATE 26510  


Explanation: Duplicate statement name in DECLARE CURSOR. 

SQL5024 SQLCODE -5024   SQLSTATE 42618  


Explanation: Host variable &1 not character. 

SQL5047 SQLCODE -5047   SQLSTATE 42616  


Explanation: Error processing SRTSEQ or LANGID parameter. 

SQL5051 SQLCODE -5051   SQLSTATE 42875  


Explanation: Incorrect qualifier. 

SQL7001 SQLCODE -7001   SQLSTATE 42858  


Explanation: File &1 in &2 not database file. 

SQL7002 SQLCODE -7002   SQLSTATE 42847  


Explanation: Override parameter not valid. 

SQL7003 SQLCODE -7003   SQLSTATE 42857  


Explanation: File &1 in &2 has more than one format. 

SQL7006 SQLCODE -7006   SQLSTATE 55018  


Explanation: Cannot drop collection &1. 

SQL7007 SQLCODE -7007   SQLSTATE 51009  


Explanation: COMMIT or ROLLBACK not valid. 

SQL7008 SQLCODE -7008   SQLSTATE 55019  


Explanation: &1 in &2 not valid for operation. 

SQL7010 SQLCODE -7010   SQLSTATE 42850  


Explanation: Logical file &1 in &2 not valid for CREATE VIEW. 

SQL7011 SQLCODE -7011   SQLSTATE 42851  


Explanation: &1 in &2 not table, view, or physical file. 

SQL7017 SQLCODE -7017   SQLSTATE 42971  


Explanation: Commitment control is already active to a DDM target. 

SQL7018 SQLCODE -7018   SQLSTATE 42970  


Explanation: COMMIT HOLD or ROLLBACK HOLD not allowed. 

SQL7021 SQLCODE -7021   SQLSTATE 57043  


Explanation: Local program attempting to run on application server. 

SQL7022 SQLCODE -7022   SQLSTATE 42977  


Explanation: User &1 not the same as current user &2 for connect to local relational database. 

SQL7024 SQLCODE -7024   SQLSTATE 42876  


Explanation: Index cannot be created because of CCSID incompatibility. 

SQL7026 SQLCODE -7026   SQLSTATE 42896  


Explanation: Auxiliary storage pool not found. 

SQL7027 SQLCODE -7027   SQLSTATE 42984  


Explanation: Unable to grant to a view. 

SQL7028 SQLCODE -7028   SQLSTATE 42944  


Explanation: Unable to CHGOBJOWN for primary group. 

SQL7029 SQLCODE -7029   SQLSTATE 428B8  


Explanation: New name &3 is not valid. 

SQL7031 SQLCODE -7031   SQLSTATE 54044  


Explanation: Sort sequence table &1 too long. 

SQL7032 SQLCODE -7032   SQLSTATE 42904 Apple-converted

分享到：

利用公式给硬盘精确分区 | Error opening installation log file.

• 2011-03-09 09:58
• 浏览 6861
• 评论(0)
• 分类:数据库
• 查看更多