dbcursorinfo

Description

Return the number of columns and the number of rows in the keyset if the keyset hit the end of the result set.

Syntax

RETCODE dbcursorinfo(hcursor, ncols, nrows);
 
DBCURSOR    *hcursor;
DBINT              *ncols
DBINT               *nrows;

Parameters

hcursor: Cursor handle created by dbcursoropen.

ncols: Location where the number of columns in the cursor is returned.

nrows: Location where the number of rows in the keyset is returned.

Returns

SUCCEED or FAIL.

Usage

For fully keyset-driven cursors, the nrows parameter contains the number of rows in the keyset. For mixed or dynamic cursors, nrows is always set to -1, unless the keyset is the last one in the result set. In that case, the number of rows in the keyset is returned. This helps the programmer find out when the keyset has hit the end of the result set.

For more information on cursors, see Appendix A, “Cursors.”