Muutke küpsiste eelistusi

DB2 Universal Database v7.1: Application Development Certification Guide [Pehme köide]

3.00/5 (6 hinnangut Goodreads-ist)
, , ,
  • Formaat: Paperback / softback, 320 pages, kõrgus x laius x paksus: 232x177x20 mm, kaal: 632 g
  • Ilmumisaeg: 17-Apr-2001
  • Kirjastus: IBM Press
  • ISBN-10: 0130913677
  • ISBN-13: 9780130913678
Teised raamatud teemal:
  • Pehme köide
  • Hind: 69,39 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
DB2 Universal Database v7.1: Application Development Certification GuideSuurem pilt
  • Formaat: Paperback / softback, 320 pages, kõrgus x laius x paksus: 232x177x20 mm, kaal: 632 g
  • Ilmumisaeg: 17-Apr-2001
  • Kirjastus: IBM Press
  • ISBN-10: 0130913677
  • ISBN-13: 9780130913678
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780130913678.html
Märksõnad:
IBM has just expanded its highly successful DB2 certification program to include a developer's exam -- and this is the first book to offer start-to-finish preparation! The book covers every DB2 Application Developer exam objective, and includes a complete sample exam. Start by reviewing the DB2 client/server environment, comparing the multiple programming interfaces available to DB2 application developers, and understanding when to choose each. Next, walk through the fundamentals of DB2 application development with Embedded SQL, ADO, CLI/ODBC, JDBC, SQLJ, and the Perl DBI. Learn how to create effective stored procedures, and when to use them. Discover how to use DB2 extenders to enhance your application's functionality, adding more effective search features, XML support, multimedia archive management, and more.

Muu info

IBM has just expanded its highly successful DB2 certification program to include a developer's exam -- and this is the first book to offer start-to-finish preparation! The book covers every DB2 Application Developer exam objective, and includes a complete sample exam. Start by reviewing the DB2 client/server environment, comparing the multiple programming interfaces available to DB2 application developers, and understanding when to choose each. Next, walk through the fundamentals of DB2 application development with Embedded SQL, ADO, CLI/ODBC, JDBC, SQLJ, and the Perl DBI. Learn how to create effective stored procedures, and when to use them. Discover how to use DB2 extenders to enhance your application's functionality, adding more effective search features, XML support, multimedia archive management, and more.
Foreword xv
Preface xvii
Introduction to Database Applications for DB2
1(18)
Objectives
2(1)
DB2 UDB Server Instances and Databases
2(6)
DB2 UDB Client Instances
3(1)
DB2 UDB Environment
4(1)
DB2 Node and Database Directory
5(1)
Database Manager Configuration
6(1)
DB2 Profile Registry
7(1)
Environment Variables
7(1)
Local vs. Remote Clients
8(1)
Database Objects
8(4)
Tables
9(1)
Data Types
9(1)
Indexes
10(1)
Schemas
11(1)
Transactions
11(1)
Locks
12(1)
Packages
12(1)
SQL Concepts
12(2)
Querying Data
13(1)
Modifying Data
13(1)
DB2 Application Structure
14(4)
Connecting to a Database
14(1)
Dynamic and Static Statement Execution
15(1)
Statement Life Cycle
15(2)
Committing or Rolling Back Changes
17(1)
Disconnecting from a Database
18(1)
Summary
18(1)
DB2 Programming Roadmap
19(8)
Objectives
19(1)
Administrative API
20(1)
Embedded SQL
20(2)
Static Embedded SQL
21(1)
Dynamic Embedded SQL
21(1)
Driver-based Application Solutions
22(3)
Application Software Layers
23(1)
CLI/ODBC
23(1)
ADO and OLE DB
23(1)
JDBC
24(1)
SQLj
24(1)
Perl Scripts Using the DBI
24(1)
Net. Data
25(1)
DB2 Extenders
25(1)
Summary
25(2)
DB2 Programming Features and Strategies
27(30)
Objectives
28(1)
Data Manipulation Strategies
28(12)
System Catalogs
28(1)
Summary Tables
29(2)
User-Defined Types
31(1)
Common Table Expressions
31(1)
Compound SQL
32(1)
Cursor Types and Scope
33(1)
Prepared Statements
34(1)
Use of Parameter Markers
34(1)
Deferred Prepare
35(1)
Identity Columns
35(1)
Triggers
36(2)
Stored Procedures
38(1)
DB2 Built-In and User-Defined Functions
38(1)
STAR Schema Table/Index Design
39(1)
Concurrency and Transaction Management
40(14)
Unit of Work
40(1)
Database Locking Strategies and Isolation Levels
41(3)
Distributed Unit of Work
44(1)
Stored Procedures
44(2)
SQL Stored Procedures
46(2)
DB2 Stored Procedure Builder
48(6)
Database Packages and Query Performance
54(2)
Summary
56(1)
Embedded SQL Programming
57(48)
Embedded SQL Overview
58(10)
Creating Packages
58(4)
Binding Applications
62(4)
Binding Utilities
66(1)
Blocking
67(1)
Static Embedded SQL
68(22)
Host Variables
68(2)
Connecting to Database
70(1)
Transactions Involving Multiple Databases
71(1)
Connecting from an Application
72(2)
Error Handling---Using and Interpreting the SQLCA
74(3)
Error Handling---Message Retrieval
77(1)
SQLCODE vs. SQLSTATE
78(1)
Program Logic for Error Handling
78(1)
Indicator Variables
78(2)
Data Retrieval Methods
80(3)
Using Cursors
83(6)
Application-Level Locking
89(1)
Searched Updates/Deletes
89(1)
Dynamic Embedded SQL
90(10)
First Look at Dynamic SQL
91(2)
Dynamic SQL Phases
93(1)
Other Concepts
94(1)
Types of Dynamic SQL Statements
95(1)
SQLDA Data Structure
96(1)
SQLVAR Elements
97(1)
Output SQLDA
98(2)
Comparing Dynamic SQL with Static SQL
100(3)
Summary
103(2)
Administrative APIs
105(10)
DB2 APIs
105(6)
Application Migration Considerations
111(1)
Changed APIs and Data Structures
111(1)
Context Management APIs
111(3)
Summary
114(1)
CLI/ODBC and OLE DB Programming
115(40)
Objectives
115(1)
CLI and ODBC Overview
116(3)
Advantages of CLI
116(3)
Setting up the CLI Environment
119(3)
DB2 UDB Installation
119(1)
Database Cataloging
120(1)
CLI Bind Files
120(1)
Configuring CLI
121(1)
Accessing a DB2 Database via ODBC
121(1)
ODBC Development Considerations
122(1)
Basic Program Flow for a CLI Application
122(9)
Initializing Handle Types and Connecting
123(1)
Connecting to One or More Data Sources
124(1)
Disconnecting and Termination
125(1)
Transaction Processing
125(4)
Diagnostics and Error Processing
129(2)
Advanced Programming Features
131(18)
Supported Cursor Types
131(1)
Catalog Functions
132(1)
Executing Statements
133(5)
Retrieving Results with Scrollable Cursors
138(11)
DB2 OLE DB Driver
149(3)
DB2 OLE Automation
150(2)
Installing the OLE DB Driver
152(1)
Summary
152(3)
Java Programming
155(42)
Objectives
155(1)
JDBC Programming
156(25)
DB2 JDBC Driver Versions
157(1)
Changing between DB2 JDBC Driver Versions
158(1)
DB2 JDBC Development Prerequisites
158(1)
DB2 JDBC Applet (or net) Driver
159(1)
DB2 JDBC Application (or app) Driver
160(1)
JDBC Driver Registration
161(1)
Supported Data Types
162(1)
JDBC Interfaces
163(1)
DriverManager
163(1)
Connection
164(1)
Statement
165(1)
ResultSet
166(1)
SQLException
167(1)
Executing Statements
168(1)
Using Prepared Statements
169(1)
Retrieving Result Sets
170(1)
NULL Values
171(1)
Updating Rows in a Result Set
171(1)
Specifying Result Set Type in JDBC 2.0
172(1)
Using Scrollable Result Sets
173(1)
Calling Stored Procedures
174(1)
Batch Execution
175(1)
Large Objects
176(1)
Meta Data
177(1)
Concurrency and Isolation Levels
178(1)
Using DataSource Objects and Connection Pooling
179(2)
Java Naming and Directory Interface Support
181(1)
JDBC Static SQL
181(1)
SQLj Programs
181(11)
Required Packages
184(1)
SQLj Syntax
184(1)
Host Variables
184(1)
Result Set Iterators
185(1)
Positional Iterators
186(1)
Named Iterators
187(1)
Default ConnectionContext
188(1)
User-Defined ConnectionContext Classes
189(1)
Execution Contexts
190(1)
Properties of User-Defined SQLj Classes
191(1)
SQLj Translator
191(1)
DB2 Profile Customizer
192(1)
Java Stored Procedures
192(2)
Setting up an Environment for JDBC 2.0 Stored Procedures
194(1)
Java UDFs
194(1)
Summary
194(3)
Net.Data
197(18)
Objectives
197(1)
Advantages
198(1)
Easy to Use
198(1)
Highly Compatible
198(1)
Easily Integrated
199(1)
Scripting Language
199(5)
Comment Blocks
200(1)
Define Blocks
200(1)
Function Blocks
200(2)
Document Blocks
202(2)
Language Environments
204(8)
Database Access
205(4)
REXX
209(1)
Perl
210(1)
Java
210(2)
Performance
212(1)
Live Connection Manager
212(1)
Cache Manager
213(1)
Summary
213(2)
Perl Programming
215(10)
Objectives
215(1)
Advantages of Perl
215(1)
Setting up the Perl Environment
216(4)
DB2 UDB Installation
216(1)
Database Cataloging
217(1)
CLI Bind Files
217(1)
Configuring CLI
217(1)
Installing Perl
218(1)
Installing the Perl DBI
218(1)
Installing the DBD::DB2 Module
219(1)
Basic Program Flow
220(3)
Initialization
220(1)
Transaction Processing
221(2)
Error Handling
223(1)
Disconnecting and Termination
223(1)
Summary
223(2)
DB2 Extenders
225(18)
Objectives
225(1)
Text Extender
226(7)
Indexes
228(3)
Text Extender UDFs
231(2)
Text Extender APIs
233(1)
Net Search Extender
233(1)
Benefits of Net Search Extender
233(1)
Search Capabilities
234(1)
Search Functions
234(1)
AIV Extenders
234(1)
AIV Extender UDFs
235(1)
XML Extender
235(5)
Mapping XML to a Relational Database
238(1)
XML Columns
239(1)
XML Collections
240(1)
Summary
240(3)
Appendix A DB2 UDB Application Development Test Objectives 243(4)
Appendix B DB2 UDB Application Development Sample Exam 247(18)
Appendix C DB2MALL Database 265(6)
Appendix D Application Troubleshooting 271(8)
D.1 Obtaining an SQL Error
272(1)
D.2 Isolating Error Location
272(1)
D.3 Diagnostic Error Files
272(2)
D.3.1 db2diag.log
273(1)
D.3.2 db2alert.log
273(1)
D.3.3 Dump Files
274(1)
D.3.4 Trap Files
274(1)
D.3.5 jdbcerr.log
274(1)
D.4 Tracing Facilities
274(5)
D.4.1 DB2 Trace (db2trc)
274(1)
D.4.2 CLI Trace
275(2)
D.4.3 JDBC Trace
277(2)
Index 279
Steve Sanyal is a software developer for the DB2 UDB Application Development Team at the IBM Toronto Lab. He is a certified IBM Solutions Expert as a DB2 UDB Application Developer and Administrator. Steve specializes in JDBC, SQLj, and CLI/ODBC on the UNIX and Intel platforms and is the Web sphere focal point on the team. Steve is also leading a project to develop Java and XML-based tools for troubleshooting application performance and problem determination.

David Martineau is a staff software developer at the IBM Toronto Lab, providing technical support for the DB2 UDB Application Development Team. David has provided sample code for DB2 UDB using interfaces such as ADO, CLI, and Net.Data. Prior to 1998, David was a developer within the DB2 UDB Connect group for one year, where he primarily worked on projects to enhance the performance of ODBC. Prior to joining IBM, David was developing database engines since 1994. His work includes developing support for stored procedures, user-defined functions, and 64-bit integer support.

Kevin Gashyna has been working with DB2 UDB and its predecessors since 1997. He is a certified DB2 UDB V7.1 Database Administrator, Application Developer, and Advanced Technical Expert in DRDA. Kevin is currently a staff software developer with the DB2 UDB Extended Enterprise Edition (EEE) Support Team in the IBM Toronto Lab. He has been involved in several aspects of DB2 on the UNIX and Intel platforms, including application development, connectivity, and clustered environments. Kevin also participated in the creation of the DB2 UDB V7.1 Application Development Certification Exam.

Michael Kyprianou has been working with DB2 UDB and its predecessors since 1995. He is an IBM Advanced Technical Expert in DB2 DRDA and is certified in DB2 UDB Database Administration and Application Development. Michael is currently a staff programmer analyst with the DB2 UDB Application Development Team, prior to which he was team lead for the DB2 UDB Connectivity Group for two years. In these roles, Michael provided technical marketing, electronic, and on-site support to customers all over the world. Michael has also assisted at IDUG conferences offering the DB2 UDB Certification Exam.