DB2 Server for VSE & VM: Quick Reference

Table of Contents

About This Manual

  • Who Should Use This Manual
  • Related Publications
  • Syntax Notation Conventions
  • |How to Send Your Comments
  • Conventions for Representing Mixed Data Values
  • Short Forms Used in Syntax Diagrams

    • DB2 Language Elements

  • Primitive Elements
  • SQL Comments
  • Identifiers
  • Names and Other Metavariables
  • Data Types
  • String Representations of Dates and Times
  • Date Strings
  • Time Strings
  • Constants
  • Special Registers
  • Expressions
  • Date Arithmetic
  • Time Arithmetic
  • Timestamp Arithmetic
  • Predicate
  • Basic Predicate
  • BETWEEN Predicate
  • EXISTS Predicate
  • IN Predicate
  • LIKE Predicate
  • NULL Predicate
  • Quantified Predicate
  • Search Conditions

    • Functions

  • Column Functions
  • AVG
  • COUNT
  • MAX
  • MIN
  • SUM
  • Scalar Functions
  • CHAR
  • DATE
  • DAY
  • DAYS
  • DECIMAL
  • DIGITS
  • FLOAT
  • HEX
  • HOUR
  • INTEGER
  • LENGTH
  • MICROSECOND
  • MINUTE
  • MONTH
  • SECOND
  • STRIP
  • SUBSTR
  • TIME
  • TIMESTAMP
  • TRANSLATE
  • VALUE
  • VARGRAPHIC
  • YEAR

    • Queries

  • subselect
  • select-clause
  • from-clause
  • where-clause
  • group-by-clause
  • having-clause
  • fullselect
  • select-statement
  • order-by-clause
  • update-clause
  • with-clause

    • SQL Statements

  • Invocation
  • ACQUIRE DBSPACE (I,P)
  • |ALLOCATE CURSOR (P)
  • ALTER DBSPACE (I,P)
  • ALTER PROCEDURE (I,P)
  • ALTER PSERVER (I,P)
  • ALTER TABLE (I,P)
  • |ASSOCIATE LOCATORS (P)
  • BEGIN DECLARE SECTION (P)
  • CALL (P)
  • CLOSE (P)
  • Extended CLOSE (P)
  • COMMENT ON (I,P)
  • COMMENT ON PROCEDURE (I,P)
  • COMMIT (I,P)
  • CONNECT (I,P)
  • CREATE INDEX (I,P)
  • CREATE PACKAGE (P)
  • Using Options
  • CREATE PROCEDURE (I,P)
  • CREATE PSERVER (I,P)
  • CREATE SYNONYM (I,P)
  • CREATE TABLE (I,P)
  •  
  • CREATE VIEW (I,P)
  • DECLARE CURSOR (P)
  • Extended DECLARE CURSOR (P)
  • DELETE (I,P)
  • DESCRIBE (P)
  • Extended DESCRIBE (P)
  • |DESCRIBE CURSOR (P)
  • |DESCRIBE PROCEDURE (P)
  • DROP (I,P)
  • DROP PROCEDURE (I,P)
  • DROP PSERVER (I,P)
  • DROP STATEMENT (P)
  • END DECLARE SECTION (P)
  • EXECUTE (P)
  • Extended EXECUTE (P)
  • EXECUTE IMMEDIATE (P)
  • EXPLAIN (I,P)
  • FETCH (P)
  • Extended FETCH (P)
  • GRANT Package Privileges (I,P)
  • GRANT System Authorities (I,P)
  • GRANT Table Privileges (I,P)
  • INCLUDE (P)
  • INSERT (I,P)
  • LABEL ON (I,P)
  • LOCK DBSPACE (I,P)
  • LOCK TABLE (I,P)
  • OPEN (P)
  • Extended OPEN CURSOR (P)
  • PREPARE (P)
  • Extended PREPARE (P)
  • Basic Extended PREPARE
  • Single Row Extended PREPARE
  • Empty Extended PREPARE
  • Temporary Extended PREPARE
  • PUT (P)
  • Extended PUT (P)
  • REVOKE Package Privileges (I,P)
  • REVOKE System Authorities (I,P)
  • REVOKE Table Privileges (I,P)
  • ROLLBACK (I,P)
  • SELECT INTO (P)
  • UPDATE (I,P)
  • UPDATE STATISTICS (I,P)
  • WHENEVER (P)

    • Preprocessing the Program

  • Program Preparation Command - VM Users
  • Program Preparation Command - VSE Users
  • Multiple User Mode
  • Single User Mode
  • Program BIND Command - VSE Users

    • Interactive SQL Commands

  • Starting and Stopping ISQL - VM Users
  • Starting and Stopping ISQL - VSE Users
  • BACKOUT
  • BACKWARD
  • CANCEL
  • CHANGE
  • COLUMN
  • DISPLAY
  • END
  • ERASE
  • EXIT
  • FORMAT
  • FORWARD
  • HELP
  • HOLD
  • IGNORE
  • INPUT
  • Interactive Select
  • ISQLTRACE
  • LEFT
  • LIST
  • PRINT - VM Users
  • PRINT - VSE Users
  • RECALL
  • RENAME
  • RIGHT
  • RUN
  • SAVE
  • SET
  • START
  • STORE
  • TAB
  • ISQL Program Function Keys
  • CMS Subset VM Users

    • Operator Commands

  • COUNTER
  • SHOW

    • Database Services Utility Commands

  • Starting and Stopping the DBS Utility
  • Starting the DBS Utility - VM Users
  • Exiting from the DBS Utility - VM Users
  • Starting the DBS Utility - VSE Users
  • Exiting from the DBS Utility - VSE Users
  • COMMENT
  • CREATE SCHEMA
  • DATALOAD
  • Table-Column-ID-Subcommand (TCI)
  • Infile-subcommand
  • DATAUNLOAD
  • Data-Field-Identification Subcommand
  • REBIND PACKAGE
  • RELOAD DBSPACE
  • VM Users
  • VSE Users
  • RELOAD PACKAGE
  • VM Users
  • VSE Users
  • RELOAD TABLE
  • VM Users
  • VSE Users
  • REORGANIZE INDEX
  • SCHEMA
  • VM Users
  • VSE Users
  • SET AUTOCOMMIT
  • SET ERRORMODE
  • SET FORMAT
  • SET ISOLATION
  • SET LINECOUNT (LINEWIDTH)
  • VM Users
  • VSE Users
  • SET UPDATE STATISTICS
  • UNLOAD DBSPACE
  • VM Users
  • VSE Users
  • UNLOAD PACKAGE
  • VM Users
  • VSE Users
  • UNLOAD TABLE
  • VM Users
  • VSE Users

    • SQLCA and SQLDA

  • SQL Communication Area (SQLCA)
  • SQL Descriptor Area (SQLDA)

    • Catalog Tables

  • Roadmap
  • Catalog Table Descriptions

    • Application Server Support for VSE

  • DBNAME Directory

    • SQL Reserved Words

    DBS Utility Reserved Words

    Notes

    Notices

  • Programming Interface Information
  • Trademarks


    • [ Top of Page | Previous Page | Next Page | Table of Contents ]