Implementing Practical DB2 Applications
2nd Edition
Published on 2. July 1996
Book
Paperback/Softback
XI, 206 pages
978-3-540-19953-3 (ISBN)
Description
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.
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.
More details
Edition
Second Edition 1996
Language
English
Place of publication
London
United Kingdom
Publishing group
Springer Berlin
Target group
Professional and scholarly
Professional/practitioner
Edition type
New edition
Illustrations
XI, 206 p.
Dimensions
Height: 235 mm
Width: 155 mm
Thickness: 13 mm
Weight
341 gr
ISBN-13
978-3-540-19953-3 (9783540199533)
DOI
10.1007/978-1-4471-1035-4
Schweitzer Classification
Other editions
Additional editions
Anthony S. Rudd
Implementing Practical DB2 Applications
E-Book
12/2012
2nd Edition
Springer
€53.49
Available for download
Content
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.