INSERT...LOCATION supports 20MB large object (LOB) data [CR 453439]

Sybase IQ 12.7 ESD #3 increases the limit on the length of large object data (LOB) that can be retrieved from a remote database using INSERT...LOCATION from 32767 bytes to 20MB (20971520 bytes).

In Chapter 2, “Binary Large Object (BLOB) data,” in the section “Large Object data types LONG BINARY and BLOB,” the paragraph that describes inserting Adaptive Server Enterprise IMAGE data should be changed to say:

“An Adaptive Server Enterprise IMAGE column can be inserted into a LONG BINARY column using the INSERT...LOCATION command. All IMAGE data inserted is silently right truncated at 20971520 bytes.”

In Chapter 3, “Character Large Object (CLOB) data,” in the section “Large Object data types LONG VARCHAR and CLOB,” the paragraph that describes inserting Adaptive Server Enterprise TEXT data should be changed to say:

“An Adaptive Server Enterprise TEXT column can be inserted into a LONG VARCHAR column using the INSERT...LOCATION command. All TEXT data inserted is silently right truncated at 20971520 bytes.”