HP 3000 Manuals HP 3000 Manuals
Table of Contents
ALLBASE/SQL Quick Reference Guide
ALLBASE/SQL Quick Reference Guide : COPYRIGHT NOTICE
Ch 1. SQL Syntax Summary
Ch 1. SQL Syntax Summary (cont.)
SQL Statements
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
Ch 2. ISQL Syntax Summary
Ch 2. ISQL Syntax Summary (cont.)
Invocation
ISQL Filenames
ISQL Commands
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
Ch 3. ALLBASE/SQL Data Types
Ch 4. ALLBASE/SQL Preprocessors
C Preprocessor
Invocation
Syntax Checking Mode
Full Preprocessing Mode
Static Conversion Mode
Preprocessor Input and Output
C Declarations for ALLBASE/SQL Data Types
Compatibility of ALLBASE/SQL and C Data Types
COBOL Preprocessor
Invocation
Syntax Checking Mode
Full Preprocessing Mode
Preprocessor Input and Output
COBOL Declarations for ALLBASE/SQL Data Types
Compatibility of ALLBASE/SQL and COBOL Data Types
FORTRAN Preprocessor
Invocation
Syntax Checking Mode
Full Preprocessing Mode
Preprocessor Input and Output
FORTRAN Declarations for ALLBASE/SQL Data Types
Compatibility of ALLBASE/SQL and FORTRAN Data Types
Pascal Preprocessor
Invocation
Syntax Checking Mode
Full Preprocessing Mode
Static Conversion Mode
Preprocessor Input and Output
Pascal Declarations for ALLBASE/SQL Data Types
Compatibility of ALLBASE/SQL and Pascal Data Types
Ch 5. SQLUtil Syntax Summary
Ch 5. SQLUtil Syntax Summary (cont.)
Invocation From Inside ISQL
Invocation From Outside ISQL
SQLUtil Commands
ADDLOG
ALTDBE
ENDRECOVERY
EXIT
HELP
MOVEFILE
MOVELOG
PURGEALL
PURGEDBE
PURGEFILE
PURGELOG
QUIT
RECOVERLOG
RESCUELOG
RESTORE
RESTORELOG
SET
SETDBEMAINT
SETUPRECOVERY
SHOWACCESS
SHOWDBE
SHOWDBE-ALL
Syntax
SHOWDBE-EXIT
Syntax
SHOWDBE-HELP
SHOWDBE-LANG
SHOWDBE-MAINT
SHOWDBE-QUIT
Syntax
SHOWDBE-STARTPARMS
SHOWLOG
SHOWSET
STORE
STORELOG
STOREONLINE
SYSTEM
Ch 6. SQLGEN Syntax Summary
Ch 6. SQLGEN Syntax Summary (cont.)
Invocation From Inside ISQL
Invocation From Outside ISQL
SQLGEN Commands
EDITOR
EXIT
GENERATE ALL
GENERATE DBE
GENERATE DBEFILES
GENERATE GROUPS
GENERATE INDEXES
GENERATE LOAD
GENERATE MODAUTH
GENERATE PROCAUTH
GENERATE PROCEDURES
GENERATE RULES
GENERATE SPECAUTH
GENERATE STATISTICS
GENERATE TABAUTH
GENERATE TABLES
GENERATE TEMPSPACES
GENERATE VIEWAUTH
GENERATE VIEWS
HELP
RELEASE
SET ECHO_ALL OFF
SET ECHO_ALL ON
SET EDITOR
SET EXIT_ON_DBERR OFF
SET EXIT_ON_DBERR ON
SET SCHEMA
STARTDBE
:
Ch 7. NETUtil Syntax Summary
Ch 7. NETUtil Syntax Summary (cont.)
Invocation
NETUtil Commands
ADD ALIAS
ADD USER
CHANGE ALIAS
CHANGE USER
DELETE ALIAS
DELETE USER
EXIT
HELP
QUIT
SET ECHO
SHOW ALIAS
SHOW USER
SYSTEM
Ch 8. SQLMigrate Syntax Summary
Ch 8. SQLMigrate Syntax Summary (cont.)
Invocation
SQLMigrate Commands
ADD DBEFILE
CREATE DBEFILE
EXIT
HELP
MIGRATE
PREVIEW
QUIT
REPAIR
SET
SHOW 'DBEnvironmentName' VERSION
SHOW VERSIONS
: