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
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Storing Connection Strings
Retrieving and Managing Data
Copying Rows from One DataTable to Another
Converting a DataReader to a DataSet
Using a Transaction with a DataAdapter
A+ Fast Pass
Domain 1 Installation, Configuration, and Upgrading
Domain 2 Diagnosing and Troubleshooting
Domain 3 Preventive Maintenance
Domain 1 Operating System Fundamentals
Domain 2 Installation, Configuration, and Upgrading
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Jump Start with SWT/JFace
Layouts
Combos and Lists
SWT Graphics and Image Handling
Eclipse Forms
Building Web Applications with UML (2nd Edition)
Role of Modeling
Activities
Software Development for Web Applications
Architecture Activities
The User Experience
Java How to Program (6th Edition) (How to Program (Deitel))
Declaring New Exception Types
Introduction
Handling HTTP get Requests
Scripting
Introduction
Junos Cookbook (Cookbooks (OReilly))
Forcibly Logging a User Out
Changing the Size of a Logging File
Setting an IP Address for the Router
Finding Out What IP Addresses Are Used on the Router
Moving IS-IS Traffic off a Router
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