DB2®ResultSet Properties

The properties of the DB2ResultSet class are listed here.

Table 1. Public Properties
Property Description
public property BlockForNRows Controls the number of rows to be returned to client in a single fetch request
public property CursorType Indicates the type of cursor represented by the DB2ResultSet object.
public property Depth Indicates the depth of nesting for the current row.
public property FieldCount The number of columns in the current row.
public property HasRows Indicates whether the DB2ResultSet contains one or more rows.
public property IsClosed Indicates whether the DB2ResultSet is closed.
public property IsDeleted Gets a value that indicates if the row is deleted.
public property RecordsAffected Gets a value that indicates the number of records that are affected by a Delete, Insert, or Update operation.
public property Scrollable Gets a value that indicates if the cursor is scrollable.
public property Sensitive Gets a value that indicates if the cursor is sensitive to updates made by the application and other cursors.
public property SkipDeleted Gets a value that indicates if the cursor skips deleted rows when fetching.
public property this Overloaded. Gets the value of a column in its native format.
public property Updatable Gets a value that indicates if you can update the result set.