Open Client 15.7 and Open Server 15.7 Features

Open Client and Open Server version 15.7 introduced new features, such as support for large object (LOB) locators, In-row and off-row LOB, and many others.

Large Object Locator Support
A LOB locator contains a logical pointer to LOB data in Adaptive Server rather than the data itself, thereby reducing the amount of data that passes through the network between Adaptive Server and its clients.
In-row and off-row LOB Support
Bulk-Library version 15.7 supports in-row storage of text, image, and unitext large object (LOB) columns in Adaptive Server.
Bulk-Library Select into Logging
To process a select into existing table statement that inserts rows into a proxy table, Adaptive Server uses the Bulk-Library to generate a bulk-copy operation.
Bulk-Library and bcp Handling of Nonmaterialized Columns
Bulk-Library has been enhanced to handle nonmaterialized columns in Adaptive Server 15.7.
Support for Preserving Trailing Zeros
Open Client and Open Server version 15.7 support the disable varbinary truncation configuration parameter introduced in Adaptive Server 15.7. This parameter specifies whether Adaptive Server preserves or truncates trailing zeros from varbinary and binary null data.
New DB-Library Overflow Errors
Errors occur related to DB-Library overflow.
New Nameless Application Configuration Settings Handling
You can now set whether the ocs.cfg runtime configuration file is parsed for application-specific settings for nameless applications (CS_APPNAME is not explicitly set by the application) and whether any settings found are applied to the application.
TCP Socket Buffer Size Configuration
You can set the size of TCP input and output buffers using the Open Client and Open Server context/connection and server properties.
isql64 and bcp64 for all 64-bit Products
64-bit versions of isql and bcp (isql64 and bcp64) are now available on all the UNIX and Windows platforms that Open Client and Open Server support.
Support for Expanded Variable-length Rows
In Adaptive Server 15.7, the maximum offset of a variable-length column for a data-only-locked (DOL) row has been expanded to 32767 bytes, which allows an Adaptive Server configured with a logical-page size greater than 8K to support wide, variable-length, DOL rows.
Row Format Caching
Open Client 15.7 supports caching row format information, which allows client applications to request data servers to not send the row format information each time a dynamic SQL statement is invoked. Row format caching reduces network traffic between the data server and client applications, thereby improving system performance.
Support for Releasing Locks at Cursor Close
Open Client 15.7, Open Server 15.7, and the Embedded SQL C and COBOL 15.7 processors support the release_locks_on_close cursor option introduced in Adaptive Server 15.7.
Large Objects as Stored Procedure Parameters
Open Client and Open Server 15.7 support using text, unitext, and image as input parameters to stored procedures and as parameters to dynamic SQL statements.