Call Level Interface Guide and Reference

How this Book is Structured

This book is divided into the following chapters:

• Chapter 1, Introduction to CLI, introduces DB2 CLI and discusses the background of the interface and its relation to embedded SQL.
• Chapter 2, Writing a DB2 CLI Application, provides an overview of a typical DB2 CLI application. This chapter discusses the basic tasks or steps within a simple DB2 CLI application. General concepts are introduced as well as the basic functions and the interaction between them.
• Chapter 3, Using Advanced Features, provides an overview of more advanced tasks and the functions used to perform them.
• Chapter 4, Configuring CLI/ODBC and Running Sample Applications, contains information for setting up the necessary environment to compile and run DB2 CLI applications. Sample applications are provided in order to verify your environment, and to provide templates to help you develop your own applications. A listing of the CLI/ODBC configuration keywords and their meanings is also included in this chapter.
• Chapter 5, DB2 CLI Functions, is a reference for the functions that make up DB2 CLI.
• Appendixes:
  • Appendix A, Programming Hints and Tips, provides some common hints and tips for improving performance and/or portability of DB2 CLI applications.
  • Appendix B, Migrating Applications, summarizes what has changed since the last release, and any incompatibilities and necessary steps required for migrating existing applications.
  • Appendix C, DB2 CLI and ODBC, discusses the differences between ODBC and DB2 CLI.
  • Appendix D, Extended Scalar Functions, describes the scalar functions that can be accessed as DB2 functions, or using ODBC vendor escape clauses.
  • Appendix E, SQLSTATE Cross Reference, contains an SQLSTATE table that lists the functions that may generate each SQLSTATE. (Each function description in Chapter 5, DB2 CLI Functions lists the possible SQLSTATEs for each function.)
  • Appendix F, Data Conversion, contains information about SQL and C data types, and conversion between them.
  • Appendix G, Catalog Views for Stored Procedures, contains a description of the catalog tables used to store information about stored procedures and their attributes.
  • Appendix H, Pseudo Catalog Table for Stored Procedure Registration, describes how to create and maintain the DB2CLI.PROCEDURES pseduo-catalog table.
  • Appendix I, Supported SQL Statements, contains a list of the SQL statements supported by DB2 Universal Database, and the subset of SQL supported by DB2 CLI.
  • Appendix J, CLI Sample Code, lists the complete source for some extensive examples.
  • Appendix K, Using the DB2 CLI/ODBC/JDBC Trace Facility, contains information about the trace file format, tracing asynchronous applications, and related topics.