What's new for V5R4
This topic highlights the changes made to this topic collection for V5R4.
The limit for the total number of concurrently allocated handles is expanded from 80 000 to 160 000. New environment, connection and statement attributes are added, including:
- Cursor sensitivity statement attribute
- New cursor type statement attribute (SQL_CURSOR_STATIC)
- New query optimizer connection attribute(SQL_ATTR_QUERY_OPTIMIZE_GOAL)
- User name for a connection from SQLGetInfo(): SQL_USER_NAME
- Database name for a connection from SQLGetInfo(): SQL_DATABASE_NAME
- Display the size needed to display a data type from SQLColAttributes(): SQL_DESC_DISPLAY_SIZE
- XA support through the CLI connection attributes SQL_ATTR_TXN_EXTERNAL and SQL_ATTR_TXN_INFO
- Support for array (block) fetching and column-wise binding in the SQLFetchScroll()
- 2-megabyte SQL statement support through the CLI interface
This is not a complete list of the new supports. The following APIs are changed in this release:
- SQLConnect - Connect to a data source
- SQLFetchScroll - Fetch from a scrollable cursor
- SQLGetConnectOption - Return current setting of a connect option
- SQLGetDescField - Get descriptor field
- SQLGetDescRec - Get descriptor record
- SQLGetInfo - Get general information
- SQLGetStmtOption - Return current setting of a statement option
- SQLGetTypeInfo - Get data type information
- SQLSetConnectAttr - Set a connection attribute
- SQLSetConnectOption - Set connection option
- SQLSetEnvAttr - Set environment attribute
- SQLSetStmtAttr - Set a statement attribute
- SQLSetStmtOption - Set statement option
How to see what's new or changed
To help you see where technical changes have been made, this information uses:
- The
image to mark where new or changed information begins.
- The
image to mark where new or changed information ends.
To find other information about what's new or changed this release, see the Memo to users.