Pro * C ++: Notes for batch reading

When reading data in the cursor in Pro * C in batches, note: when reading data in the cursor in batches at the last time, the data is retrieved to hostarray, and sqlca. sqlcode is set to 1403 (no_data_found ). If you determine sqlca. sqlcode immediately after fetch, the last data may not be retrieved.
The insurance method is to define the number of last read records for a variable record:
If (sqlca. sqlcode = 1403 & sqlca. sqlerrd [2] <= nlastcount)
{
Break;
}
Nlastcount = sqlca. sqlerrd [2];

A good syntax is: do {} while (sqlca. sqlcode! = 1403); to judge, the code is more concise!

Do
{
Exec SQL ftech curname into: hostarray;
Int ncount = sqlca. sqlerrd [2]-nlastcount;
//...
} While (sqlca. sqlcode! = 1403 );