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:
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
LEADER 03662nmm a2200349 u 4500
001 EB000617237
003 EBX01000000000000000470319
005 00000000000000.0
007 cr|||||||||||||||||||||
008 140122 ||| eng
020 |a 9781447110354 
100 1 |a Rudd, Anthony S. 
245 0 0 |a Implementing Practical DB2 Applications  |h Elektronische Ressource  |c by Anthony S. Rudd 
250 |a 2nd ed. 1996 
260 |a London  |b Springer London  |c 1996, 1996 
300 |a XI, 206 p  |b online resource 
505 0 |a 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 
653 |a System Performance and Evaluation 
653 |a Data Structures and Information Theory 
653 |a Computer programming 
653 |a Programming Languages, Compilers, Interpreters 
653 |a Database Management 
653 |a Programming languages (Electronic computers) 
653 |a Programming Techniques 
653 |a Computer system failures 
653 |a Data structures (Computer science) 
653 |a Database management 
041 0 7 |a eng  |2 ISO 639-2 
989 |b SBA  |a Springer Book Archives -2004 
856 4 0 |u https://doi.org/10.1007/978-1-4471-1035-4?nosfx=y  |x Verlag  |3 Volltext 
082 0 |a 005.73 
520 |a 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