INSERT...LOCATION PACKETSIZE limitation for TDS [CR 470047]

When INSERT...LOCATION is transferring data between a Sybase IQ server and a remote Sybase IQ or Adaptive Server Anywhere server, the value of the INSERT...LOCATION TDS PACKETSIZE parameter is always equal to 512 bytes, even if you specify a different value for PACKETSIZE.

The following sentence will be added to the PACKETSIZE description in the “Usage” section of the “INSERT statement” section in Chapter 6, “SQL Statements”:

“When INSERT...LOCATION is transferring data between a Sybase IQ server and a remote Sybase IQ or Adaptive Server Anywhere server, the value of the INSERT...LOCATION TDS PACKETSIZE parameter is always equal to 512 bytes, even if you specify a different value for PACKETSIZE.”