DB2 Server for VSE & VM: Interactive SQL Guide and Reference

Appendix D. Summary of SQL Statements for Interactive Use

For syntax diagrams, semantic descriptions, rules, and situations where you would use the following SQL statements, refer to the DB2 Server for VSE & VM SQL Reference manual.

• ACQUIRE DBSPACE
• ALTER DBSPACE
• ALTER TABLE
• COMMENT ON
• COMMIT
• CONNECT
• CREATE INDEX
• CREATE SYNONYM
• CREATE TABLE
• CREATE VIEW
• DELETE (searched DELETE only)
• DROP DBSPACE
• DROP INDEX
• DROP PROGRAM
• DROP SYNONYM
• DROP TABLE
• DROP VIEW
• EXPLAIN
• GRANT PROGRAM PRIVILEGES
• GRANT SYSTEM AUTHORITIES
• GRANT TABLE OR VIEW PRIVILEGES
• INSERT
• Interactive select (see SELECT in the DB2 Server for VSE & VM SQL Reference manual)
• LABEL ON
• LOCK DBSPACE
• LOCK TABLE
• REVOKE
• ROLLBACK
• UPDATE (searched UPDATE only)
• UPDATE STATISTICS