Table 165. Public Instance Constructors
| Constructor | Description |
|---|---|
| DB2eCommand() | Overloaded. Initialize a new instance of the DB2eCommand class. |
| DB2eCommand(string) | Overloaded. Initialize a new instance of the DB2eCommand class with the text of the query. |
| DB2eCommand(string, DB2eConnection) | Overloaded. Initialize a new instance of the DB2eCommand class with the text of the query and an DB2eConnection object. |
| DB2eCommand(string, DB2eConnection, DB2eTransaction) | Overloaded. Initialize a new instance of the DB2eCommand class with the text of the query, an DB2eConnection object, and the DB2eTransaction object. |
|
|
|
Table 166. Public Instance Properties
| Property | Description |
|---|---|
| CommandText | Gets or sets the SQL statement or stored procedure to execute against the database. |
| CommandType | Gets or sets a value indicating how the CommandText property is interpreted. |
| Connection | Gets or sets the DB2eConnection used by this instance of the DB2eCommand. |
| DesignTimeVisible | Gets or sets a value indicating whether the command object should be visible in a customized interface control. |
| Parameters | Gets the DB2eParameterCollection. |
| Transaction | Gets or sets the DB2eTransaction within which the DB2eCommand executes. |
| UpdatedRowSource | Gets or sets a value that specifies how the Update method should apply command results to the DataRow. |
Table 167. Public Instance Methods
| Method | Description |
|---|---|
| CreateParameter | Creates a new instance of a DB2eParameter object. |
| Dispose | Overloaded. Clean up. |
| EnableDeletePhysicalRemove | Enables or disables physically removing records. |
| EnableDirtyBitSetByApplication | Enables the application mode if enable is true. Otherwise, enables the system mode. |
| EnableReadIncludeMarkedDelete | Makes logically deleted records visible or invisible. |
| EnableReorg | Enables or disables database reorganization by DB2 Everyplace or explicitly by the user with a REORG SQL statement. |
| ExecuteNonQuery | Executes an SQL statement against the Connection and returns the number of rows affected. |
| ExecuteReader | Overloaded. Sends the CommandText to the Connection and builds an DB2eDataReader. |
| ExecuteScalar | Executes the query, and returns the first column of the first row in the resultset returned by the query. Extra columns or rows are ignored. |
| IsEnabledDeletePhysicalRemove | Check if physical remove is enabled or not. If enabled, returns true; otherwise false. |
| IsEnabledDirtyBitSetByApplication | Check if the database system is in application mode or system mode. If enabled, returns true; otherwise false. |
| IsEnabledReadIncludeMarkedDelete | Check if logically deleted records are visible or not to application. Returns true if logically deleted records are visible to application; otherwise returns false. |
| IsEnabledReorg | Checks if database reorganization is enabled. Returns true if it is enabled; otherwise returns false. |
| Prepare | Creates a prepared (or compiled) version of the command at the database. |