HP 3000 Manuals HP 3000 Manuals
Table of Contents
ALLBASE/ISQL Reference Manual
ALLBASE/ISQL Reference Manual : COPYRIGHT NOTICE
Ch 1. Introduction
Purpose of ISQL
ISQL Users
Authorization
Native Language Support
Reading More about ISQL
Ch 2. Getting Started with ISQL
Invoking ISQL
Starting a DBE Session
Leaving ISQL
Managing Transactions
How ISQL Manages Transactions
Using SQL SAVEPOINT and ROLLBACK WORK Statements
Using SQL and ISQL Commands
Terminating Commands
Prompting Mode
Aborting Commands
Special Characters in Commands
Parameters in Commands
Using ISQL Files and Buffers
Entering Interactive Commands from the Terminal
Files Containing Commands
Creating a Profile File
Running ISQL From a Command File
Running ISQL in Job Mode
The Command Buffer
The Command History Buffer
Using a Synonym File
Getting Help
Setting Command Options
Using Other Programs within ISQL
Using the System Editor
Using System Commands and Programs
Using SQLUtil
Using SQLGEN
Handling Errors
Command Errors
DBEnvironment Errors
Unexpected ISQL or DBEnvironment Termination
Checking JCWs for Errors
Ch 3. Using ISQL for Database Tasks
Creating Objects
Controlling Access to Objects
Manipulating Data
Using the INSERT Statement
Using the INPUT Command
Using the SELECT Statement
TID Function
Using the DELETE Statement
Using the UPDATE Statement
Using the INFO Command
Unloading and Loading Tables
Using the UNLOAD Command
External Format
Internal Format
Using the LOAD Command
External Format
Internal Format
Setting the AUTOCOMMIT Option
Using Modules
Installing a Module
Ch 4. ISQL Commands
CHANGE
DO
EDIT
END
ERASE
EXIT
HELP
HOLD
INFO
INPUT
INSTALL
LIST FILE
LIST HISTORY
LIST INSTALL
LIST SET
LOAD
RECALL
REDO
RENAME
SELECTSTATEMENT
SET
SQLGEN
SQLUTIL
START
STORE
SYSTEM
UNLOAD
Ap A. SQL Syntax Summary
Ap A. SQL Syntax Summary (cont.)
ADD DBEFILE
ADD TO GROUP
ALTER DBEFILE
ALTER TABLE
AddColumnSpecification
AddConstraintSpecification
DropConstraintSpecification
Assignment (=)
BEGIN
BEGIN ARCHIVE
BEGIN DECLARE SECTION
BEGIN WORK
CHECKPOINT
CLOSE
COMMIT ARCHIVE
COMMIT WORK
CONNECT
CREATE DBEFILE
CREATE DBEFILESET
CREATE GROUP
CREATE INDEX
CREATE PROCEDURE
ParameterDeclaration
CREATE RULE
CREATE SCHEMA
CREATE TABLE
CREATE TEMPSPACE
CREATE VIEW
DECLARE CURSOR
DECLARE Variable
DELETE
DELETE WHERE CURRENT
DESCRIBE
DISABLE RULES
DISCONNECT
DROP DBEFILE
DROP DBEFILESET
DROP GROUP
DROP INDEX
DROP MODULE
DROP PROCEDURE
DROP RULE
DROP TABLE
DROP TEMPSPACE
DROP VIEW
ENABLE RULES
END DECLARE SECTION
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FETCH
BULK HostVariableSpecification
Non-BULK HostVariableSpecification
GENPLAN
GOTO
GRANT
Grant Authority for a Table or View
Grant RUN or EXECUTE Authority
Grant CONNECT, DBA, or RESOURCE Authority
IF
INCLUDE
INSERT - I
Single Row Values
LongColumnIOString
Bulk Values
Dynamic Parameter Substitution
INSERT - II
Labeled Statement
LOCK TABLE
OPEN
PREPARE
PRINT
RAISE ERROR
REFETCH
RELEASE
REMOVE DBEFILE
REMOVE FROM GROUP
RESET
RETURN
REVOKE
Revoke Authority on a Table or View
Revoke RUN or EXECUTE Authority
Revoke CONNECT, DBA, or RESOURCE Authority
ROLLBACK WORK
SAVEPOINT
SELECT
Select Statement Level
Subquery Level
Query Expression Level
Query Block Level
SelectList
HostVariableSpecification--Without BULK Option
FromSpec
TableSpec
SET CONNECTION
SET CONSTRAINTS
SET DML ATOMICITY
SET MULTITRANSACTION
SET PRINTRULES
SET USER TIMEOUT
SQLEXPLAIN
START DBE
START DBE NEW
START DBE NEWLOG
NewLogDefinition
STOP DBE
TERMINATE USER
TRANSFER OWNERSHIP
UPDATE
LongColumnIOString
UPDATE STATISTICS
UPDATE WHERE CURRENT
LongColumnIOString
VALIDATE
WHENEVER
WHILE
Ap B. ISQL Syntax Summary
Ap B. ISQL Syntax Summary (cont.)
CHANGE
DO
EDIT
END
ERASE
EXIT
HELP
HOLD
INFO
INPUT
INSTALL
LIST FILE
LIST HISTORY
LIST INSTALL
LIST SET
LOAD
ExternalInputSpec
RECALL
REDO
Subcommands
RENAME
SELECTSTATEMENT
SET
Options and Values
SQLGEN
SQLUTIL
START
STORE
SYSTEM
UNLOAD
ExternalOutputSpec
INDEX
Index