DB2错误信息大全.doc

sqlcode sqlstate 000 00000 SQL01xxx SQL+012 01545 +098 01568 SQL+100 02000 SQL+110 01561 DATA CAPTURE+111 01590 2SUBPAGES+117 01525 +162 01514 +203 01552 +204 01532 DB2+206 01533 SQL+218 01537 SQLSQLEXPLAIN+219 01532 PLAN TABLE+220 01546 PLAN TABLE+236 01005 SQLDASQLN+237 01594 SQLVAR+238 01005 LOBSQLVAR+239 01005 SQLVAR+304 01515 +331 01520 NULL+339 01569 DB2 2.2+394 01629 +395 01628 +402 01521 +403 01522 CREAT ALIAS+434 01608 DB2IBM+445 01004 CAST+462 01Hxx +464 01609 +466 01610 +494 01614 ASSOCIATE LOCATORS+495 01616 SQLELST+535 01591 +541 01543 +551 01548 IDDB2+552 01542 ID+558 01516 PUBLICWITH GRANT OPTION+561 01523 ALTER REFERENCES INDEX TRIGGERPUBLIC AT ALL LOCATION+562 01560 GRANTEE+585 01625 +599 01596 BLOBCLOBDBCLOB+610 01566 DEFER YESPENDINGALTER INDEXPENDING+625 01518 +626 01529 UNIQUE+645 01528 NULLWHERE NOT NULL+650 01538 +653 01551 +655 01597 CREATEALTER STOGROUPIDDB26+658 01600 SUBPAGESSUBPAGES1+664 01540 +738 01530 +799 0157 SET SET+802 01519 +806 01553 ISOLATIONRRLOCKSIZE PAGE +807 01554 +863 01539 SBCS+2000 56094 SUBPAGES11+2002 01624 GNPCACHE+2007 01602 DB2(hiats+30100 01558 SQLCODESQLSTATE- 007 42601 SQL- 010 42603 - 029 42601 INTO- 060 42815 - 084 42612 SQLSQLOS/390DB2- 097 42601 CASTLONG VARCHARLONGVARGRAPHIC- 101 54001 SQLDB2- 102 54002 - 103 42604 - 104 42601 SQL- 105 42604 - 107 42622 - 108 42601 RENAME- 109 42601 CREATE VIEWORDER BY - 110 42606 - 111 42901 - 112 42607 - 113 42602 - 114 42961 - 115 42601 - 117 42802 - 118 42902 (UPDATEDELETEFROM- 119 42803 HAVINGGROUP BY- 120 42903 WHERESETVALUESSET ASSIGNMENT- 121 42701 INSERTUPDATE- 122 42803 GROUP BY- 123 42601 - 125 42805 ORDER BY1- 126 42829 UPDATEORDER BY- 127 42905 DISTINCT- 128 42601 SQLNULL- 129 54004 SQL15- 130 22019 ESCAPE22025 ESCAPE- 131 42818 LIKE- 132 42824 LIKEESCAPELOCATEPOSSTR- 133 42906 - 134 42907 255- 136 54005 4000- 137 54006 3276716382- 138 22011 SUBSTR- 142 42612 SQLRDBMSVALUES- 144 58003 - 147 42809 - 148 42809 RENAMEALTERRENAMERI.STALTERRIDATACAPTURE CHANGES- 150 42807 INSERTUPDATEDELETE- 151 42808 DB2 CATALOGROWID- 152 42809 DROP CHECKDROP FOREIGN- 153 42908 - 154 42909 UNIONUNION ALL- 156 42809 ALTER TABLECREATE TRIGGERDROP TABLELOCK TABLE- 157 42810 FOREIGN KEY- 158 42811 - 159 42089 DROPCOMMENT ON- 160 42813 WITH CHECK OPTION- 161 44000 WITH CHECK OPTION- 164 42502 - 170 42605 - 171 42815 - 173 42801 UR- 180 22007 DATETIMETIMESTAMP- 181 22001 DATETIMETIMESTAMP- 182 42816 /- 183 22008 /- 184 42610 /- 185 57008 /- 186 22505 /- 187 22506 MVS/- 188 22503 - 189 22522 ID- 190 42837 ALTERALTERVARCHAR- 191 22504 - 197 42877 ORDER BY- 198 42617 PREPAREEXECUTE IMMEDIATE- 199 42601 SQL- 203 42702 - 204 42704 - 205 42703 - 206 42703 FROM- 208 42707 ORDER BY- 212 42712 - 214 42822 DISTINCTORDER BY - 219 42704 PLAN_TABLEEXPLAIN- 220 55002 PLAN_TABLE- 221 55002 PLAN_TABLE- 229 42708 - 240 428B4 LOCK TABLEPART- 250 42718 - 251 42602 - 300 22024 NULL- 301 42895 - 302 22001 22003 - 303 42806 - 304 22003 - 305 22002 NULL- 309 22512 NULL- 310 22501 - 311 22501 - 312 42618 - 313 07001 - 314 42714 - 327 22525 - 330 22021 - 331 22021 - 332 57017 ID- 333 56010 - 338 42972 ON- 339 56082 DB2 2.2ASCIIEBCDIC- 350 42962 - 351 56084 SELECT- 352 56084 - 355 42993 LOB- 372 428C1 ROWID- 390 42887 - 392 42855 FETCHSQLDA- 396 38505 SQL- 397 428D3 GENERATEDROWID- 398 428D2 LOCATORLOB- 399 22511 INSERTROWID- 400 54027 DB2100- 401 42818 - 402 42819 - 404 22001 SQL- 405 42820 - 406 22003 - 407 23502 NULLNOT NULL- 408 42821 - 409 42607 COUNT- 410 42820 30- 411 56040 CURRENT SQLID- 412 42823 - 413 22003 - 414 42824 LIKE- 415 42825 UNION- 416 42907 UNIONSQL- 417 42609 - 418 42610 - 419 42911 - 420 22018 - 421 42826 UNION- 423 0F001 LOB- 426 2D528 COMMIT- 427 2D529 ROLLBACK- 430 38503 - 433 22001 - 435 428B3 SQLSTATE- 438 xxxxx RAISE_ERROR- 440 42884 - 441 42601 DISTINCTALL- 443 42601 SQLSTATE- 444 42724 - 449 42878 CREATEALTEREXTERNAL NAME )- 450 39501 - 451 42815 CREATE FUNCTION- 453 42880 RETURNS- 454 42723 - 455 42882 - 456 42710 - 457 42939 - 458 42883 - 463 39001 SQLSTATE- 469 42886 OUTINOUTCALL- 470 39002 NULLNULL- 471 55023 - 472 24517 - 473 42918 - 475 42866 RETURNS- 476 42725 - 478 42893 DROPREVOKE- 480 51030 CALLDESCRIBE PROCEDUREASSOCIATE LOCATORS- 482 51030 - 483 42885 CREATE FUNCTION- 487 38001 NO SQLSQL- 491 42601 CREATE FUNCTIONRETURNSSOURCEEXTERNAL- 492 42879 - 495 57051 - 496 51033 - 497 54041 32767 OBIDCREATE DATABASE32511DBID- 499 24516 - 500 24501 WITH HOLD- 501 24501 - 502 24502 - 503 42912 FOR UPDATE OF- 504 34000 - 507 24501 WHERE CURRENT OF- 508 24504 - 509 42827 WHERE CURRENT OF- 510 42828 - 511 42829 FOR UPDATE OF- 512 56023 - 513 42924 - 514 26501 - 516 26501 SQL- 517 07005 SQL- 518 07003 SQL- 519 24506 SQL- 525 51015 SQL- 526 42995 - 530 23503 - 531 23504 55- 532 23504 - 533 21501 - 534 21502 - 535 21502 WHERE CURRENT OF5- 536 42914 - 537 42709 - 538 42830 - 539 42888 - 540 57001 UNIQUEGENERATED BYDEFAULTROWID- 542 42831 - 543 23511 SET NULLNULLDELETE- 544 23512 ALTER- 545 23513 INSERTUPDATE- 546 42621 CREATEALTER TABLE- 548 42621 - 549 42509 DYNAMICRULESBINDSQL- 551 42501 - 552 42502 - 553 42503 CURRENT SQLIDID- 554 42502 - 555 42502 - 556 42504 - 557 42852 - 558 56025 - 559 57002 DB2- 567 42501 ID- 571 25000 - 573 42890 - 574 42864 - 577 38002 MODIFIES SQL DATA- 579 38004 READ SQL DATAMODIFIES SQL DATA- 580 42625 CASE- 581 42804 CASE- 582 42625 SEARCHEDWHENCLAUSEINEXISTS- 583 42845 - 585 42732 - 586 42907 CURRENT PATH254- 587 428C6 - 590 42734 - 592 42510 WLM- 601 42710 - 602 54008 CREATE INDEX- 603 23515 - 604 42611 CREATEALTER TABLE- 607 42832 INSERTUPDATEDELETEDB2 CATLOG- 611 53088 LOCKSIZETABLETABLESPACELOCKMAX0- 612 42711 - 613 54008 UNIQUE- 614 54008 255- 615 55006 - 616 42893 - 617 56089 DB2611LOCKSIZE ROWLARGE- 618 42832 DB2 CATALOG- 619 55011 DSNDB07- 620 53