|
|
Table of Contents
- 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
Chapters 10, 11 and 12 describe 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.
|