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



Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

DB2 - SQL statements - schema
SQL Statement Purpose
ALTER AUDIT POLICY Modifies the definition of an audit policy at the current server.
ALTER BUFFERPOOL Changes the definition of a buffer pool.
ALTER DATABASE Adds new storage paths to the collection of paths that are used for automatic storage tablespaces.
ALTER EVENT MONITOR Changes the definition of a TABLE or UNFORMATTED EVENT TABLE event monitor.
ALTER DATABASE PARTITION GROUP Changes the definition of a database partition group.
ALTER FUNCTION Modifies an existing function by changing the properties of the function.
ALTER HISTOGRAM TEMPLATE Modifies the template describing the type of histogram that can be used to override one or more of the default histograms of a service class or a work class.
ALTER INDEX Changes the definition of an index.
ALTER MASK Changes the definition of a column mask.
ALTER METHOD Modifies an existing method by changing the method body associated with the method.
ALTER MODULE Changes the definition of a module.
ALTER NICKNAME Changes the definition of a nickname.
ALTER PACKAGE Alters bind options for a package at the current server without having to bind or rebind the package.
ALTER PERMISSION Changes the definition of a row permission.
ALTER PROCEDURE (external) Modifies an existing external procedure by changing the properties of the procedure.
ALTER PROCEDURE (sourced) Modifies an existing sourced procedure by changing the data type of one or more parameters of the sourced procedure.
ALTER PROCEDURE (SQL) Modifies an existing SQL procedure by changing the properties of the procedure.
ALTER SCHEMA Modifies an existing schema by changing the data capture attribute of the schema.
ALTER SECURITY LABEL COMPONENT Modifies a security label component.
ALTER SECURITY POLICY Modifies a security policy.
ALTER SEQUENCE Changes the definition of a sequence.
ALTER SERVER Changes the definition of a data source in a federated system.
ALTER SERVICE CLASS Changes the definition of a service class.
ALTER STOGROUP Changes the definition of a storage group.
ALTER TABLE Changes the definition of a table.
ALTER TABLESPACE Changes the definition of a table space.
ALTER THRESHOLD Changes the definition of a threshold.
ALTER TRIGGER Changes the definition of a trigger.
ALTER TRUSTED CONTEXT Changes the definition of a trusted context at the current server.
ALTER TYPE (structured) Changes the definition of a structured type.
ALTER USAGE LIST Changes the definition of a usage list.
ALTER USER MAPPING Changes the definition of a user authorization mapping.
ALTER VIEW Changes the definition of a view by altering a reference type column to add a scope.
ALTER WORK ACTION SET Adds, alters, or drops work actions within a work action set.
ALTER WORK CLASS SET Adds, alters, or drops work classes within a work class set.
ALTER WORKLOAD Changes a workload.
ALTER WRAPPER Updates the options that, along with a wrapper module, are used to access data sources of a specific type.
ALTER XSROBJECT Enables or disables decomposition support for a specific XML schema.
AUDIT Determines the audit policy that is to be used for a particular database or database object at the current server.
COMMENT Replaces or adds a comment to the description of an object.
CREATE ALIAS Defines an alias for a module, nickname, sequence, table, view, or another alias.
CREATE AUDIT POLICY Defines an auditing policy at the current server.
CREATE BUFFERPOOL Defines a new buffer pool.
CREATE DATABASE PARTITION GROUP Defines a database partition group.
CREATE EVENT MONITOR Specifies events in the database to monitor.
CREATE EVENT MONITOR (activities) Specifies activity events in the database to monitor.
CREATE EVENT MONITOR (change history) Specifies change history events in the database to monitor.
CREATE EVENT MONITOR (locking) Specifies locking events in the database to monitor.
CREATE EVENT MONITOR (package cache) Specifies package cache statement events in the database to monitor.
CREATE EVENT MONITOR (statistics) Specifies statistics events in the database to monitor.
CREATE EVENT MONITOR (threshold violations) Specifies threshold violation events in the database to monitor.
CREATE FUNCTION Registers a user-defined function.
CREATE FUNCTION Registers a user-defined function.
CREATE FUNCTION (aggregate interface) Registers a user-defined aggregate function at the current server.
CREATE FUNCTION (external scalar) Registers a user-defined external scalar function.
CREATE FUNCTION (external table) Registers a user-defined external table function.
CREATE FUNCTION (OLE DB external table) Registers a user-defined OLE DB external table function.
CREATE FUNCTION (sourced or template) Registers a user-defined sourced function or a function template.
CREATE FUNCTION (SQL scalar, table, or row) Defines a user-defined SQL function.
CREATE FUNCTION MAPPING Defines a function mapping.
CREATE GLOBAL TEMPORARY TABLE Defines a created temporary table.
CREATE HISTOGRAM TEMPLATE Defines a template describing the type of histogram that can be used to override one or more of the default histograms of a service class or a work class.
CREATE INDEX Defines an index on a table.
CREATE INDEX EXTENSION Defines an extension object for use with indexes on tables with structured or distinct type columns.
CREATE MASK Defines a column mask.
CREATE METHOD Defines a method body to associate with a previously defined method specification.
CREATE MODULE Defines a module.
CREATE NICKNAME Defines a nickname.
CREATE PERMISSION Defines a row permission.
CREATE PROCEDURE Defines a procedure.
CREATE PROCEDURE (external) Defines an external procedure.
CREATE PROCEDURE (sourced) Defines a procedure (the sourced procedure) that is based on another procedure (the source procedure).
In a federated system, a federated procedure is a sourced procedure whose source procedure is at a supported data source.
CREATE PROCEDURE (SQL) Defines an SQL procedure.
CREATE ROLE Defines a role at the current server.
CREATE SCHEMA Defines a schema.
CREATE SECURITY LABEL COMPONENT Defines a component that is to be used as part of a security policy.
CREATE SECURITY LABEL Defines a security label.
CREATE SECURITY POLICY Defines a security policy.
CREATE SEQUENCE Defines a sequence.
CREATE SERVER Defines a data source to a federated database.
CREATE SERVICE CLASS Defines a service class.
CREATE STOGROUP Defines a new storage group within the database.
CREATE SYNONYM Defines a synonym for a module, nickname, sequence, table, view, or another synonym.
CREATE TABLE Defines a table.
CREATE TABLESPACE Defines a table space.
CREATE THRESHOLD Defines a threshold.
CREATE TRANSFORM Defines transformation functions.
CREATE TRIGGER Defines a trigger.
CREATE TRUSTED CONTEXT Defines a trusted context at the current server.
CREATE TYPE Defines a user-defined data type at the current server.
CREATE TYPE (array) Defines an array type.
CREATE TYPE (cursor) Defines a cursor type.
CREATE TYPE (distinct) Defines a distinct data type.
CREATE TYPE (row) Defines a row type.
CREATE TYPE (structured) Defines a structured data type.
CREATE TYPE MAPPING Defines a mapping between data types.
CREATE USAGE LIST Defines a usage list in order to monitor all unique sections (DML statements) that have referenced a particular table or index during their execution.
CREATE USER MAPPING Defines a mapping between user authorizations.
CREATE VARIABLE Defines a global variable.
CREATE VIEW Defines a view of one or more table, view or nickname.
CREATE WORK ACTION SET Defines a work action set and work actions within the work action set.
CREATE WORK CLASS SET Defines a work class set.
CREATE WORKLOAD Defines a workload.
CREATE WRAPPER Registers a wrapper.
DROP Deletes objects in the database.
GRANT (database authorities) Grants authorities on the entire database.
GRANT (exemption) Grants an exemption on an access rule for a specified label-based access control (LBAC) security policy.
GRANT (global variable privileges) Grants one or more privileges on a created global variable.
GRANT (index privileges) Grants the CONTROL privilege on indexes in the database.
GRANT (module privileges) Grants privileges on a module.
GRANT (package privileges) Grants privileges on packages in the database.
GRANT (role) Grants roles to users, groups, or to other roles.
GRANT (routine privileges) Grants privileges on a routine (function, method, or procedure).
GRANT (schema privileges) Grants privileges on a schema.
GRANT (security label) Grants a label-based access control (LBAC) security label for read access, write access, or for both read and write access.
GRANT (sequence privileges) Grants privileges on a sequence.
GRANT (server privileges) Grants privileges to query a specific data source.
GRANT (SETSESSIONUSER privilege) Grants the privilege to use the SET SESSION AUTHORIZATION statement.
GRANT (table space privileges) Grants privileges on a table space.
GRANT (table, view, or nickname privileges) Grants privileges on tables, views and nicknames.
GRANT (workload privileges) Grants the USAGE privilege on a workload.
GRANT (XSR object privileges) Grants the USAGE privilege on an XSR object.
REFRESH TABLE Refreshes the data in a materialized query table.
RENAME Renames an existing table.
RENAME STOGROUP Renames an existing storage group.
RENAME TABLESPACE Renames an existing table space.
REVOKE (database authorities) Revokes authorities from the entire database.
REVOKE (exemption) Revokes the exemption on an access rule for a specified label-based access control (LBAC) security policy.
REVOKE (global variable privileges) Revokes one or more privileges on a created global variable.
REVOKE (index privileges) Revokes the CONTROL privilege on given indexes.
REVOKE (module privileges) Revokes privileges on a module.
REVOKE (package privileges) Revokes privileges from given packages in the database.
REVOKE (role) Revokes roles from users, groups, or other roles.
REVOKE (routine privileges) Revokes privileges on a routine (function, method, or procedure).
REVOKE (schema privileges) Revokes privileges on a schema.
REVOKE (security label) Revokes a label-based access control (LBAC) security label for read access, write access, or for both read and write access.
REVOKE (sequence privileges) Revokes privileges on a sequence.
REVOKE (server privileges) Revokes privileges to query a specific data source.
REVOKE (SETSESSIONUSER privilege) Revokes the privilege to use the SET SESSION AUTHORIZATION statement.
REVOKE (table space privileges) Revokes the USE privilege on a given table space.
REVOKE (table, view, or nickname privileges) Revokes privileges from given tables, views or nicknames.
REVOKE (workload privileges) Revokes the USAGE privilege on a workload.
REVOKE (XSR object privileges) Revokes the USAGE privilege on an XSR object.
SET INTEGRITY Sets the set integrity pending state and checks data for constraint violations.
TRANSFER OWNERSHIP Transfers ownership of a database object.


© Copyright IBM Corp.