 |
» |
|
|
|
Table of Contents - SQL Statement Summary
- ADD DBEFILE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- ADD TO GROUP
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- ADVANCE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- ALTER DBEFILE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- ALTER TABLE
- Scope
- SQL Syntax
- Parameters—ALTER TABLE
- SQL Syntax—AddColumnSpecification
- Parameters—AddColumnSpecification
- SQL Syntax—AddConstraintSpecification
- Parameters—AddConstraintSpecification
- SQL Syntax—DropConstraintSpecification
- Parameters—DropConstraintSpecification
- SQL Syntax—SetTypeSpecification
- Parameters—SetTypeSpecification
- SQL Syntax—SetPartitionSpecification
- Parameters—SetPartitionSpecification
- Description
- Authorization
- Examples
- Assignment (=)
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- BEGIN
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- BEGIN ARCHIVE
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- BEGIN DECLARE SECTION
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- BEGIN WORK
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- CHECKPOINT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CLOSE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- COMMIT ARCHIVE
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- COMMIT WORK
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CONNECT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE DBEFILE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE DBEFILESET
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE GROUP
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE INDEX
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE PARTITION
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE PROCEDURE
- Scope
- SQL Syntax
- Parameters
- SQL Syntax--ParameterDeclaration
- Parameters--ParameterDeclaration
- SQL Syntax--ResultDeclaration
- Parameters--ResultDeclaration
- Description
- Authorization
- Examples
- CREATE RULE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE SCHEMA
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE TABLE
- Scope
- SQL Syntax--CREATE TABLE
- Parameters--CREATE TABLE
- SQL Syntax--Column Definition
- Parameters--Column Definition
- SQL Syntax--Unique Constraint (Table Level)
- Parameters--Unique Constraint (Table Level)
- SQL Syntax--Referential Constraint (Table Level)
- Parameters--Referential Constraint (Table Level)
- SQL Syntax--Check Constraint (Table Level)
- Parameters--Check Constraint (Table Level)
- Description
- Authorization
- Examples
- CREATE TEMPSPACE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- CREATE VIEW
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- DECLARE CURSOR
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- DECLARE Variable
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DELETE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DELETE WHERE CURRENT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DESCRIBE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- DISABLE AUDIT LOGGING
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- DISABLE RULES
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- DISCONNECT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP DBEFILE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP DBEFILESET
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP GROUP
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP INDEX
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP MODULE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- DROP PARTITION
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP PROCEDURE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP RULE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP TABLE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP TEMPSPACE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- DROP VIEW
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- ENABLE AUDIT LOGGING
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- ENABLE RULES
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- END DECLARE SECTION
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- EXECUTE
- Scope
- SQL Syntax
- Parameters
- SQL Syntax--HostVariableSpecification
- Parameters--HostVariableSpecification
- Description
- Authorization
- Examples
- EXECUTE IMMEDIATE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- EXECUTE PROCEDURE
- Scope
- Syntax
- Parameters
- SQL Syntax--ActualParameter
- Parameters--ParameterDeclaration
- Description
- Authorization
- Examples
- FETCH
- Scope
- SQL Syntax
- Parameters
- SQL Syntax--BULK HostVariableSpecification
- Parameters--BULK HostVariableSpecification
- SQL Syntax--non-BULK HostVariableSpecification
- Parameters--non-BULK HostVariableSpecification
- Description
- Authorization
- Examples
- GENPLAN
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- GOTO
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- GRANT
- Scope
- SQL Syntax—Grant Table or View Authority
- Parameters—Grant Table or View Authority
- Authorization—Grant Table or View Authority
- SQL Syntax--Grant RUN or EXECUTE Authority
- Parameters--Grant RUN or EXECUTE Authority
- Authorization—Grant RUN or EXECUTE Authority
- SQL Syntax--Grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
- Parameters--Grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
- Description--Grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
- Authorization—Grant CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
- SQL Syntax—Grant DBEFileSet Authority
- Parameters—Grant DBEFileSet Authority
- Description
- Authorization—Grant DBEFilesSet Authority
- Examples
- IF
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- INCLUDE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- INSERT
- Scope
- SQL Syntax - Insert Rows with Defined Values
- Parameters - Insert Rows with Defined Values
- SQL Syntax--SingleRowValues
- Parameters--SingleRowValues
- SQL Syntax--LongColumnIOString
- Parameters--LongColumnIOString
- Description--LongColumnIOString
- SQL Syntax--BulkValues
- Parameters--BulkValues
- Description--Insert Rows with SingleRowValues and BulkValues
- SQL Syntax--DynamicParameterValues
- Parameters--DynamicParameterValues
- Description--Insert Rows with DynamicParameterValues
- Authorization--Insert Rows with SingleRowValues and Bulk Values
- SQL Syntax--INSERT Rows Defined by a SELECT Command (Type 2 Insert)
- Parameters--INSERT Rows Defined by a SELECT Command (Type 2 Insert)
- Description--INSERT Rows Defined by a SELECT Command (Type 2 Insert)
- Authorization--INSERT Rows Defined by a SELECT Command (Type 2 Insert)
- Examples
- Labeled Statement
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- LOCK TABLE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- LOG COMMENT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- OPEN
- Scope
- SQL Syntax
- Parameters
- Description
- PREPARE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- PRINT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- RAISE ERROR
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- REFETCH
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RELEASE
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- REMOVE DBEFILE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- REMOVE FROM GROUP
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RENAME COLUMN
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RENAME TABLE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RESET
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- RETURN
- Scope
- SQL Syntax
- Parameters
- Description
- Example
- REVOKE
- Scope
- SQL Syntax—Revoke Table or View Authority
- Parameters—Revoke Table or View Authority
- Description—Revoke Table or View Authority
- Authorization—Revoke Table or View Authority
- SQL Syntax—Revoke RUN or EXECUTE or Authority
- Parameters--Revoke RUN or EXECUTE Authority
- SQL Syntax—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
- Parameters—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
- Description—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
- Authorization—Revoke CONNECT, DBA, INSTALL, MONITOR, or RESOURCE Authority
- SQL Syntax—Revoke DBEFileSet Authority
- Parameters—Revoke DBEFileSet Authority
- Description—Revoke DBEFileSet Authority
- Authorization—Revoke DBEFileSet Authority
- Examples
- ROLLBACK WORK
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SAVEPOINT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SELECT
- Scope
- SQL Syntax--Select Statement Level
- SQL Syntax--Subquery Level
- SQL Syntax--Query Expression Level
- SQL Syntax--Query Block Level
- SelectList
- HostVariableSpecification--With BULK Option
- HostVariableSpecification--Without BULK Option
- FromSpec
- TableSpec
- SQL Syntax--Select Statement Level
- Parameters--Select Statement Level
- Description--Select Statement Level
- SQL Syntax--Subquery Level
- Parameters--Subquery Level
- Description--Subquery Level
- SQL Syntax--Query Expression Level
- Parameters--Query Expression Level
- Description--Query Expression Level
- SQL Syntax--Query Block Level
- Parameters--Query Block Level
- SQL Syntax--SelectList
- Parameters--SelectList
- SQL Syntax--BULK HostVariableSpecification
- Parameters--BULK HostVariableSpecification
- SQL Syntax--non-BULK HostVariableSpecification
- Parameters--non-BULK HostVariableSpecification
- SQL Syntax--FromSpec
- Parameters--FromSpec
- Description--Query Block Level
- Authorization
- Examples
- SET CONNECTION
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SET CONSTRAINTS
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SET DEFAULT DBEFILESET
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SET DML ATOMICITY
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SET MULTITRANSACTION
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SETOPT
- Scope
- Syntax--SETOPT
- Syntax--Scan Access
- Syntax--Join Algorithm
- Parameters
- Description
- Authorization
- Examples
- SET PRINTRULES
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SET SESSION
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SET TRANSACTION
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SET USER TIMEOUT
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- SQLEXPLAIN
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- START DBE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- START DBE NEW
- Scope
- SQL Syntax--START DBE NEW
- Parameters--START DBE NEW
- SQL Syntax--DBEFile0Definition
- Parameters--DBEFile0Definition
- SQL Syntax--DBELogDefinition
- Parameters--DBELogDefinition
- Description
- Authorization
- Example
- START DBE NEWLOG
- Scope
- SQL Syntax--START DBE NEWLOG
- Parameters--START DBE NEWLOG
- SQL Syntax--NewLogDefinition
- Parameters--NewLogDefinition
- Description
- Authorization
- Example
- STOP DBE
- Scope
- SQL Syntax
- Description
- Authorization
- Example
- TERMINATE QUERY
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- TERMINATE TRANSACTION
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- TERMINATE USER
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- TRANSFER OWNERSHIP
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- TRUNCATE TABLE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- UPDATE
- Scope
- SQL Syntax
- Parameters
- Description
- SQL Syntax--LongColumnIOString
- Parameters--LongColumnIOString
- Description--LongColumnIOString
- Authorization
- Example
- UPDATE STATISTICS
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- UPDATE WHERE CURRENT
- Scope
- SQL Syntax
- Parameters
- Description
- SQL Syntax--LongColumnIOString
- Parameters--LongColumnIOString
- Description--LongColumnIOString
- Authorization
- Example
- VALIDATE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Examples
- WHENEVER
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
- WHILE
- Scope
- SQL Syntax
- Parameters
- Description
- Authorization
- Example
This chapter describes all the SQL statements in alphabetical
order, giving syntax, parameters, descriptions, authorization requirements, and
examples for each statement. Examples often consist of groups of
statements so you can see how each statement is related to other
statements functionally. |
