Release Notes

Application Development

Partial Table-of-Contents

  • Administrative API Reference
  • 38.1 db2ArchiveLog (new API)
  • db2ArchiveLog
  • 38.2 db2ConvMonStream
  • 38.3 db2DatabasePing (new API)
  • db2DatabasePing - Ping Database
  • 38.4 db2HistData
  • 38.5 db2HistoryOpenScan
  • 38.6 db2Runstats
  • 38.7 db2GetSnapshot - Get Snapshot
  • 38.8 db2XaGetInfo (new API)
  • db2XaGetInfo - Get Information for Resource Manager
  • 38.9 db2XaListIndTrans (new API that supercedes sqlxphqr)
  • db2XaListIndTrans - List Indoubt Transactions
  • 38.10 Forget Log Record
  • 38.11 sqlaintp - Get Error Message
  • 38.12 sqlbctcq - Close Tablespace Container Query
  • 38.13 sqleseti - Set Client Information
  • 38.14 sqlubkp - Backup Database
  • 38.15 sqlureot - Reorganize Table
  • 38.16 sqlurestore - Restore Database
  • 38.17 Documentation Error Regarding AIX Extended Shared Memory Support (EXTSHM)
  • 38.18 SQLFUPD
  • 38.18.1 locklist
  • 38.19 SQLEDBDESC

  • Application Building Guide
  • 39.1 Update Available
  • 39.2 Linux on S/390 and zSeries Support
  • 39.3 Linux Rexx Support
  • 39.4 Additional Notes for Distributing Compiled SQL Procedures

  • Application Development Guide
  • 40.1 Update Available
  • 40.2 Precaution for registering C/C++ routines (UDFs, stored procedures, or methods) on Windows
  • 40.3 Correction to "Debugging Stored Procedures in Java"
  • 40.4 New Requirements for executeQuery and executeUpdate
  • 40.5 JDBC Driver Support for Additional Methods
  • 40.6 JDBC and 64-bit systems
  • 40.7 IBM OLE DB Provider for DB2 UDB

  • CLI Guide and Reference
  • 41.1 Binding Database Utilities Using the Run-Time Client
  • 41.2 Using Static SQL in CLI Applications
  • 41.3 Limitations of JDBC/ODBC/CLI Static Profiling
  • 41.4 ADT Transforms
  • 41.5 Chapter 1. Introduction to CLI
  • 41.5.1 Differences Between DB2 CLI and Embedded SQL
  • 41.6 Chapter 3. Using Advanced Features
  • 41.6.1 Writing Multi-Threaded Applications
  • 41.6.2 Writing a DB2 CLI Unicode Application
  • 41.6.2.1 Unicode Functions
  • 41.6.2.2 New datatypes and Valid Conversions
  • 41.6.2.3 Obsolete Keyword/Patch Value
  • 41.6.2.4 Literals in Unicode Databases
  • 41.6.2.5 New CLI Configuration Keywords
  • 41.6.3 Microsoft Transaction Server (MTS) as Transaction Monitor
  • 41.6.4 Scrollable Cursors
  • 41.6.4.1 Server-side Scrollable Cursor Support for OS/390
  • 41.6.5 Using Compound SQL
  • 41.6.6 Using Stored Procedures
  • 41.6.6.1 Privileges for building and debugging SQL and Java stored procedures
  • 41.6.6.2 Writing a Stored Procedure in CLI
  • 41.6.6.3 CLI Stored Procedures and Autobinding
  • 41.7 Chapter 4. Configuring CLI/ODBC and Running Sample Applications
  • 41.7.1 Configuration Keywords
  • 41.7.1.1 CURRENTFUNCTIONPATH
  • 41.7.1.2 SKIPTRACE
  • 41.8 Chapter 5. DB2 CLI Functions
  • 41.8.1 SQLBindFileToParam - Bind LOB File Reference to LOB Parameter
  • 41.8.2 SQLColAttribute -- Return a Column Attribute
  • 41.8.3 SQLGetData - Get Data From a Column
  • 41.8.4 SQLGetInfo - Get General Information
  • 41.8.5 SQLGetLength - Retrieve Length of A String Value
  • 41.8.6 SQLNextResult - Associate Next Result Set with Another Statement Handle
  • 41.8.6.1 Purpose
  • 41.8.6.2 Syntax
  • 41.8.6.3 Function Arguments
  • 41.8.6.4 Usage
  • 41.8.6.5 Return Codes
  • 41.8.6.6 Diagnostics
  • 41.8.6.7 Restrictions
  • 41.8.6.8 References
  • 41.8.7 SQLSetEnvAttr - Set Environment Attribute
  • 41.8.8 SQLSetStmtAttr -- Set Options Related to a Statement
  • 41.9 Appendix C. DB2 CLI and ODBC
  • 41.9.1 ODBC Unicode Applications
  • 41.9.1.1 ODBC Unicode Versus Non-Unicode Applications
  • 41.10 Appendix D. Extended Scalar Functions
  • 41.10.1 Date and Time Functions
  • 41.11 Appendix K. Using the DB2 CLI/ODBC/JDBC Trace Facility

  • Message Reference
  • 42.1 Update Available
  • 42.2 Message Updates
  • 42.3 Reading Message Text Online

  • SQL Reference
  • 43.1 SQL Reference Update Available
  • 43.2 Enabling the New Functions and Procedures
  • 43.3 SET SERVER OPTION - Documentation Error
  • 43.4 Correction to CREATE TABLESPACE Container-clause, and Container-string Information
  • 43.5 Correction to CREATE TABLESPACE EXTENTSIZE information
  • 43.6 GRANT (Table, View, or Nickname Privileges) - Documentation Error
  • 43.7 MQSeries Information
  • 43.7.1 Scalar Functions
  • 43.7.1.1 MQPUBLISH
  • 43.7.1.2 MQREADCLOB
  • 43.7.1.3 MQRECEIVECLOB
  • 43.7.1.4 MQSEND
  • 43.7.2 Table Functions
  • 43.7.2.1 MQREADALLCLOB
  • 43.7.2.2 MQRECEIVEALLCLOB
  • 43.7.3 CLOB data now supported in MQSeries functions
  • 43.8 Data Type Information
  • 43.8.1 Promotion of Data Types
  • 43.8.2 Casting between Data Types
  • 43.8.3 Assignments and Comparisons
  • 43.8.3.1 String Assignments
  • 43.8.3.2 String Comparisons
  • 43.8.4 Rules for Result Data Types
  • 43.8.4.1 Character and Graphic Strings in a Unicode Database
  • 43.8.5 Rules for String Conversions
  • 43.8.6 Expressions
  • 43.8.6.1 With the Concatenation Operator
  • 43.8.7 Predicates
  • 43.9 Unicode Information
  • 43.9.1 Scalar Functions and Unicode
  • 43.10 GRAPHIC type and DATE/TIME/TIMESTAMP compatibility
  • 43.10.1 String representations of datetime values
  • 43.10.1.1 Date strings, time strings, and datetime strings
  • 43.10.2 Casting between data types
  • 43.10.3 Assignments and comparisons
  • 43.10.4 Datetime assignments
  • 43.10.5 DATE
  • 43.10.6 GRAPHIC
  • 43.10.7 TIME
  • 43.10.8 TIMESTAMP
  • 43.10.9 VARGRAPHIC
  • 43.11 Larger Index Keys for Unicode Databases
  • 43.11.1 ALTER TABLE
  • 43.11.2 CREATE INDEX
  • 43.11.3 CREATE TABLE
  • 43.12 ALLOCATE CURSOR Statement Notes Section Incorrect
  • 43.13 Additional Options in the GET DIAGNOSTICS Statement
  • GET DIAGNOSTICS Statement
  • 43.14 ORDER BY in Subselects
  • 43.14.1 fullselect
  • 43.14.2 subselect
  • 43.14.3 order-by-clause
  • 43.14.4 select-statement
  • SELECT INTO statement
  • 43.14.5 OLAP Functions (window-order-clause)

  • New Input Argument for the GET_ROUTINE_SAR Procedure

  • Required Authorization for the SET INTEGRITY Statement

  • Appendix N. Exception Tables

  • Unicode Updates
  • 47.1 Introduction
  • 47.1.1 DB2 Unicode Databases and Applications
  • 47.1.2 Documentation Updates

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