DB2 Universal Database in Application Development Environments
486 pages, parution le 01/07/2000
Résumé
- A comprehensive guide to developing applications that use DB2 UDB
- Leveraging Visual Studio in DB2 UDB development: RDO, ADO, OLE DB, and stored procedures
- Application development for DB2 UDB using MTS and IIS
- The complete guide to application development with IBM's world-class DB2 Universal Database and Microsoft's Visual Studio development tools
- Leverage the power of the ActiveX Data Objects (ADO) programming model
- Create high-performance distributed and Web-centered database applications
IBM's DB2 Universal Database Version 7.1 is the perfect enterprise database for Windows applications utilizing Microsoft's Distributed interNet Applications (DNA) architecture ? and Windows 2000/NT is the fastest growing platform for DB2 development. Now, there's a complete, authoritative guide to enterprise development with DB2 UDB 7.x and Microsoft's Visual Studio 6.0: DB2 Universal Database in Application Development Environments!
In this book, a team of IBM DB2 experts cover every key concept and technology DB2 and Visual Studio developers need to master in order to build robust, high-performance DB2 database applications. Compare DB2's key application programming interfaces, including embedded SQL, DB2 Call Level Interface, ODBC, JDBC, SQLJ, native DB2 UDB APIs, and Microsoft's Data Objects ? DAO, RDO, and ADO.
Discover how to incorporate DB2's powerful server-side features into your application designs ? including constraints, user-defined distinct types, large objects, user-defined functions, and stored procedures. Next, using both Visual Basic and Visual C++, leverage the power of DB2 with Microsoft's ActiveX Data Objects (ADO) programming model. Coverage includes:
- DB2 transaction processing using Microsoft Transaction Server (MTS)
- Using Active Server Pages (ASP) to build Web database applications for Microsoft's Internet Information Server
- Tuning application performance: refining SELECT statements, managing concurrency, temporary tables, partitioning, and other key techniques
- Database security considerations
No matter what kind of enterprise database applications you're building, IBM's DB2 UDB and Microsoft's Visual Studio are an outstanding combination ? and this book is all you need to leverage them both!
Contents
1. Overview.
DB2 Universal Database.
Scalable Database. Storing Universal Data. DB2 UDB
Products. DB2 UDB Clients. DB2 UDB GUI Tools. Microsoft
Universal Data Access and DB2 UDB. OLE DB. ActiveX Data
Objects (ADO). Universal Access of DB2 UDB. Microsoft
Visual Studio. Add-In Tools. Using Microsoft
Technology.
2. Set Up Application Development Environment.
Installing the DB2 UDB
Product. Installing on Windows NT. Creating the Sample
Database. Using First Steps. Microsoft Programming Tools.
Microsoft Data Access Components. Setting Up Connections.
Automated Configuration Using Discovery. DB2 Discovery.
Configuring DB2 Clients. Modeling Your Production Database.
Summary.
3. Introducing Programming Interfaces.
DB2 UDB Application
Overview. Embedded SQL. Static SQL. Dynamic SQL. Call Level
Interface and ODBC. A DB2 UDB CLI Application. Java
Interfaces (JDBC and SQLJ). JDBC Application. A Sample JDBC
Application. To Build the Application. Running the
Application. SQLJ Applications. Compiling and Running SQLJ
Programs. Native DB2 UDB APIs. Microsoft Data Objects (DAO,
RDO, ADO). Development of Visual Basic Data Access Methods.
Structure of Visual Basic Data Access Methods. Data Access
Objects. Remote Data Objects. ActiveX Data Objects. DAO,
RDO, ADO Summary.
4. DB2 Server-Side Features.
Constraints. Unique
Constraints. Referential Constraint. Table-Check
Constraints. User-defined Distinct Types (UDTs). Large
Objects (LOBs). Character Large Objects (CLOB). Double-byte
Character Large Objects (DBCLOB). Binary Large Object
(BLOB). Manipulating Large Objects. User-Defined Functions
(UDFs). Defining UDFs. Source Functions. SQL Functions.
External Scalar Functions. External Table Functions. OLE DB
External Table Functions. Performance Tips for UDFs.
Triggers. Stored Procedures. Building Stored Procedures.
SQL Procedures. Nested Stored Procedures. Keep Stored
Procedure Processes. Stored Procedure Builder.
5. Building Applications Using Visual Basic.
Data Entry Forms. ODBC
Data Source for Accessing Sample Database. Opening the
Visual Basic Project. Setting Project References. Creating
Forms Using the Data Form Wizard. Visual Data Manager
Add-In. OpenSchema Recordsets. BookSale Schema. Run
Booksales Sample Application on DB2 UDB. DB2 UDB Sample
Application. Common Procedures in Main Display Forms.
RecSet Module. Logon Form. Menu Form. Table Access Form.
Department Information. Employee Information. Employee
Photo. Employee Resume. Employee Activities. Projects by
Employee. Calling DB2 UDB Stored Procedures. Calling a
Stored Procedure Returning a Recordset. Using Commitment
Control.
6. Building Applications Using Visual C++.
Visual C++ Applications
with ADO. GetRows Sample. VarCHAR Sample. Building
Applications Using DB2 UDB Add-Ins. Activating DB2 UDB
Add-Ins. Developing Stored Procedures Using Add-Ins.
7. Using Microsoft Transaction Server.
Benefits of Microsoft
Transaction Server. Transaction Processing Concepts. MTS
Architecture. MTS and the Supporting Environment. MTS
Concepts and Processes. Activities. Contexts. Server
Process. Automatic Transactions. Just-In-Time Activation.
Creating MTS Components. Requirements for MTS Components.
Adding Transactional Support. Handling Errors. Creating
Efficient Objects. Using MTS Explorer. Creating Packages.
Setting Package Properties. Adding Components to a Package.
Component Locations and Versioning. Setting Component
Properties. Security Considerations. Declarative Security:
Roles and Identities. Setting Package Security. Creating
and Assigning Security Roles. Setting package identity.
Getting DB2 UDB and MTS to Work Together. Software
Prerequisites. Installation and Configuration. Sample
Program - Using ADO with an MTS Component. Steps to Run the
Sample Application. How MTS Handles DCOM. More About Client
and Server Projects.
8. Application Development on IIS.
Creating ASP Applications.
Starting-Point Directory. Global Data. Creating Server
Script. Coding Active Server Pages. ASP Processing
Directives. Handling Run Time Errors. ASP Built-In Objects.
The Request Object. The Response Object. The Application
Object. The Session Object. Using ActiveX Data Objects.
Connecting to the Database. Creating a Recordset Object.
Security Considerations in ASP. Web Application Security.
Setting IIS Permissions. Allowing Anonymous Logon. Sample
Web Application Using ASP. General Procedure for Installing
Web Applications. Creating a Web Application: Microsoft
Visual Interdev 6.0.
9. Tuning Application Performance.
Using SELECT Statements.
Specify Only Needed Columns in the Select List. Limit the
Number of Rows by Using Predicates. Specify the OPTIMIZE
FOR n ROWS Clause. Specify the FETCH FIRST n ROWS ONLY
Clause. Specify the FOR FETCH ONLY Clause. Avoid Data Type
Conversions. Concurrency. Isolation Levels. LOCK TABLE
Statement. LOCKSIZE Parameter of ALTER TABLE Statement.
Declared Temporary Table. Defining a Declared Temporary
Table. Create Table with NOT LOGGED INITIALLY Option.
Convert ODBC into Static SQL. Considerations in a
Partitioned Environment. Specify FOR FETCH ONLY. OLTP
Applications in a Partitioned Environment. CLI/ODBC Trace
Facility. Getting Started. CLI Trace File Contents.
Analysis Objectives. Analyzing the Trace and Finding the
Problem. Fixing the Performance Problem.
Appendix A: Supported Statements for SQL Procedures.
Appendix B: Example DB2 UDB Source Code.
Appendix C: Related Publications.
Index.
L'auteur - Collectif d'auteurs
Autres livres de Collectif d'auteurs
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Prentice Hall |
| Auteur(s) | Collectif d'auteurs |
| Parution | 01/07/2000 |
| Nb. de pages | 486 |
| Format | 17,8 x 23,3 |
| Couverture | Broché |
| Poids | 975g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780130869876 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
