Embedded SQL Programming Guide

How To Use This Book

This book is organized, by task, into the following chapters:

• Chapter 1. "Getting Started With DB2 Application Development", introduces the overall application development process using DB2 Universal Database. It presents basic information such as the basic programming model and other fundamental concepts to help you begin programming on DB2. In addition, it discusses the main choices you have for coding your applications, and the important application design issues you need to consider prior to coding your applications. This material concludes with information to help you set up a test environment where you can begin to develop your applications.

  Read this information if you are new to programming with DB2, or if you want to review the generalities of DB2 programming.

• Chapter 2. "Writing Embedded Static Programs", discusses the details of coding your DB2 application using embedded static SQL. It contains detailed guidelines and considerations for using static SQL.

  Read this information if you have decided after reading Chapter 1. "Getting Started With DB2 Application Development" that you want to use static SQL in your applications.

• Chapter 3. "Writing Dynamic Programs", discusses the details of coding your DB2 application using dynamic SQL. It contains detailed guidelines and considerations for using dynamic SQL.

  Read this information if you have decided after reading Chapter 1. "Getting Started With DB2 Application Development" that you want to use dynamic SQL in your applications.

• Chapter 4. "Programming Considerations for Concurrency and Performance", discusses topics and programming techniques that you should consider in order to develop efficient DB2 application programs. Topics discussed include: concurrency, locking, row blocking, performance guidelines, the use of the system catalog tables, and more.

  Read this information if you are interested in enhancing the efficiency of your DB2 applications.

• Chapter 5. "Writing Stored Procedures", describes how you can use stored procedures for your database manager applications running in client/server environments.

  Read this information if you are interested in distributed applications for DB2 using stored procedures.

• Chapter 6. "Using the Object-Relational Capabilities", describes how you can use the object-oriented capabilities of DB2. Included are the details of extending 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.

  Read this information if you want to enhance your database application using the object-oriented features of DB2.

• Chapter 7. "Writing User-Defined Functions (UDFs)", describes how you write user-defined functions to extend your DB2 applications. Included are the details of the process of writing a user-defined function, programming considerations related to user-defined functions, and several examples that show you how to exploit this important capability. In addition, this chapter describes user-defined table functions, and OLE (Object Linking and Embedding) automation UDFs.

  Read this information if you want to enhance your database application using the user-defined function capability of DB2.

• Chapter 8. "Using the Active DBMS Capabilities", describes how you can use triggers to make your database applications active relative to traditional database applications. It also shows how you can enforce business rules within your database applications using the above capabilities.

  Read this information if you want to enhance your database application using triggers.

• Chapter 9. "Programming in Complex Environments", describes advanced programming topics such as national language support, dealing with Extended UNIX** Code (EUC) code pages for databases and applications, accessing multiple databases within a unit of work, and multi-threaded applications.

  Read this information if you need to consider any of the above advanced topics in your database application.

• Chapter 10. "Programming Considerations in a Partitioned Environment", describes programming considerations if you are developing applications that run in a partitioned environment.

  Read this information if you are developing database applications that run in such an environment.

• Chapter 11. "Programming in C and C++", discusses host language specific information concerning database manager applications written in C and C++.

• Chapter 12. "Programming in COBOL", discusses host language specific information concerning database manager applications written in COBOL.

• Chapter 13. "Programming in FORTRAN", discusses host language specific information concerning database manager applications written in FORTRAN.

• Chapter 14. "Programming in REXX", discusses host language specific information concerning database manager applications written in REXX.

• Chapter 15. "Programming in Java", discusses host language specific information concerning database manager applications written in Java.

• Appendix A. "Supported SQL Statements (DB2 Universal Database)", lists the SQL statements supported by DB2 Universal Database.

• Appendix B. "Sample Programs and Extra Examples", contains information on supplied example programs in various supported host languages and describes how they work.

• Appendix C. "Programming in a DRDA Environment", describes programming considerations for DB2 Connect if you access DRDA databases in your applications in a distributed environment.

• Appendix D. "Country Code and Code Page Support", lists the languages and code sets supported by DB2 Universal Database servers.

• Appendix E. "Simulating EBCDIC Binary Collation", describes how to collate DB2 character strings according to an EBCDIC, or user-defined, collating sequence.

• Appendix F. "How the DB2 Library Is Structured", shows you where you can get more information for the DB2 Universal Database product.

Highlighting Conventions

This book uses the following conventions:

Italics

Indicates one of the following:

• Introduction of a new term
• Names or values that are supplied by the user
• Reference to another source of information
• General emphasis.

UPPERCASE

Indicates one of the following:

• API names
• Commands
• Database manager data types
• Field names
• Keywords.
• 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.

Bold

Bold text is used to emphasize a point.

Related Publications

The following manuals describe how to develop applications for international use and for specific countries:

Form Number	Book Title
SE09-8001	National Language Design Guide, Volume 1, Designing Enabled Products, Rules and Guidelines
SE09-8002	National Language Design Guide, Volume 2, NLS Reference Manual

The following manual describes how to access different database systems.

Form Number	Book Title
SC26-8416	IBM SQL Reference (Volumes 1 and 2)(1)

(1) This two volume set replaces the Formal Register of Extensions and Differences in SQL, SC26-3316. The IBM SQL Reference provides a list of SQL extensions and incompatibilities among various standards and the IBM family of relational database products (including DB2 Universal Database).

[ DB2 List of Books | Search the DB2 Books ]