dotConnect for DB2 Documentation
Devart.Data.DB2 Namespace / DB2Command Class
Properties Methods Events

    DB2Command Class Members

    The following tables list the members exposed by DB2Command.

    Public Constructors
     NameDescription
    Public ConstructorOverloaded. Initializes a new instance of the DB2Command class.  
    Top
    Public Properties
     NameDescription
    Public PropertyGets or sets the SQL statement to execute against DB2.  
    Public PropertyOverridden. Gets or sets the wait time before terminating an attempt to execute a command and generating an error. Note that it is the time to wait for any server reply since the command was sent to a server, and it doesn't include the time necessary to fetch data if the command selects some data.  
    Public PropertyGets or sets a value indicating how the CommandText property is to be interpreted. (Inherited from Devart.Common.DbCommandBase)
    Public PropertyGets or sets the DB2Connection used by this instance of the DB2Command.  
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyGets or sets a form or other container that the Devart.Common.DbCommandBase instance belongs to. (Inherited from Devart.Common.DbCommandBase)
    Public PropertyGets or sets a value indicating whether the command object regenerates parameter objects if text of the command is changed. (Inherited from Devart.Common.DbCommandBase)
    Public PropertyGets or sets the DB2ParameterCollection.  
    Public Property (Inherited from System.ComponentModel.Component)
    Public PropertyGets the DB2Transaction in which the DB2Command executes.  
    Public PropertyGets or sets how command results are applied to the System.Data.DataRow when used by the System.Data.Common.DbDataAdapter.Update(System.Data.DataSet) method of the System.Data.Common.DbDataAdapter. (Inherited from Devart.Common.DbCommandBase)
    Top
    Public Methods
     NameDescription
    Public MethodOverloaded. Starts an asynchronous invocation of an ExecuteNonQuery method. (Inherited from Devart.Common.DbCommandBase)
    Public MethodOverloaded. Starts an asynchronous invocation of an System.Data.Common.DbCommand.ExecuteReader method. (Inherited from Devart.Common.DbCommandBase)
    Public MethodOverridden. Attempts to cancel the command execution.  
    Public MethodCreates a new object that is a copy of the current DB2Command instance.  
    Public Method (Inherited from System.MarshalByRefObject)
    Public MethodCreates a new instance of a DB2Parameter object.  
    Public Method (Inherited from System.ComponentModel.Component)
    Public MethodEnds an asynchronous invocation of the ExecuteNonQuery method.  
    Public MethodEnds an asynchronous invocation of the ExecuteReader method.  
    Public MethodOverridden. Executes SQL statement against the DB2Connection and returns the number of rows affected.  
    Public MethodReturns a specific subset of rows when paging through the results of a query.  
    Public MethodOverloaded. Sends the CommandText to the Connection and builds a DB2DataReader.  
    Public MethodExecutes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored. (Inherited from Devart.Common.DbCommandBase)
    Public MethodSends the CommandText to the Connection and builds an System.Xml.XmlReader. If the first column in the result set is not of a supported type (any character, binary type, or DB2Type.XML), an Invalid Column Type exception will be thrown.  
    Public Method (Inherited from System.MarshalByRefObject)
    Public MethodReturns count of records in the resultset. (Inherited from Devart.Common.DbCommandBase)
    Public Method (Inherited from System.MarshalByRefObject)
    Public MethodCreates a prepared (or compiled) version of the command on the server. (Inherited from Devart.Common.DbCommandBase)
    Public Method (Inherited from Devart.Common.DbCommandBase)
    Public MethodResets CommandTimeout to its default value, which is taken from DefaultCommandTimeout. (Inherited from Devart.Common.DbCommandBase)
    Public Method (Inherited from System.ComponentModel.Component)
    Top
    Public Events
     NameDescription
    Public Event (Inherited from System.ComponentModel.Component)
    Top
    See Also