HP SQL/V Reference Manual

HP SQL/V Reference Manual
Table of Contents
HP SQL/V Reference Manual
HP SQL/V Reference Manual : COPYRIGHT NOTICE
Introduction
HP SQL
HP SQL DATABASES
HP SQL DATA ACCESS
HP SQL OBJECTS
HP SQL USERS
QUERIES
SQL COMMAND CATEGORIES
SQL LANGUAGE STRUCTURE
READING MORE ABOUT SQL
Using SQL
CREATING DATABASES
CONTROLLING DATABASE ACCESS
DATA DEFINITION
STARTING AND TERMINATING A DBE SESSION
DATA MANIPULATION
TRANSACTION MANAGEMENT
APPLICATION PROGRAMMING
DYNAMIC PREPROCESSING
DATABASE ADMINISTRATION
Names
BASIC NAMES
DBEUserIDs
OWNER NAMES
COMPOUND IDENTIFIERS
HOST VARIABLE NAMES
DBENVIRONMENT AND DBECON FILE NAMES
SYSTEM FILE NAMES
SPECIAL NAMES
Data Types
Type Specifications
Value Comparisons
Overflow And Truncation
Underflow
Type Conversion
Null Values
Decimal Operations
Expressions
EXPRESSION
AGGREGATE FUNCTION
CONSTANT
Search Conditions
SEARCH CONDITION
BETWEEN PREDICATE
COMPARISON PREDICATE
LIKE PREDICATE
NULL PREDICATE
SQL Commands
SQL Command Summary
ADD DBEFILE
ADD TO GROUP
ALTER DBEFILE
ALTER TABLE
BEGIN ARCHIVE
BEGIN DECLARE SECTION
BEGIN WORK
CHECKPOINT
CLOSE
COMMIT ARCHIVE
COMMIT WORK
CONNECT
CREATE DBEFILE
CREATE DBEFILESET
CREATE GROUP
CREATE INDEX
CREATE TABLE
CREATE VIEW
DECLARE CURSOR
DELETE
DELETE WHERE CURRENT
DESCRIBE
DROP DBFILE
DROP DBEFILESET
DROP GROUP
DROP INDEX
DROP MODULE
DROP TABLE
DROP VIEW
END DECLARE SECTION
EXECUTE
EXECUTE IMMEDIATE
FETCH
GRANT
INCLUDE
INSERT
LOCK TABLE
OPEN
PREPARE
RELEASE
REMOVE DBEFILE
REMOVE FROM GROUP
RESET
REVOKE
ROLLBACK WORK
SAVEPOINT
SELECT
SQLEXPLAIN
START DBE
START DBE NEW
START DBE NEWLOG
START DBE RECOVER
STOP DBE
TERMINATE USER
TRANSFER OWNERSHIP
UPDATE
UPDATE STATISTICS
UPDATE WHERE CURRENT
WHENEVER
SQL Syntax Summary
EXPRESSIONS
Search Conditions
SQL Commands
ISQL Command Summary
Sample DBEnvironment
Sample DBEnvironment Files
CREASQL Stream File
STARTDBE Command File
CREATABS Command File
LOADTABS Command File
CREAINDX Command File
CREASEC Command File
SAMPLE DATA
Sample Program Files