Handling Multiple Result Sets

A result set is returned at fetch time for each SQL select statement. Sybase and MS SQL Server return several result sets for a stored procedure call.

When the target RDBMS allows queries to be sent in batches, there may exist several successive result sets to be fetched. In this case, DB Link retrieves the first set, then returns the value IlFalse from the call to hasTuple.

To make sure that there is no other result set to be fetched, you must issue another call to fetch and then a call to IldRequest::hasTuple, as shown in the following example:

{

cout << "\tResult sets: " << endl;

while (request->fetch().hasTuple()) {

if (request->getColCount()) {

IldPrintTuple(request, IldNames);

IldPrintTuple(request, IldSeparators);

do {

IldPrintTuple(request);

} while (request->fetch().hasTuple());

}

else {

IlInt count = 0;

if ((count = request->getStatus()) > 0)

cout << count << " modified row"

<< ((count > 1) ? "s" : "") << endl;

}

cout << endl;

}

}