DB2Command Properties

The properties of the DB2Command class are listed here. For a complete list of DB2Command class members, see the DB2Command Members topic.

Public Properties

Property Description
public property ArrayBindCount Gets or sets the number of entries in the array to be bound as a parameter.
public property ArrayBindCountOff Public constant value, which can be used to reset the DB2Command.ArrayBindCount property back to non-array mode.
public property AtomicArrayInput Gets or sets boolean value to determine whether to execute multi-row operations in atomic or non-atomic scope.
public property BlockForNRows Controls the number of rows to be returned to client in a single fetch request.
public property CommandText Gets or sets the SQL statement, XQuery expression, or stored procedure to run against the database.
Data Server restrictions:
All data servers other than Db2® Version 9 and later
XQuery expressions are supported only on Db2 Version 9 and later.
public property CommandTimeout Gets or sets the wait time before terminating the execution of a command and generating an error.
public property CommandType Gets or sets a value indicating how the CommandText property is interpreted.
public property Connection Gets or sets the DB2®Connection that is used by an instance of the DB2Command.
public property Container (inherited from Component) Gets the IContainer that contains the Component.
public property DB2TypeOutput Determines whether the output-only parameter values associated with the DB2Command are returned as native Db2 data types (specifically, classes and structures in the IBM.Data.DB2Types namespace).
public property DbConnection Gets or sets the DbConnection used by an instance of the DB2Command.
public property DbParameterCollection Gets the DbParameterCollection object.
public property DbTransaction Gets or sets the DbTransaction within which the DB2Command runs.
public property DesignTimeVisible Gets or sets a boolean value indicating whether a DB2Command generated by a data adapter is visible.
public property DisableCursorHold Controls the effect of a transaction completion on open cursors.
public property EnableExtendedIndicators Enables the use of default and unassigned indicators as parameters.
public property Parameters Gets the DB2ParameterCollection .
public property ResultSetAsReturnValue Set this value to retrieve result sets from Informix user-defined routines (UDR) as a ReturnValue parameter. This property is ignored when a ReturnValue parameter is not bound in the parameter collection.
Data Server restrictions:
All data servers other than IBM® Informix
this property is supported only on IBM Informix.
public property RetrieveXmlInBinaryFormat The value representing whether or not XML data should be returned in binary format.
public property Site (inherited from Component) Gets or sets the ISite of the Component.
public property StatementConcentrator Gets or sets the value determining whether or not to enable statement concentrator literals.
public property Transaction Gets or sets the DB2Transaction within which the DB2Command runs.
public property UpdatedRowSource Gets or sets a value that specifies how the Update method applies command results to the DataRow.

Protected Properties

Property Description
protected property DesignMode (inherited from Component) Gets a value that indicates whether the Component is in design mode.
protected property Events (inherited from Component) Gets the list of event handlers that are attached to a Component.