Release Notes

Application Development

Partial Table-of-Contents

  • Administrative API Reference
  • 37.1 db2ArchiveLog (new API)
  • db2ArchiveLog
  • 37.2 db2ConvMonStream
  • 37.3 db2DatabasePing (new API)
  • db2DatabasePing - Ping Database
  • 37.4 db2HistData
  • 37.5 db2HistoryOpenScan
  • 37.6 db2XaGetInfo (new API)
  • db2XaGetInfo - Get Information for Resource Manager
  • 37.7 db2XaListIndTrans (new API that supercedes sqlxphqr)
  • db2XaListIndTrans - List Indoubt Transactions
  • 37.8 db2GetSnapshot - Get Snapshot
  • |37.9 Forget Log Record
  • 37.10 sqlaintp - Get Error Message
  • 37.11 sqlbctcq - Close Tablespace Container Query
  • |37.12 sqleseti - Set Client Information
  • 37.13 sqlubkp - Backup Database
  • 37.14 sqlureot - Reorganize Table
  • 37.15 sqlurestore - Restore Database
  • 37.16 Documentation Error Regarding AIX Extended Shared Memory Support (EXTSHM)
  • 37.17 SQLFUPD
  • 37.17.1 locklist
  • 37.18 SQLEDBDESC

  • |Application Building Guide
  • |38.1 Update Available

  • |Application Development Guide
  • |39.1 Update Available
  • |39.2 IBM OLE DB Provider for DB2 UDB

  • CLI Guide and Reference
  • 40.1 Binding Database Utilities Using the Run-Time Client
  • 40.2 Using Static SQL in CLI Applications
  • 40.3 Limitations of JDBC/ODBC/CLI Static Profiling
  • 40.4 ADT Transforms
  • |40.5 Chapter 1. Introduction to CLI
  • |40.5.1 Differences Between DB2 CLI and Embedded SQL
  • 40.6 Chapter 3. Using Advanced Features
  • |40.6.1 Writing Multi-Threaded Applications
  • 40.6.2 Writing a DB2 CLI Unicode Application
  • 40.6.2.1 Unicode Functions
  • 40.6.2.2 New datatypes and Valid Conversions
  • 40.6.2.3 Obsolete Keyword/Patch Value
  • 40.6.2.4 Literals in Unicode Databases
  • 40.6.2.5 New CLI Configuration Keywords
  • |40.6.3 Microsoft Transaction Server (MTS) as Transaction Monitor
  • 40.6.4 Scrollable Cursors
  • 40.6.4.1 Server-side Scrollable Cursor Support for OS/390
  • 40.6.5 Using Compound SQL
  • 40.6.6 Using Stored Procedures
  • 40.6.6.1 Writing a Stored Procedure in CLI
  • 40.6.6.2 CLI Stored Procedures and Autobinding
  • 40.7 Chapter 4. Configuring CLI/ODBC and Running Sample Applications
  • |40.7.1 Configuration Keywords
  • |40.7.1.1 CURRENTFUNCTIONPATH
  • |40.7.1.2 SKIPTRACE
  • 40.8 Chapter 5. DB2 CLI Functions
  • 40.8.1 SQLBindFileToParam - Bind LOB File Reference to LOB Parameter
  • |40.8.2 SQLColAttribute -- Return a Column Attribute
  • |40.8.3 SQLGetInfo - Get General Information
  • |40.8.4 SQLGetLength - Retrieve Length of A String Value
  • 40.8.5 SQLNextResult - Associate Next Result Set with Another Statement Handle
  • 40.8.5.1 Purpose
  • 40.8.5.2 Syntax
  • 40.8.5.3 Function Arguments
  • 40.8.5.4 Usage
  • 40.8.5.5 Return Codes
  • 40.8.5.6 Diagnostics
  • 40.8.5.7 Restrictions
  • 40.8.5.8 References
  • |40.8.6 SQLSetEnvAttr - Set Environment Attribute
  • |40.8.7 SQLSetStmtAttr -- Set Options Related to a Statement
  • |40.9 Appendix C. DB2 CLI and ODBC
  • |40.9.1 ODBC Unicode Applications
  • |40.9.1.1 ODBC Unicode Versus Non-Unicode Applications
  • 40.10 Appendix D. Extended Scalar Functions
  • 40.10.1 Date and Time Functions
  • 40.11 Appendix K. Using the DB2 CLI/ODBC/JDBC Trace Facility

  • |Message Reference
  • |41.1 Update Available
  • |41.2 Message Updates
  • |41.2.1 SQL2554N New Reason Code 12
  • |41.2.2 Additional New Messages and SQLSTATEs

  • SQL Reference
  • |42.1 SQL Reference Update Available
  • |42.2 Enabling the New Functions and Procedures
  • 42.3 MQSeries Information
  • 42.3.1 Scalar Functions
  • |42.3.1.1 MQPUBLISH
  • |42.3.1.2 MQREADCLOB
  • |42.3.1.3 MQRECEIVECLOB
  • |42.3.1.4 MQSEND
  • 42.3.2 Table Functions
  • |42.3.2.1 MQREADALLCLOB
  • |42.3.2.2 MQRECEIVEALLCLOB
  • |42.3.3 CLOB data now supported in MQSeries functions
  • 42.4 Data Type Information
  • 42.4.1 Promotion of Data Types
  • 42.4.2 Casting between Data Types
  • 42.4.3 Assignments and Comparisons
  • 42.4.3.1 String Assignments
  • 42.4.3.2 String Comparisons
  • 42.4.4 Rules for Result Data Types
  • 42.4.4.1 Character and Graphic Strings in a Unicode Database
  • 42.4.5 Rules for String Conversions
  • 42.4.6 Expressions
  • 42.4.6.1 With the Concatenation Operator
  • 42.4.7 Predicates
  • |42.5 Unicode Information
  • |42.5.1 Scalar Functions and Unicode
  • 42.6 Larger Index Keys for Unicode Databases
  • 42.6.1 ALTER TABLE
  • 42.6.2 CREATE INDEX
  • 42.6.3 CREATE TABLE
  • |42.7 Additional Options in the GET DIAGNOSTICS Statement
  • |GET DIAGNOSTICS Statement
  • |42.8 ORDER BY in Subselects
  • |42.8.1 fullselect
  • |42.8.2 subselect
  • |42.8.3 order-by-clause
  • |42.8.4 select-statement
  • |SELECT INTO statement
  • |42.8.5 OLAP Functions (window-order-clause)
  • |42.9 New Input Argument for the GET_ROUTINE_SAR Procedure
  • |42.10 Required Authorization for the SET INTEGRITY Statement

  • Unicode Updates
  • 43.1 Introduction
  • 43.1.1 DB2 Unicode Databases and Applications
  • 43.1.2 Documentation Updates

    • [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]