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

DB2 的常见 SQLCODE 所表示负数的含义 SQL0007 SQLCODE 07 SQLSTATE 42601 Explanation Character 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