HPlogo ALLBASE/SQL Reference Manual: HP 9000 Computer Systems

Chapter 10 SQL Statements A - D

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

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
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
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

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