Depending on your implementation, the application can either retrieve data in its own memory space or let Rogue Wave® DB Link handle all memory allocation and data retrieval.

The simplest way is to process the SQL statements and then ask Rogue Wave DB Link for the column data values via the function IldRequest::getCol<data type>Value, where <data type> is one of Rogue Wave DB Link-supported types. All accessors check their argument values. Therefore, the data type for which the accessor is made must match the actual column binding type, and the indexes to the result set, column, and row numbers (optional) must not be out of bounds.

When you use accessors to data types like string or binary, you must copy the returned value to application-allocated memory. This is done because the next data fetch reuses the same internal memory, and, consequently, the previously fetched data will be lost.