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
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
Presenting InfoPath 2003 SP-1
Formatting Forms
Adding Views to a Template
Setting Form Template and Digital Signing Options
Writing Advanced Event Handlers
Lotus Notes and Domino 6 Development (2nd Edition)
Major Features of Lotus Notes
Advanced Form Design
Creating Subforms
Creating a Complex Agent
Understanding the Domino Web Application Server
C & Data Structures (Charles River Media Computer Engineering)
C Operators
Structures
Linked Lists
Problems in Arrays, Searching, Sorting, Hashing
Miscellaneous Problems
Introduction to 80x86 Assembly Language and Computer Architecture
Procedures
Floating-Point Arithmetic
Appendix B Useful MS-DOS Commands
Appendix C MASM 6.11 Reserved Words
Appendix D 80x86 Instructions (by Mnemonic)
Data Structures and Algorithms in Java
Projects
Best, Worst, and Average Case
The Java Collections Framework Again
Out to the Disk
External Sorting
Understanding Digital Signal Processing (2nd Edition)
DFT SHIFTING THEOREM
IMPROVING IIR FILTERS WITH CASCADED STRUCTURES
FREQUENCY-DOMAIN WINDOWING
GENERATING NORMALLY DISTRIBUTED RANDOM DATA
Section E.1. USING LOGARITHMS TO DETERMINE RELATIVE SIGNAL POWER
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