Cover Image
Read Now

Implementing Practical DB2 Applications

Implementing Practical DB2 Applications provides a concise source of information for the development and implication of applications using IBM's DB2 relational database package in the MVS environment. The book describes the flagship DB2 version, namely that implemented for the MVS operating sys...

Full description

Bibliographic Details
Main Author: Rudd, Anthony S.
Format: eBook
Language:English
Published: London Springer London 1996, 1996
Edition:2nd ed. 1996
Subjects:
System Performance And Evaluation
Data Structures And Information Theory
Computer Programming
Programming Languages, Compilers, Interpreters
Database Management
Programming Languages (electronic Computers)
Programming Techniques
Computer System Failures
Data Structures (computer Science)
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
Table of Contents:
  • 1. Introduction
  • 1.1 DATABASE2 (DB2) environment
  • 1.2 DB2 data objects
  • 1.3 Access to DB2 tables
  • 1.4 Use of SQL
  • 1.5 Use of SQL from applications
  • 2. Application Design
  • 2.1 Application design
  • 2.2 Application considerations
  • 2.3 Which product to use
  • 3. QMF Facilities
  • 3.1 Introduction
  • 3.2 QMF objects
  • 3.3 QMF invocation
  • 3.4 QMF command facilities
  • 3.5 Invocation of QMF
  • 3.6 QMF callable interface
  • 3.7 QMF command interface
  • 4. QMF Commands
  • 4.1 Introduction
  • 4.2 Commands
  • 4.3 Example
  • 4.4 External QMF data
  • 4.5 QMF external data format
  • 4.6 IXF data
  • 4.7 QMF external data
  • 4.8 QMF data format
  • 4.9 QMF report data
  • 5. Program Environment
  • 5.1 Introduction
  • 5.2 JCL procedures
  • 5.3 Example
  • 5.4 DB2I (DB2 Interactive)
  • 6. DB2 program Invocation
  • 6.1 Introduction
  • 6.2 Commands pertaining to DB2
  • 6.3 DB2 subcommands
  • 6.4 DB2I (DATABASE2 Interactive)
  • 6.5 Invoke program independent of DB2 (CAF interface)
  • 7. Issuing SQL statements from within a program
  • 7.1 Introduction
  • 7.2 SQL status
  • 7.3 Program host variables
  • 7.4 Indicator variables
  • 7.5 Use of SQL from programs
  • 8. Embedded SQL Statements
  • 8.1 Introduction
  • 8.2 Statements
  • 9. Transaction Processing
  • 9.1 Introduction
  • 9.2 SQL transaction concepts
  • 9.3 Consistency
  • 9.4 Concurrency
  • 10. Testing
  • 10.1 Introduction
  • 10.2 DB2 testing tools
  • 10.3 Testing of programs using DB2 (SQL) facilities
  • 10.4 Commit/Rollback in the testing environment
  • 10.5 Summary
  • 11. Worked Example
  • 11.1 Introduction
  • 11.2 Problem specification
  • 11.3 QMF solution
  • 11.4 Program solution
  • 11.5 Summary
  • Appendix A. Syntax Notation
  • Appendix B. SQL Control Areas
  • Appendix C. Glossary

Similar Items