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 7, “Moving Data In and Out of Databases,” the last sentence in the first paragraph in the section “Loading ASE text and images” 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 from an ASE database column of data type TEXT. Also note that INSERT...LOCATION does not support the use of variables in the SELECT statement. Text and image data inserted is silently right truncated at 20971520 bytes.”