DB2 Version 10.1 for Linux, UNIX, and Windows

DB2DataReader Members

DB2DataReader overview

Public Properties

Property Description
public property BlockForNRows Controls the number of rows to be returned to client in a single fetch request
public property Depth Gets a value that indicates the depth of nesting for the current row.
public property FieldCount Gets the number of columns in the current row.
public property HasRows Gets a value that indicates whether the DB2DataReader contains one or more rows.
public property IsClosed Indicates whether the DB2DataReader is closed.
public property This Overloaded. Gets the value of a column in its native format.

In C#, this property is the indexer for the DB2DataReader class.
public property RecordsAffected Gets the number of rows that are changed, inserted, or deleted by execution of the SQL statement.

Public Methods

Method Description
public method Close Closes the DB2DataReader object.
public method CreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information that is required to generate a proxy used to communicate with a remote object.
public method Equals (inherited from Object) Overloaded. Determines whether two Object instances are equal.
public method GetBoolean Gets the value of the specified column as a Boolean value.
public method GetByte Gets the value of the specified column as a byte.
public method GetBytes Reads a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset.
public method GetChar Gets the value of the specified column as a character.
public method GetChars Reads a stream of characters from the specified column offset into the buffer as an array, starting at the given buffer offset.
public method GetDataTypeName Gets the name of the source data type.
public method GetDate Gets the value of the specified column as a Date object.
public method GetDateTime Gets the value of the specified column as a DateTime object.
public method GetDB2®Binary Creates an instance of a DB2Binary object from the column data.
public method GetDB2Blob Creates an instance of a DB2Blob object from the column data.
public method GetDB2Clob Creates an instance of a DB2Clob object from the column data.
public method GetDB2Date Creates an instance of a DB2Date object from the column data.
public method GetDB2DateTime Creates an instance of a DB2DateTime object from the column data.
public method GetDB2Decimal Creates an instance of a DB2Decimal object from the column data.
public method GetDB2DecimalFloat Creates an instance of a DB2DecimalFloat object from the column data.
public method GetDB2Double Creates an instance of a DB2Double object from the column data.
public method GetDB2Int16 Creates an instance of a DB2Int16 object from the column data.
public method GetDB2Int32 Creates an instance of a DB2Int32 object from the column data.
public method GetDB2Int64 Creates an instance of a DB2Int64 object from the column data.
public method GetDB2Real Creates an instance of a DB2Real object from the column data.
public method GetDB2Real370 Creates an instance of a DB2Real370 object from the column data.
public method GetDB2RowId Creates an instance of a DB2RowId object from the column data.
public method GetDB2String Creates an instance of a DB2String object from the column data.
public method GetDB2Time Creates an instance of a DB2Time object from the column data.
public method GetDB2TimeStamp Creates an instance of a DB2TimeStamp object from the column data.
public method GetDB2Value Creates an Object instance from column data.
public method GetDB2Values Gets all the column values for the current row.
public method GetDB2Xml Creates an instance of a DB2Xml object from the XML column data.
public method GetDB2XsrObjectId Creates an instance of a DB2XsrObjectId object from the column data.
public method GetDecimal Gets the value of the specified column as a Decimal object.
public method GetDouble Gets the value of the specified column as a double-precision floating point number.
public method GetEnumerator Returns an enumerator that iterates through the DB2DataReader object.
public method GetFieldType Gets the Type that is the data type of the object.
public method GetFloat Gets the value of the specified column as a single-precision floating-point number.
public method GetGuid Not supported.
public method GetHashCode (inherited from Object) Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures such as a hash table.
public method GetInt16 Gets the value of the specified column as a 16-bit signed integer.
public method GetInt32 Gets the value of the specified column as a 32-bit signed integer.
public method GetInt64 Gets the value of the specified column as a 64-bit signed integer.
public method GetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
public method GetName Gets the name of the specified column.
public method GetOrdinal Gets the column ordinal, given the name of the column.
public method GetSchemaTable Returns a DataTable that describes the column metadata of the DB2DataReader.
public method GetStream Gets the value of the specified column as a System.IO.Stream object.
public method GetString Gets the value of the specified column as a string.
public method GetTime Gets the value of the specified column as a TimeSpan object.
public method GetTimeSpan Gets the value of the specified column as a TimeSpan object.
public method GetType (inherited from Object) Gets the Type of the current instance.
public method GetValue Gets the value of the column at the specified ordinal in its native format.
public method GetValues Gets all the attribute columns in the current row.
public method GetXmlReader Returns an XmlReader from a character, binary, or DB2Type.XML column.
public method GetXmlSchemaSet Overloaded. Returns an XmlSchemaSet object of all the schema documents for the given DB2XsrObjectId.
Data server restrictions:
Informix®
This method is not supported.
public method InitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
public method IsDBNull Gets a value that indicates whether the column contains non-existent or missing values.
public method NextResult Advances the DB2DataReader to the next result, when reading the results of batch SQL statements or a multiple result-set stored procedure.
public method Read Advances the DB2DataReader to the next record.
public method ToString (inherited from Object) Returns a String that represents the current Object.

Protected Methods

Method Description
protected method MemberwiseClone (inherited from Object) Creates a shallow copy of the current Object.
Reference
DB2DataReader Class
IBM.Data.DB2 namespace