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 6, “SQL Statements,” in the “Usage” section of the “INSERT statement” section, the last sentence in the paragraph describing inserting Adaptive Server Enterprise TEXT and IMAGE data should be changed, so that the paragraph says:

“Sybase IQ does not support the Adaptive Server Enterprise data type TEXT, but you can execute INSERT...LOCATION (Syntax 3) from both an IQ CHAR or VARCHAR column whose length is greater than 255 bytes, and from an ASE database column of data type TEXT. ASE TEXT and IMAGE columns can be inserted into columns of other Sybase IQ data types, if Sybase IQ supports the internal conversion. All data inserted is silently right truncated at 20971520 bytes.”