DB2 REXX SQL for VM/ESA(R): Installation and Reference
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 ]