HP 3000 Manuals

ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL

Table of Contents

 ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL
   ISQL Reference Manual for ALLBASE/SQL and IMAGE/SQL : 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
      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

   Ap A. SQL Syntax Summary
       SQL Syntax Summary
          ADD DBEFILE
          ADD TO GROUP
          ADVANCE
          ALTER DBEFILE
          ALTER TABLE
             AddColumnSpecification
             AddConstraintSpecification
             DropConstraintSpecification
             SetTypeSpecification
             SetPartitionSpecification
          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
             ParameterDeclaration
             ResultDeclaration
          CREATE RULE
          CREATE SCHEMA
          CREATE TABLE
             Column Definition
             Unique Constraint (Table Level)
             Referential Constraint (Table Level)
             Check Constraint (Table Level)
          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
             HostVariableSpecification
          EXECUTE IMMEDIATE
          EXECUTE PROCEDURE
             ActualParameter
          FETCH
             BULK HostVariableSpecification
             Non-BULK HostVariableSpecification
          GENPLAN
          GOTO
          GRANT
             Grant RUN or EXECUTE Authority
             Grant CONNECT, DBA, or RESOURCE Authority
             Grant DBEFileSet Authority
          IF
          INCLUDE
      SQL Syntax Summary (contd)
          INSERT - 1
             SingleRowValues
             LongColumnIOString
             BulkValues
             Dynamic Parameter Substitution
          INSERT - 2
          Labeled Statement
          LOCK TABLE
          LOG COMMENT
          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 or Authority
             Revoke CONNECT, DBA, or RESOURCE Authority
             SQL Syntax--Revoke DBEFileSet Authority
          ROLLBACK WORK
          SAVEPOINT
          SELECT
             Select Statement Level
             Subquery Level
             Query Expression Level
             Query Block Level
             SelectList
             HostVariableSpecification--With BULK Option
             HostVariableSpecification--Without BULK Option
             FromSpec
             TableSpec
          SET CONNECTION
          SET CONSTRAINTS
          SET DEFAULT DBEFILESET
          SET DML ATOMICITY
          SET MULTITRANSACTION
          SETOPT
             Scan Access
             Join Algorithm
          SET PRINTRULES
          SET SESSION
          SET TRANSACTION
          SET USER TIMEOUT
          SQLEXPLAIN
          START DBE
          START DBE NEW
             DBEFile0Definition
             DBELogDefinition
          START DBE NEWLOG
             NewLogDefinition
          STOP DBE
          TERMINATE USER
          TRANSFER OWNERSHIP
          TRUNCATE TABLE
          UPDATE
             LongColumnIOString
          UPDATE STATISTICS
          UPDATE WHERE CURRENT
             LongColumnIOString
          VALIDATE
          WHENEVER
          WHILE

   Ap B. ISQL Syntax Summary
       ISQL Syntax Summary
          CHANGE
          DO
          EDIT
          END
          ERASE
          EXIT
          EXTRACT
          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

MPE/iX 5.0 Documentation