EXPLAIN 558 SET EVENT MONITOR STATE FETCH SET INTEGRITY FLUSH EVENT MONITOR 565 SET PASSTHRU FLUSH PACKAGE CACHE 66 SET PATH FREE LOCATOR SET SCHEMA GRANT (Database Authorities) SET SERVER OPTION GRANT (Index Privileges) SET Variable GRANT(Package Privileges) UPDATE GRANT(Routine Privileges) GRANT(Schema Privileges) GRANT(Sequence Privileges 9368 VALUES VALUES INTO WHENEVER GRANT (Server Privileges). GRANT(Table, View, or Nickname Chapter 2. SQL control statements eges 590 About SQL control statements le Space Privileges SQL Procedure statement NCLUDE ALLOCATE CURSOR statemen INSERT Assignment statement 61 LOCK TABLE 613 ASSOCIATE LOCATORS statement OPEN 615 CASE statement Compound statement(Procedure) REFRESH TABLE 632 FOR statement RELEASE (Connection) 634 GET DIAGNOSTICS statement RELEASE SAVEPOINT GOTO statement RENAME IF statement RENAME TABLESPACE ITERATE statement REVOKE (Database Authorities) LEAVE Statement REVOKE (Index Privileges) LOOP statement 87 REVOKE(Package Privileges) 50 REPEAT statement 789 REVOKE (Routine Privileges) 653 RESIGNAL Statement REVOKE ( Schema Privileges) 657 RETURN statement REVOKE (Server Privileges SIGNAL statement REVOKE (Table, View, or Nickname WHILE Statement Privileg REVOKE (Table Space Privileges) 668 Appendix A DB2 Universal Database ROLLBACK echnical information SAVEPOINT Overview of db2 Universal database SELECT technical information 801 SELECT INTO Categories of DB2 technical information SET CONNECTION SET CURRENT DEFAULT TRANSFORM inting DB2 books from PDF files Ordering printed DB2 books GROUP 683 Accessing online help SET CURRENT DEGREE Finding topics by accessing the DE SET CURRENT EXPLAIN MODE Information Center from a browser 81 SET CURRENT EXPLAIN SNAPSHOT Finding product information by accessing SET CURRENT MAINTAINED TABLE the DB2 Information Center from the TYPES FOR OPTIMIZATION 691 administration tools 814 SET CURRENT PACKAGESET Viewing technical documentation online SET CURRENT QUERY OPTIMIZATIoN 695 directly from the DB2 HTML Documentation SET CURRENT REFRESH AGE SET ENCRYPTION PASSWORD IV SQL ReferenceEXPLAIN . . . . . . . . . . . . 558 FETCH . . . . . . . . . . . . . 561 FLUSH EVENT MONITOR . . . . . . 565 FLUSH PACKAGE CACHE . . . . . . 566 FREE LOCATOR . . . . . . . . . . 567 GRANT (Database Authorities) . . . . . 569 GRANT (Index Privileges) . . . . . . . 573 GRANT (Package Privileges) . . . . . . 575 GRANT (Routine Privileges) . . . . . . 579 GRANT (Schema Privileges) . . . . . . 583 GRANT (Sequence Privileges). . . . . . 586 GRANT (Server Privileges). . . . . . . 588 GRANT (Table, View, or Nickname Privileges) . . . . . . . . . . . . 590 GRANT (Table Space Privileges) . . . . . 598 INCLUDE . . . . . . . . . . . . 601 INSERT . . . . . . . . . . . . . 603 LOCK TABLE . . . . . . . . . . . 613 OPEN. . . . . . . . . . . . . . 615 PREPARE . . . . . . . . . . . . 620 REFRESH TABLE . . . . . . . . . . 632 RELEASE (Connection) . . . . . . . . 634 RELEASE SAVEPOINT . . . . . . . . 636 RENAME . . . . . . . . . . . . 637 RENAME TABLESPACE . . . . . . . 640 REVOKE (Database Authorities) . . . . . 642 REVOKE (Index Privileges) . . . . . . 647 REVOKE (Package Privileges). . . . . . 650 REVOKE (Routine Privileges) . . . . . . 653 REVOKE (Schema Privileges) . . . . . . 657 REVOKE (Server Privileges) . . . . . . 660 REVOKE (Table, View, or Nickname Privileges) . . . . . . . . . . . . 662 REVOKE (Table Space Privileges) . . . . 668 ROLLBACK. . . . . . . . . . . . 671 SAVEPOINT . . . . . . . . . . . 674 SELECT . . . . . . . . . . . . . 676 SELECT INTO . . . . . . . . . . . 677 SET CONNECTION . . . . . . . . . 680 SET CURRENT DEFAULT TRANSFORM GROUP . . . . . . . . . . . . . 683 SET CURRENT DEGREE . . . . . . . 685 SET CURRENT EXPLAIN MODE . . . . 687 SET CURRENT EXPLAIN SNAPSHOT . . 689 SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION . . . . . . 691 SET CURRENT PACKAGESET . . . . . 693 SET CURRENT QUERY OPTIMIZATION 695 SET CURRENT REFRESH AGE . . . . . 698 SET ENCRYPTION PASSWORD . . . . . 700 SET EVENT MONITOR STATE . . . . . 702 SET INTEGRITY . . . . . . . . . . 704 SET PASSTHRU . . . . . . . . . . 724 SET PATH . . . . . . . . . . . . 726 SET SCHEMA . . . . . . . . . . . 729 SET SERVER OPTION . . . . . . . . 731 SET Variable . . . . . . . . . . . 733 UPDATE. . . . . . . . . . . . . 738 VALUES . . . . . . . . . . . . . 750 VALUES INTO. . . . . . . . . . . 751 WHENEVER . . . . . . . . . . . 753 Chapter 2. SQL control statements . . . 755 About SQL control statements . . . . . 756 SQL procedure statement . . . . . . . 757 ALLOCATE CURSOR statement . . . . . 759 Assignment statement . . . . . . . . 761 ASSOCIATE LOCATORS statement . . . . 762 CASE statement . . . . . . . . . . 764 Compound statement (Procedure) . . . . 767 FOR statement . . . . . . . . . . . 775 GET DIAGNOSTICS statement . . . . . 777 GOTO statement . . . . . . . . . . 780 IF statement . . . . . . . . . . . 782 ITERATE statement . . . . . . . . . 784 LEAVE statement . . . . . . . . . . 785 LOOP statement . . . . . . . . . . 787 REPEAT statement . . . . . . . . . 789 RESIGNAL statement . . . . . . . . 791 RETURN statement . . . . . . . . . 794 SIGNAL statement . . . . . . . . . 796 WHILE statement . . . . . . . . . . 799 Appendix A. DB2 Universal Database technical information . . . . . . . . 801 Overview of DB2 Universal Database technical information . . . . . . . . 801 Categories of DB2 technical information 802 Printing DB2 books from PDF files . . . . 809 Ordering printed DB2 books . . . . . . 810 Accessing online help . . . . . . . . 810 Finding topics by accessing the DB2 Information Center from a browser . . . . 812 Finding product information by accessing the DB2 Information Center from the administration tools . . . . . . . . . 814 Viewing technical documentation online directly from the DB2 HTML Documentation CD. . . . . . . . . . . . . . . 815 iv SQL Reference, Volume 2