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.

The Open Client and Open Server Bulk-Library 15.7 routines, used to populate Adaptive Server logical pages, support the extended DOL rows. This feature is automatically activated in Bulk-Library 15.7 and later, but must be enabled in Adaptive Server.

Databases that are configured for wide DOL rows can accept DOL rows sent from an application that uses Bulk-Library 15.5 or earlier. However, applications that use Bulk-Library 15.7 must not send wide DOL rows to Adaptive Server 15.5 or earlier, or to a database that expects DOL rows in the old format. Otherwise, one of these errors occur:

BCP failed to create rows in target table. Column %1! would start at an offset over 8191 bytes; this starting location cannot be represented accurately in the table's (row) format.
BCP failed to create rows in target table. Column %1! starts at an offset greater than %2! bytes; this starting location is not permitted by the current database configuration.

To correct the error:

Change the locking scheme of the table from data-only-locked to allpages-locked.
When connected to Adaptive Server 15.7 or later, enable the allow wide dol rows option in the target database. See Chapter 2, "Data Storage” in the Adaptive Server Enterprise Performance and Tuning Series: Physical Database Tuning.