Large Object (LOB) Support

LOB columns with in-row storage

In Adaptive Server, LOB columns that are marked for in-row are stored in-row when there is adequate memory to hold the entire row. When the size of a row increases over its defined limit due to an update to any column in it, the LOB columns which are stored in-row are moved off-row to bring it within the limits. See In-Row Off-Row LOB in the Adaptive Server Enterprise Transact-SQL Users Guide.

The bulk insert routines in Adaptive Server ODBC Driver support the in-row and off-row storage of text, image, and unitext LOB columns in Adaptive Server. Bulk insert routines from earlier client versions always store LOB columns off row.

LOB objects as parameters of stored procedures

Adaptive Server ODBC Driver supports using text, unitext, and image as input parameters in stored procedures and as parameter marker datatypes.