Application Development Guide
This book is organized, by task, into the following parts, chapters, and
appendices:
- "DB2 Application Development Concepts" contains information you need to use this book and an overview
of the methods you can use to develop applications for DB2 Universal
Database.
- "Getting Started with DB2 Application Development" describes the structure of this book and the conventions used in
it.
- "Coding a DB2 Application" introduces the overall application development process using
DB2. It discusses and compares the important application design issues
you need to consider prior to coding your applications. This chapter
concludes with information to help you set up a test environment where you can
begin to develop your applications.
- "Embedding SQL in Applications" describes how to embed static and dynamic SQL in your
applications. This information includes a description of the utilities
that you can use to help create your embedded SQL applications.
- "Embedding SQL Statements in a Host Language" discusses the process of creating a DB2 application by embedding
SQL in host languages such as C/C++, Java, and COBOL.
It contains an overview of the DB2 precompiler, compiling and linking the
application, and binding the embedded SQL statements to the
database.
- "Writing Static SQL Programs" discusses the details of coding your DB2 embedded SQL
application using static SQL statements. It contains detailed
guidelines and considerations for using static SQL.
- "Writing Dynamic SQL Programs" discusses the details of coding your DB2 embedded SQL
application using dynamic SQL statements. It contains detailed
guidelines and considerations for using dynamic SQL.
- "Common DB2 Application Techniques" discusses DB2 features that help you with common application
development problems. These features include the ability to
automatically create unique row identifiers, to create columns that are
dynamically derived from an expression, and to create and use declared
temporary tables.
- "Stored Procedures" discusses how to use stored procedures to improve the
performance of database applications that run in client/server
environments.
- "Stored Procedures" describes how to write stored procedures and the client
applications that call stored procedures using host languages.
- "Writing SQL Procedures" describes how to write stored procedures in SQL by issuing a
CREATE PROCEDURE statement. SQL procedures encode their procedural
logic using SQL in the body of the CREATE PROCEDURE statement.
- "IBM DB2 Stored Procedure Builder" describes the IBM DB2 Stored Procedure Builder, a graphical
application that supports the rapid development of stored procedures for
DB2. Stored Procedure Builder helps you create both SQL and Java stored
procedures.
- "Object-Relational Programming" describes how to use the object-relational support provided by
DB2. This information includes an introduction to and detailed
instructions on how to use large objects, user-defined functions,
user-defined distinct types, and triggers.
- "Using the Object-Relational Capabilities" introduces the object-oriented capabilities of DB2. It
explains how to extend your traditional application to one that takes
advantage of DB2 capabilities such as large objects, user-defined functions,
and user-defined distinct types in an object-oriented context.
- "User-defined Distinct Types" describes how to create and use your own data types in
applications. It explains how to use distinct types as a foundation for
object-oriented extensions to the built-in data types.
- "Working with Complex Objects: User-Defined Structured Types" describes how to create and use structured types in
applications. It explains how to model objects as hierarchies of
structured types, access instances of structured types as rows or columns in
tables, and bind structured types into and out of your
applications.
- "Using Large Objects (LOBs)" describes how to define and use data types that can store data
objects as binary or text strings of up to two gigabytes in size. It
also explains how to efficiently use LOBs in a networked environment.
- "User-Defined Functions (UDFs) and Methods" describes how to write your own extensions to SQL. It
explains how to use UDFs to express the behavior of your data objects.
- "Writing User-Defined Functions (UDFs) and Methods" describes how to write user-defined functions that extend your
DB2 applications. Topics include the details of writing a user-defined
function, programming considerations for user-defined functions, and several
examples that show you how to exploit this important capability. In
addition, this chapter describes user-defined table functions, OLE DB table
functions, and OLE automation UDFs.
- "Using Triggers in an Active DBMS" describes how to use triggers to encapsulate and enforce
business rules within all of your database applications.
- "DB2 Programming Considerations" contains information on special application development
considerations.
- "Language Considerations" contains specific information about the programming languages
that DB2 supports.
- "Programming in C and C++" discusses host language specific information concerning database
applications written in C and C++.
- "Programming in Java" discusses host language specific information concerning database
applications written in Java using JDBC or SQLJ.
- "Programming in Perl" discusses host language specific information
concerning database applications written in Perl using the
DBD::DB2 database driver for the Perl Database Interface (DBI)
Module.
- "Programming in COBOL" discusses host language specific information concerning database
applications written in COBOL.
- "Programming in FORTRAN" discusses host language specific information concerning database
applications written in FORTRAN.
- "Programming in REXX" discusses host language specific information concerning database
applications written in REXX.
- The Appendices contain supplemental information to which you may need to
refer when developing DB2 applications.
This book uses the following conventions:
- Directories and Paths
- This book uses the UNIX convention for delimiting directories, for
example: sqllib/samples/java. You can convert these paths to
Windows 32-bit operating system and OS/2 paths by changing the / to a
\ and prepending the appropriate installation drive and
directory.
- Italics
- Indicates one of the following:
- Introduction of a new term
- Variable names or values that are supplied by the user
- Reference to another source of information, for example, a book or CD-ROM
- General emphasis
- UPPERCASE
- Indicates one of the following:
- Abbreviations
- Database manager data types
- SQL statements
- Example
- Indicates one of the following:
- Coding examples and code fragments
- Examples of output, similar to what is displayed by the system
- Examples of specific data values
- Examples of system messages
- File and directory names
- Information that you are instructed to type
- Java method names
- Function names
- API names
- Bold
- Bold text emphasizes a point.
The following manuals describe how to develop applications for
international use and for specific countries:
| Form Number
| Book Title
|
| SE09-8001-03
| National Language Design Guide, Volume 1
|
| SE09-8002-03
| NLS Reference Manual, Release 4
|
[ Top of Page | Previous Page | Next Page ]