Flylib.com
DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)
DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)
ISBN: 0131007718
EAN: 2147483647
Year: 2002
Pages: 163
Authors:
Susan Lawson
BUY ON AMAZON
Main
TOC
Copyright
IBM DB2 Certification Guide Series
Acknowledgments
Preface
Part 1: Introduction to DB2 UDB for OS390 and zOS
Part 2: Structured Query Language
Part 3: Developing Applications
Part 4: Programming and Language Environments
Part 5: Advanced Programming Functions
Part 1: Introduction to DB2 UDB for OS390 and zOS
Chapter 1. Product Overview
DB2 and E-Business
DB2 Universal Database
DB2 Middleware and Connectivity
DB2 Application Development
DB2 Administration
Data Management Tools
Summary
Additional Product Resources
Chapter 2. Database Objects
Understanding Data Structures
Managing Database Objects
Database Design and Implementation
Access to DB2 Objects
Summary
Additional Resources
Part 2: Structured Query Language
Chapter 3. Basic SQL Coding
Data Retrieval
Data Modification
Summary
Additional Resources
Chapter 4. Advanced SQL Coding
Subqueries
Unions
Nested Table Expressions
Joins
CASE Expressions
Row Expressions
OLAP Features
Summary
Additional Resources
Part 3: Developing Applications
Chapter 5. Using SQL in an Application Program
DB2 Application Development Environment
Delimiting SQL in a Program
Declaring Table and View Definitions
Host Variables and Host Structures
SQL Execution Validation
Using Cursors
Using Dynamic SQL
Summary
Additional Resources
Chapter 6. Binding an Application Program
Precompile and Bind
Plan or Package Ownership
Summary
Additional Resources
Chapter 7. Application Program Features
Application Program Features
Commit, Rollback, and Savepoint
Global Transactions
Global Temporary Tables
Fetch for Limited Rows
Identity Columns
Chapter 8. Stored Procedures
Stored Procedures
Benefits
Writing Stored Procedures
Defining Stored Procedures
Execution Environments
SQL Procedure Language
Stored Procedure Builder
Summary
Additional Resources
Chapter 9. Testing and Debugging Applications
Establishing a Test Environment
Debugging Application Programs
Locating the Problem
Testing and Debugging Stored Procedures
Summary
Additional Resources
Chapter 10. Accessing Distributed Data
Distributed Data
Coding Methods for Distributed Data
Programming Considerations
Remote Query Performance
Summary
Additional Distributed Resources
Part 4: Programming and Language Environments
Chapter 11. ODBCCLI Programming
Embedded Dynamic Versus Call-Level Interface
The DB2 ODBC Environment
Handles
Database Connections
Transaction Control
Executing SQL Statements
Retrieving Results
ODBC Stored Procedures
Error Handling and Problem Determination
Sample Program
Summary
Additional Resources
Chapter 12. DB2 Traditional Programming
COBOL
C and C
REXX
Summary
Additional Resources
Chapter 13. Java Programming
DB2 and Java
JDBC
SQLJ
Design Guidelines for Applications
Java Stored Procedures and UDFs
Summary
Additional Resources
Chapter 14. Attachment Programming
Attachments
TSO
CICS
IMS
Call Attachment Facility
RRSAF
Summary
Additional Resources
Part 5: Advanced Programming Functions
Chapter 15. Object-Relational Programming
Triggers
Object-Relational Extensions
Extenders
LOB and Extender Usage
Enabling Extenders
Summary
Additional Resources
Chapter 16. Locking and Concurrency
Locking Data
Avoiding Locks
System Parameters
Claims and Drains
Locking Issues and Problems
Summary
Additional Resources
Chapter 17. Application Performance and Optimization
Elements of Performance
Additional Resources
Tuning Guidelines
Access Paths and Optimization
Designing Indexes for Performance
Query Parallelism
Database Monitoring
Tracing Problems in DB2
Using DISPLAY Commands
Summary
Appendix A. IBM Certified Solutions Expert DB2 UDB Family Application Development
Certification Test Objectives
Sample Test
Chapter B. Resources
DB2 Universal Database Server for OS390 v7 Product Libraries
Chapter C. DB2CERT Database DDLT
DB2(R) Universal Database for OS/390 V7.1 Application Certification Guide (IBM DB2 Certification Guide Series)
ISBN: 0131007718
EAN: 2147483647
Year: 2002
Pages: 163
Authors:
Susan Lawson
BUY ON AMAZON
The Complete Cisco VPN Configuration Guide
Summary
Summary
ISAKMP/IKE Phase 1 Device Authentication
Monitoring and Managing Management Connections
Router Remote Access Connections
Competency-Based Human Resource Management
Competency-Based Employee Rewards
Competency-Based Employee Development
Competency-Based HR Management The Next Steps
Appendix A Frequently Asked Questions About Competency-Based HR Management
Appendix B Further Suggestions on Employee Development
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
What this book does not cover
Services (as Web services)
How service-orientation principles inter-relate
A.1. RailCo Ltd.
A.2. Transit Line Systems Inc.
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 8. Remote Control Mac OS X with Bluetooth Phones and PDAs
Hack 21. Broadcast Your GPS Position
Hack 41. Visualize a Network
Hack 47. Securely Connect Two Networks
Appendix B. Wireless Hardware Guide
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Inserting Pictures into Diagrams
Applying Themes to Entire Diagrams
Key Points
Key Points
Laying Out Office Spaces
Python Standard Library (Nutshell Handbooks) with
The shutil Module
The xdrlib Module
The profile Module
The termios Module
The statvfs Module
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies