When manipulating long data, it may not be feasible for the application to load the entire parameter data value into storage at the time the statement is executed, or when the data is fetched from the database. A method has been provided to allow the application to handle the data in a piecemeal fashion. The technique to send long data in pieces is called Specifying Parameter Values at Execute Time because it can also be used to specify values for fixed size non-character data types such as integers.
An application can also use the SQLGetSubString() function to retrieve a portion of a large object value. See Figure 16 in "Using Large Objects" for details.