Implementing Practical DB2 Applications

AvAnthony S. Rudd

Häftad, Engelska, 1996

566 kr

Beställningsvara. Skickas inom 10-15 vardagar. Fri frakt över 249 kr.

Fler format och utgåvor

E-bok

732 kr

Beskrivning

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 system environment where DB2 operates with the MVS transaction processing subsystems: CICS, IMS and TSO. The book is intended for both beginners and experts. It describes how the various components of SQL are used to provide practical applications. Containing tips and notes that were discovered the hard way - through hands on experience - this book will be welcomed by all those looking to implement applications in DB2.

Produktinformation

Utgivningsdatum:1996-07-02
Mått:155 x 235 x 13 mm
Vikt:341 g
Format:Häftad
Språk:Engelska
Antal sidor:206
Upplaga:2
Förlag:Springer-Verlag Berlin and Heidelberg GmbH & Co. KG
ISBN:9783540199533

Utforska kategorier

Databaser inom Data och IT

Innehållsförteckning

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.