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).
An Adaptive Server Enterprise IMAGE column inserted into a LONG BINARY column using the INSERT...LOCATION command is now silently right truncated at 20971520 bytes, rather than 32767 bytes.
An Adaptive Server Enterprise TEXT column inserted into a LONG VARCHAR column using the INSERT...LOCATION command is now silently right truncated at 20971520 bytes, rather than 32767 bytes.
See “Documentation updates and clarifications” for documentation changes related to this feature.
Users must be specifically licensed to use the Large Objects Management functionality. For details on the Large Objects Management option, see Large Objects Management in Sybase IQ.