HPlogo

ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL: HP 3000 MPE/iX Computer Systems
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

spacerspacerspacer
spacer
spacer
   
 

HP Part Number: 36216-90095

Edition: Sixth Edition

Published: Printed in U.S.A. 1994

Table of Contents

ALLBASE/SQL Manuals
Preface
1 Introduction
Purpose of ISQL
ISQL Users
Authorization
Native Language Support
Reading More about ISQL
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
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
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
Using the DELETE Statement
Using the UPDATE Statement
Using the INFO Command
Unloading and Loading Tables
Using the UNLOAD Command
Using the LOAD Command
Using Modules
Installing a Module
4 ISQL Commands
CHANGE
Scope
ISQL Syntax
Parameters
Description
Example
DO
Scope
ISQL Syntax
Parameters
Description
Example
EDIT
Scope
ISQL Syntax
Example
END
Scope
ISQL Syntax
Description
Example
ERASE
Scope
ISQL Syntax
Parameters
Description
Example
EXIT
Scope
ISQL Syntax
Description
Example
EXTRACT
Scope
ISQL Syntax
Parameters
Description
Authorization
Example
HELP
Scope
ISQL Syntax
Parameters
Description
Example
HOLD
Scope
ISQL Syntax
Parameters
Description
Example
INFO
Scope
ISQL Syntax
Parameters
Description
Authorization
Example
INPUT
Scope
ISQL Syntax
Parameters
Description
Authorization
Example
INSTALL
Scope
ISQL Syntax
Parameters
Description
Authorization
Example
LIST FILE
Scope
ISQL Syntax
Parameters
Description
Example
LIST HISTORY
Scope
ISQL Syntax
Parameters
Description
Example
LIST INSTALL
Scope
ISQL Syntax
Parameters
Description
Example
LIST SET
Scope
ISQL Syntax
Parameters
Description
Example
LOAD
Scope
ISQL Syntax
Parameters
Description
Authorization
Example
RECALL
Scope
ISQL Syntax
Parameters
Description
Example
REDO
Scope
ISQL Syntax
Parameters
Description
Example
RENAME
Scope
ISQL Syntax
Parameters
Description
Example
SELECTSTATEMENT
Scope
ISQL Syntax
Parameters
Description
Authorization
Example
SET
Scope
ISQL Syntax
Parameters
Description
Example
SQLGEN
Scope
ISQL Syntax
Description
Example
SQLUTIL
Scope
ISQL Syntax
Description
Example
START
Scope
ISQL Syntax
Parameters
Description
Authorization
Example
STORE
Scope
ISQL Syntax
Parameters
Description
Example
SYSTEM
Scope
ISQL Syntax
Parameters
Example
UNLOAD
Scope
ISQL Syntax
Parameters
Description
Authorization
Example
A SQL Syntax Summary
ADD DBEFILE
ADD TO GROUP
ADVANCE
ALTER DBEFILE
ALTER TABLE
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 PARTITION
CREATE PROCEDURE
CREATE RULE
CREATE SCHEMA
CREATE TABLE
CREATE TEMPSPACE
CREATE VIEW
DECLARE CURSOR
DECLARE Variable
DELETE
DELETE WHERE CURRENT
DESCRIBE
DISABLE AUDIT LOGGING
DISABLE RULES
DISCONNECT
DROP DBEFILE
DROP DBEFILESET
DROP GROUP
DROP INDEX
DROP MODULE
DROP PARTITION
DROP PROCEDURE
DROP RULE
DROP TABLE
DROP TEMPSPACE
DROP VIEW
ENABLE AUDIT LOGGING
ENABLE RULES
END DECLARE SECTION
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FETCH
GENPLAN
GOTO
GRANT
IF
INCLUDE
INSERT - 1
INSERT - 2
Labeled Statement
LOCK TABLE
LOG COMMENT
OPEN
PREPARE
PRINT
RAISE ERROR
REFETCH
RELEASE
REMOVE DBEFILE
REMOVE FROM GROUP
RESET
RETURN
REVOKE
ROLLBACK WORK
SAVEPOINT
SELECT
SET CONNECTION
SET CONSTRAINTS
SET DEFAULT DBEFILESET
SET DML ATOMICITY
SET MULTITRANSACTION
SETOPT
SET PRINTRULES
SET SESSION
SET TRANSACTION
SET USER TIMEOUT
SQLEXPLAIN
START DBE
START DBE NEW
START DBE NEWLOG
STOP DBE
TERMINATE USER
TRANSFER OWNERSHIP
TRUNCATE TABLE
UPDATE
UPDATE STATISTICS
UPDATE WHERE CURRENT
VALIDATE
WHENEVER
WHILE
B ISQL Syntax Summary
CHANGE
DO
EDIT
END
ERASE
EXIT
EXTRACT
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
Index

List of Figures

1-1 ISQL and SQLCore Interaction
2-1 Command Sources
2-2 ISQL Commands Related to Command Files
2-3 ISQL Commands Related to the Command Buffer
2-4 ISQL Commands Related to the Command History Buffer
3-1 Files Used for SELECT Command

List of Tables

2-1 Special Characters in ISQL
2-2 SET Command Options
2-3 JCWs Set by ISQL
3-1 SQLTID Data Internal Format
4-1 ISQL Command Summary
4-2 Valid IBM Mainframe Format Types
   


ALLBASE/SQL Manuals  
Feedback to webmaster