DB2 REXX SQL for VM/ESA(R): Installation and Reference


Table of Contents

  • About This Manual
  • Who Should Use This Manual
  • How This Manual Is Organized
  • Terminology
  • If You Need More Information
  • Highlighting Conventions
  • |How to Send Your Comments
  • Syntax Notation Conventions
  • EXEC Conventions
  • Summary of Changes
  • |Summary of Changes for DB2 Version 7 Release 1

  • Installation

  • Chapter 1. Before You Begin
  • Prerequisites for Running DB2 RXSQL
  • RXSQL Installation Prerequisites
  • Overview of the Installation Process
  • DB2 RXSQL Machine-Readable Material
  • Virtual Machine Requirements
  • Chapter 2. Installing DB2 RXSQL
  • Installing DB2 RXSQL on Minidisks
  • Installing RXSQL in SFS Directories
  • Installation Verification
  • Chapter 3. Installing a REXX SQL NLS Language
  • Installation Requirements and Considerations
  • Installation Instructions
  • Preventive Service Planning and Service Instructions
  • Chapter 4. Installing Preventive and Corrective Service
  • Installing Preventive Service
  • Installing Corrective Service
  • Reloading HELP Text
  • Reloading the DB2 RXSQL Package

  • Reference

  • Chapter 5. Getting Started with DB2 RXSQL
  • What is DB2 RXSQL?
  • What You Get with DB2 RXSQL
  • How to Access DB2 RXSQL
  • Chapter 6. RXSQL-Supplied Programs
  • RXCASE EXEC
  • RXSELECT EXEC
  • RXSQLANG EXEC
  • RXSQLEX EXEC
  • RXSQLHLP EXEC
  • RXSQLOP EXEC
  • RXSQLVL EXEC
  • HELP RXSQL MENU
  • Chapter 7. Concepts
  • SQL Concepts
  • Illustrations of Using Dynamic SQL in RXSQL
  • Illustrations of Extended Dynamic SQL in RXSQL
  • Chapter 8. Using Dynamic and Extended Dynamic SQL Statements in RXSQL
  • Using Dynamic Statements in DB2 RXSQL
  • Using Extended Dynamic Statements in DB2 RXSQL
  • Chapter 9. Coding DB2 RXSQL Requests
  • Delimiting and Continuing DB2 RXSQL Requests
  • Elements of RXSQL Requests
  • RXSQL Request Syntax
  • Passing Data from Your REXX Program to RXSQL
  • Passing Data from RXSQL to Your REXX Program
  • RXSQL Variables
  • SQLCA Variables
  • Error Handling
  • Chapter 10. RXSQL Request Descriptions
  • ACQUIRE DBSPACE
  • ALTER DBSPACE
  • ALTER TABLE
  • Dynamic CALL
  • Extended CALL
  • CLOSE
  • COMMENT ON
  • COMMIT
  • CONNECT
  • CREATE INDEX
  • CREATE PACKAGE
  • CREATE SYNONYM
  • CREATE TABLE
  • CREATE VIEW
  • Dynamic DECLARE
  • Extended DECLARE
  • DELETE
  • Dynamic DESCRIBE
  • Extended DESCRIBE
  • DROP
  • DROP STATEMENT or DROPSTMT
  • Dynamic EXECUTE
  • Extended EXECUTE
  • EXECUTE IMMEDIATE or EXEC
  • EXPLAIN
  • FETCH
  • GRANT
  • INSERT
  • LABEL ON
  • LOCK DBSPACE
  • LOCK TABLE
  • NAMES
  • OP
  • OPEN
  • Dynamic PREPARE or PREP
  • Extended PREPARE
  • PURGE
  • PUT
  • REVOKE
  • ROLLBACK
  • SQLDATE
  • SQLISL
  • SQLTIME
  • STATE
  • STMT
  • TRACE
  • UPDATE
  • UPDATE STATISTICS
  • XCALL
  • XPREP

  • Appendixes

  • Appendix A. Files Supplied by IBM
  • Basic System Files
  • Programs and HELP Files
  • Example EXECs
  • Message Repository
  • Installation Files
  • Corrective Service Maintenance Files
  • National Language Support Files
  • Migration Considerations
  • Appendix B. Installation and Service EXECs
  • |The I5697ELO EXEC
  • The ELOAMOD EXEC
  • The ELOHLPLD EXEC
  • The ELOLKED EXEC
  • The ELOSCOR EXEC
  • The ELOSHLP EXEC
  • Appendix C. Online HELP Information
  • The ELODNLS EXEC
  • Appendix D. Installation Messages
  • Messages
  • CMS- and CP-Related Messages
  • RXSQL Installation Messages
  • Appendix E. RXSQL Return Codes and Messages
  • CMS-Related Return Codes
  • DB2 Server for VM-Related Return Codes
  • Message Format and Associated Text
  • RXSQL Error Messages
  • RXSQL Warning Messages
  • RXSQL-Supplied Program Messages
  • Appendix F. Sample Programs with Examples of RXSQL Requests
  • Examples Using RXSQL Requests
  • Examples Using Extended Dynamic RXSQL Requests
  • More Examples Using Extended Dynamic RXSQL Requests
  • Appendix G. Performance and Diagnosis
  • Performance
  • Diagnosis
  • Appendix H. Support for CMS Work Units
  • Setting CMS Work Unit Support Off
  • Switching Work Unit Support
  • Changing Database Parameters When Using CMS Work Units
  • Appendix I. RXSQL Subcommand Environment

  • Appendix J. RXSQL Runtime Environment
  • Tailoring the RXSQL Transient Module
  • Appendix K. Single User Mode Environment

  • Appendix L. Considerations and Restrictions Using the DRDA Protocol
  • Using RXSQL in a Distributed Environment
  • Appendix M. DB2 RXSQL Incompatibilities by Release
  • Version 3 Release 3 Modification 0
  • Version 3 Release 2
  • Version 3 Release 1
  • Notices
  • Programming Interface Information
  • Trademarks
  • Glossary

  • Bibliography

  • Index

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