Variable-Length Rows in Data-Only-Locked Tables

Versions of Adaptive Server earlier than 15.7 configured for 16K logical page sizes could not create data-only-locked (DOL) tables with variable-length rows if a variable-length column began more than 8191 bytes after the start of the row.

This limitation has been removed starting in Adaptive Server 15.7. See Data Storage in the Adaptive Server Enterprise Performance and Tuning Series: Physical Database Tuning.

JDBC clients do not need special configuration to use this feature. When connected to Adaptive Server version 15.7 that has been configured to receive wide DOL rows, these clients automatically insert records using the wide offset. An error message is received if a client attempts to send a wide DOL row to an earlier version of Adaptive Server, or to a 15.7 Adaptive Server for which the wide DOL row option is disabled.