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
Metrics and Models in Software Quality Engineering (2nd Edition)
Definition, Operational Definition, and Measurement
The Rayleigh Model Framework
How Do You Know Your Product Is Good Enough to Ship?
The Evaluation Phase
Measuring the Value of Process Improvement
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Local Area Network (LAN) Technologies
Internet Group Management Protocol (IGMP)
Internet Protocol Version 6 (IPv6)
User Datagram Protocol
Transmission Control Protocol (TCP) Data Flow
Cisco IOS Cookbook (Cookbooks (OReilly))
Removing Passwords from a Router Configuration File
Setting the DSCP or TOS Field
Using an Internal ISDN PRI Module
Using SNMP to Modify a Routers Running Configuration
Filtering Based on DSCP and TOS
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 16. Who Are the Neighbors Voting For?
Hack 28. Experiment with Different Cartographic Projections
Hack 64. Mapping Local Areas of Interest with Quantum GIS
Hack 71. Turn Your Tracklogs into ESRI Shapefiles
Hack 89. Publish Your Geodata to the Web with GeoServer
GO! with Microsoft Office 2003 Brief (2nd Edition)
Summary
Key Terms
Objective 11. Navigate and Rename Worksheets
Key Terms
Summary
Java All-In-One Desk Reference For Dummies
Pulling a Switcheroo
Handling Exceptions
Handling Events
Using Java Server Pages
Fun with Fonts and Colors
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