DB2 - SQL statements - session - www.cadcobol.com.br

DB2 - SQL statements - session

SQL Statement	Purpose
DECLARE GLOBAL TEMPORARY TABLE	Defines a declared temporary table.
EXPLAIN	Captures information about the chosen access plan.
SET COMPILATION ENVIRONMENT	Changes the current compilation environment in the connection to match the values contained in the compilation environment provided by a deadlock event monitor.
SET CURRENT DECFLOAT ROUNDING MODE	Verifies that the specified rounding mode is the value that is currently set for the CURRENT DECFLOAT ROUNDING MODE special register.
SET CURRENT DEFAULT TRANSFORM GROUP	Changes the value of the CURRENT DEFAULT TRANSFORM GROUP special register.
SET CURRENT DEGREE	Changes the value of the CURRENT DEGREE special register.
SET CURRENT EXPLAIN MODE	Changes the value of the CURRENT EXPLAIN MODE special register.
SET CURRENT EXPLAIN SNAPSHOT	Changes the value of the CURRENT EXPLAIN SNAPSHOT special register.
SET CURRENT FEDERATED ASYNCHRONY	Changes the value of the CURRENT FEDERATED ASYNCHRONY special register.
SET CURRENT IMPLICIT XMLPARSE OPTION	Changes the value of the CURRENT IMPLICIT XMLPARSE OPTION special register.
SET CURRENT ISOLATION	Changes the value of the CURRENT ISOLATION special register.
SET CURRENT LOCALE LC_MESSAGES	Changes the value of the CURRENT LOCALE LC_MESSAGES special register.
SET CURRENT LOCALE LC_TIME	Changes the value of the CURRENT LOCALE LC_TIME special register.
SET CURRENT LOCK TIMEOUT	Changes the value of the CURRENT LOCK TIMEOUT special register.
SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION	Changes the value of the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register.
SET CURRENT MDC ROLLOUT MODE	Assigns a value to the CURRENT MDC ROLLOUT MODE special register.
SET CURRENT OPTIMIZATION PROFILE	Assigns a value to the CURRENT OPTIMIZATION PROFILE special register.
SET CURRENT PACKAGE PATH	Assigns a value to the CURRENT PACKAGE PATH special register.
SET CURRENT PACKAGESET	Sets the schema name for package selection.
SET CURRENT QUERY OPTIMIZATION	Changes the value of the CURRENT QUERY OPTIMIZATION special register.
SET CURRENT REFRESH AGE	Changes the value of the CURRENT REFRESH AGE special register.
SET CURRENT SQL_CCFLAGS	Changes the value of the CURRENT SQL_CCFLAGS special register.
SET CURRENT TEMPORAL BUSINESS_TIME	Changes the value of the CURRENT TEMPORAL BUSINESS_TIME special register.
SET CURRENT TEMPORAL SYSTEM_TIME	Changes the value of the CURRENT TEMPORAL SYSTEM_TIME special register.
SET ENCRYPTION PASSWORD	Sets the password for encryption.
SET EVENT MONITOR STATE	Activates or deactivates an event monitor.
SET PASSTHRU	Opens a session for submitting data source native SQL directly to the data source.
SET PATH	Changes the value of the CURRENT PATH special register.
SET ROLE statement	Verifies that the authorization ID of the session is a member of a specific role.
SET SCHEMA	Changes the value of the CURRENT SCHEMA special register.
SET SERVER OPTION	Sets server option settings.
SET SESSION AUTHORIZATION	Changes the value of the SESSION USER special register.
SET USAGE LIST STATE	Manages the state of a usage list and the associated data and memory.