Call Level Interface Guide and Reference

Changes from version 2.1.0 to 2.1.1

Stored Procedures that return multi-row result sets

Previous versions of DB2 CLI did not support multi-row result sets. Version 2.1.1 provides the ability to retrieve one or more result sets from a stored procedure call by leaving one or more cursors open, each associated with a query, when the stored procedure exists.

Data Conversion and Values for SQLGetInfo

DB2 CLI version 2.1.1 now supports a convert function defined by ODBC using vendor escape clauses. This function will convert between chars (CHAR, VARCHAR, LONG VARCHAR and CLOB), and DOUBLE (or FLOAT).

DB2 CLI version 2.1.0 returned zero for all SQL_CONVERT fInfoTypes using SQLGetInfo(). Now that version 2.1.1 supports conversion, SQLGetInfo() returns a set of bitmasks for the fInfoTypes that start with SQL_CONVERT_ (SQL_CONVERT_INTEGER for example) which can be used for comparison with the bitmasks that start with SQL_CVT_ (SQL_CVT_CHAR for example).

In addition to the CONVERT function, DB2 CLI version 2.1.1 provides two new date and time functions that can be accessed using the ODBC vendor escape clause convention:

JULIAN_DAY(day_expr)

Returns an integer corresponding to the number of days in date_exp relative to January 1, 4712 B.C.

SECONDS_SINCE_MIDNIGHT(time_expr)

Returns an integer corresponding to the number of seconds in time_expr relative to midnight.