When to use send-data commands

For Adaptive Server client applications, send-data commands are the only way to upload large text or image column values a chunk at a time. If your application uploads text or image values that are to large to fit in a contiguous memory buffer, then send-data commands are the only practical method to perform the update.

For text or image column values that are small enough to fit into a contiguous memory buffer, the application may achieve better performance by embedding the values in insert language commands. See the “text and image Data Handling” topics page in the Open Client Client-Library/C Reference Manual for details on this method.