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.
- "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.
- "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 develop stored procedures and the client
applications that call 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.
- "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)" describes how to write your own extensions to SQL. It
explains how to use UDFs to express the behavior of your data
objects.
- "User-defined Distinct Types (UDTs)" describes how to create and use your own data types in
applications. It explains how to use UDTs as a foundation for
object-oriented extensions to the built-in data types.
- "Writing User-Defined Functions (UDFs)" 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 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:
- API names
- Abbreviations
- Database manager data types
- Function names
- 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
- 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 | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]