Support for Expanded Variable-length Rows

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 Chapter 2, "Data Storageā€ in the Adaptive Server Enterprise Performance and Tuning Series: Physical Database Tuning.

ODBC and 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 Adaptive Server 15.7 for which the wide DOL row option is disabled.