HPlogo ALLBASE/SQL Reference Manual: HP 9000 Computer Systems

Chapter 12 SQL Statements S - Z

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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.

Feedback to webmaster