Categories of SQL statements

SQL statements that are supported in Db2 for z/OS® are often organized into various categories.

The following tables shows some of that categories that are used formally and informally to organize that SQL statements that are supported in Db2 for z/OS

SQL schema statements	The SQL schema statements can be used to create, alter, and drop schemas and schema objects. The following SQL schema statements are also categorized as Data Definition Language (DDL) statements: ALTER DATABASE ALTER FUNCTION (external) ALTER FUNCTION (compiled SQL scalar) ALTER FUNCTION (inlined SQL scalar) ALTER FUNCTION (SQL table) ALTER INDEX ALTER MASK ALTER PERMISSION ALTER PROCEDURE (external) ALTER PROCEDURE (SQL - external) ALTER PROCEDURE (SQL native) ALTER SEQUENCE ATLTER STOPGROUP ALTER TABLE ALTER TABLESPACE ALTER TRIGGER (advanced) ALTER TRIGGER ALTER TRUSTED CONTEXT ALTER VIEW COMMENT CREATE ALIAS CREATE AUXILIARY TABLE CREATE DATABASE CREATE FUNCTION (various forms) CREATE GLOBAL TEMP TABLE CREATE INDEX CREATE LOB TABLESPACE CREATE MASK CREATE PERMISSION CREATE PROCEDURE (various forms) CREATE ROLE CREATE SEQUENCE CREATE STOGROUP CREATE TABLE CREATE TABLESPACE CREATE TRIGGER (advanced) CREATE TRIGGER (basic) CREATE TRUSTED CONTEXT CREATE TYPE ARRAY CREATE TYPE DISTINCT CREATE VARIABLE CREATE VIEW DROP LABEL RENAME The following SQL schema statements are also categorized as Data Control Language (DCL) statements: GRANT (various forms) REVOKE (various forms) TRANSFER OWNERSHIP
SQL data statements	The following SQL data statements can be used to retrieve data with queries, and insert, update, and delete operations on tables. SQL data statements are also categorized as Data Manipulation Language (DML) statements. The following SQL data statements can also be categorized as data change statements: INSERT UPDATE MERGE DELETE TRUNCATE The following SQL data statements can also be categorized as queries: SELECT (various forms) SELECT INTO The following statements are also considered SQL data statements: ALLOCATE CURSOR ASSOCIATE LOCATORS CALL CLOSE DECLARE CURSOR OPEN FETCH FREE LOCATOR HOLD LOCATOR LOCK TABLE REFRESH TABLE SET `assignment-statement` VALUES VALUES INTO
SQL transaction statements	The following SQL transaction statements can be used to set parameters for transactions, and start or terminate transactions. COMMIT RELEASE SAVEPOINT ROLLBACK SAVEPOINT
SQL control statements	SQL control statements the execution of a sequence of SQL statements by using a structured programming language to write the body for SQL functions, native SQL procedures, and advanced triggers with SQL control statements. These statements are also categorized as SQL Procedural Language (SQL PL) statements. They are documented separately from most SQL statements. For more information, see SQL procedural language (SQL PL).
SQL connection statements	The following SQL connection statements initiate and terminate connections, and allow clients to switch from a session with one database server to another. CONNECT RELEASE (connection) SET CONNECTION
SQL session statements	The following SQL session statements set some default values and other parameters of a session. DECLARE GLOBAL TEMP TABLE SET CURRENT ACCELERATOR SET CURRENT APPLICATION COMPATIBILITY SET CURRENT APPLICATION ENCODING SCHEME SET CURRENT DEBUG MODE SET CURRENT DECFLOAT ROUNDING MODE SET CURRENT DEGREE SET CURRENT EXPLAIN MODE SET CURRENT GET_ACCEL_ARCHIVE SET CURRENT LOCALE LC_CTYPE SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION SET CURRENT OPTIMIZATION HINT SET CURRENT PACKAGE PATH SET CURRENT PACKAGE SET SET CURRENT PRECISION SET CURRENT QUERY ACCELERATION SET CURRENT QUERY ACCELERATION WAITFORDATA SET CURRENT REFRESH AGE SET CURRENT ROUTINE VERSION SET CURRET RULES SET CURRENT SQLID SET CURRENT TEMPORAL BUSINESS_TIME SET CURRENT TEMPORAL SYSTEM_TIME SET CURRENT ENCRYPTION PASSWORD SET PATH SET SCHEMA SET SESSION TIME ZONE
SQL diagnostic statements	The following SQL diagnostics statements get diagnostics information from the diagnostics area and signal exceptions in SQL routines. GET DIAGNOSTICS SIGNAL
SQL dynamic statements	The following SQL dynamic statements can be used to prepare and execute dynamically-generated SQL statements, and obtain information about them. DESCRIBE CURSOR DESCRIBE INPUT DESCRIBE OUTPUT DESCRIBE PROCEDURE DESCRIBE TABLE EXECUTE EXECUTE IMMEDIATE PREPARE
SQL host language statements	The following statements can be used in host language application programs. BEGIN DECLARE SECTION DECLARE STATEMENT DECLARE TABLE DECLARE VARIABLE END DECLARE SECTION EXCHANGE INCLUDE WHENEVER