This topic highlights numerous changes to the SQL call level interface 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)
New SQLGetInfo and SQLColAttributes options
are added, including: - 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
New supports are added, including: - 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
Note: 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.