Re: ECPG and Curors.

On Mon, Jun 12, 2006 at 11:14:24PM -0400, Peter L. Berghold wrote:
> what I don't see is how to detect that I've fetched the last row from a
> query. Is there more complete doco on this process somewhere?

You could either handle a NOT FOUND exception, or make use of SQLCODE or
SQLSTATE like this...

EXEC SQL DECLARE csr_fred CURSOR FOR SELECT....

EXEC SQL OPEN csr_fred;

while (SQLCODE == 0) {
EXEC SQL FETCH csr_fred INTO :jim, :sheila,...

if (SQLCODE == 0) {

....
body of row processing here
....
}
}

EXEC SQL CLOSE csr_fred;