1962697 - Potential offset of column and variable-length columns in table exceeds limit of 8191 bytes in DOL tables using create or alter table - ASE

• Running command "ALTER TABLE " or "CREATE TABLE" generates warning:

Potential offset of column '<columnname>' (<nnnn> bytes) and subsequent variable-length columns in table <tablename> exceeds limit of 8191 bytes
for column-offset of variable-length columns in DOL tables. Future inserts to this table may fail.

•  Message 4982 may also be reported:

 Msg 4981, Level 20, State 1
 Column offset, 9008 bytes, for variable-length column number 2 exceeds the maximum start offset for variable-length columns in DOL
 tables (8191 bytes). The lock scheme for the object 't1' was not changed.

SAP Adaptive Server Enterprise (ASE) All versions.

Potential offset column-offset variable-length columns DOL datapages wide rows 16K 8K 4K 2K long broad datarows allpages , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem