Application Building Guide
Preface
The DB2 Developer's Edition
Installation Information
DB2 Application Development Books
DB2 Programming Interfaces
Using Embedded SQL Statements
Using the DB2 Call Level Interface
DB2 CLI Versus Embedded Dynamic SQL
Using Java Database Connectivity (JDBC)
Using DB2 APIs
Using ActiveX Data Objects (ADO) and Remote Data Objects (RDO)
Using IBM, Third-Party, and ODBC End-User Tools
DB2 Features
Constraints
User-Defined Types (UDTs) and Large Objects (LOBs)
Stored Procedures
User-Defined Functions (UDFs)
OLE Automation UDFs and Stored Procedures
Triggers
DB2 Universal Database Tools
Introduction
Who Should Use This Book
How To Use This Book
Highlighting Conventions
About the DB2 Application Development Client
Supported Servers
Supported Software by Platform
AIX
HP-UX
Linux
OS/2
PTX
Silicon Graphics IRIX
Solaris
Windows 32-bit Operating Systems
Sample Programs
DB2 API Non-Embedded SQL Samples
DB2 API Embedded SQL Samples
Embedded SQL Samples With No DB2 APIs
User-Defined Function Samples
DB2 Call Level Interface Samples
Java Samples
SQL Procedure Samples
ADO, RDO, and MTS Samples
Object Linking and Embedding Samples
Command Line Processor Samples
Log Management User Exit Samples
Setup
Setting the OS/2 Environment
Setting the UNIX Environment
Setting the Windows 32-bit Operating Systems Environment
Enabling Communications on the Server
Windows NT and Windows 2000
Creating, Cataloging, and Binding the Sample Database
Creating
Cataloging
Binding
Where to Go Next
General Information for Building DB2 Applications
Build Files, Makefiles, and Error-checking Utilities
Build Files
Makefiles
Error-checking Utilities
Java Applets and Applications
DB2 API Applications
DB2 Call Level Interface (CLI) Applications
Embedded SQL Applications
Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
C Applications
C++ Applications
C++ Considerations for UDFs and Stored Procedures
COBOL Applications
REXX Applications
Building Java Applets and Applications
Setting the Environment
AIX
HP-UX
Linux
OS/2
PTX
Silicon Graphics IRIX
Solaris
Windows 32-bit Operating Systems
Java Sample Programs
JDBC Programs
Applets
Applications
Stored Procedures
SQLJ Programs
Applets
Applications
Stored Procedures
User-Defined Functions (UDFs)
General Points for DB2 Java Applets
Building SQL Procedures
Setting the SQL Procedures Environment
Creating SQL Procedures
Calling SQL Procedures
Using the CALL Command
OS/2 DB2 CLI Client Applications
OS/2 Embedded SQL Client Applications
UNIX DB2 CLI Client Applications
UNIX Embedded SQL Client Applications
Windows DB2 CLI Client Applications
Windows Embedded SQL Client Applications
Building AIX Applications
Important Considerations
Installing and Running IBM and Micro Focus COBOL
Entry Points for Stored Procedures and UDFs
Stored Procedures and the CALL Statement
UDFs and the CREATE FUNCTION Statement
IBM C
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
IBM C Set++
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
VisualAge C++ Version 4.0
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API Applications
Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
IBM COBOL Set for AIX
Using the Compiler
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
Micro Focus COBOL
Using the Compiler
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
REXX
Building HP-UX Applications
HP-UX C
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
HP-UX C++
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
Micro Focus COBOL
Using the Compiler
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
Building Linux Applications
Linux C
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
Linux C++
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
Building OS/2 Applications
IBM VisualAge C++ for OS/2 Version 3
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
IBM VisualAge C++ for OS/2 Version 4.0
IBM VisualAge COBOL for OS/2
Using the Compiler
Embedded SQL Applications
Embedded SQL Stored Procedures
Micro Focus COBOL
Using the Compiler
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
REXX
Building PTX Applications
ptx/C
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
ptx/C++
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
Building Silicon Graphics IRIX Applications
MIPSpro C
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Client Applications for Stored Procedures
DB2 CLI Client Applications for UDFs
DB2 API and Embedded SQL Applications
Multi-threaded Applications
MIPSpro C++
DB2 API and Embedded SQL Applications
Multi-threaded Applications
Building Solaris Applications
SPARCompiler C
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
SPARCompiler C++
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
Multi-threaded Applications
Micro Focus COBOL
Using the Compiler
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
Building Applications for Windows 32-bit Operating Systems
Microsoft Visual Basic
ActiveX Data Objects (ADO)
Remote Data Objects (RDO)
Object Linking and Embedding (OLE) Automation
Microsoft Visual C++
ActiveX Data Objects (ADO)
Object Linking and Embedding (OLE) Automation
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
IBM VisualAge C++ Version 3.5
DB2 CLI Applications
DB2 CLI Applications with DB2 APIs
DB2 CLI Stored Procedures
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
User-Defined Functions (UDFs)
IBM VisualAge C++ Version 4.0
IBM VisualAge COBOL
Using the Compiler
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
Micro Focus COBOL
Using the Compiler
DB2 API and Embedded SQL Applications
Embedded SQL Stored Procedures
Object REXX
Appendix A. About Database Manager Instances
Appendix B. Migrating Your Applications
Questions
Conditions
Other Migration Considerations
Appendix C. Problem Determination
Appendix D. Using the DB2 Library
DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online
Appendix E. Notices
Trademarks
Appendix F. Contacting IBM
Product Information
Index