IfxCommand public properties
The following table shows the public properties of the IfxCommand class.
| Property | Type | Description |
|---|---|---|
| CommandText | System.String | Gets or sets the text command to run against the data source. The CommandType property is used to interpret this property. All ODBC escape sequence syntax that the HCL OneDB™ ODBC Driver supports is also supported by the HCL® OneDB .NET Core Provider. |
| CommandTimeout | System.Int32 | Gets or sets the wait time before terminating the attempt to execute a command and generating an error. |
| CommandType | System.Data.CommandType | Indicates how the CommandText property is interpreted. The possible values of the CommandType property are described after the table. |
| Connection | IfxConnection | Gets or sets the IfxConnection object used by this IfxCommand object. |
| Parameters | IfxParameterCollection | Gets the IfxParameterCollection object. |
| RowFetchCount | System.Int32 | Sets the number of rows to fetch in each fetch operation. This value affects the performance of the fetch operation. The value is not applicable if the table contains columns of BLOB, CLOB, TEXT or BYTE data type. |
| Transaction | IfxTransaction | Gets or sets the transaction in which the IfxCommand object executes. |
| UpdatedRowSource | System.Data.UpdateRowSource | Gets or sets how command results are applied to the DataRow when used by the IfxDataAdapter.Update method. The possible values of the UpdatedRowSource property are described after the table. |
The CommandType property can have any of the following
values:
- StoredProcedure—The name of a stored procedure.
- TableDirect—When the CommandType property is set to TableDirect, the CommandText property should be set to the name of the table or tables to be accessed. If any table names contain special characters, you might need to dereference them, for example, by using escape-character syntax or including qualifying characters. All rows and columns of the named tables are returned when you call the ExecuteNonQuery, ExecuteScalar, or ExecuteReader methods of the IfxCommand class. To access multiple tables, use a comma delimited list, without spaces or padding, that contains the names of the tables to access. When the CommandText property specifies multiple tables, a join of those tables is returned.
- Text—An SQL text command (the default)
Set the
RowFetchCount property immediately after creation of the IfxCommand
object or before invoking methods such as ExecuteReader that return
an instance of DataReader. You can also set the RowFetchCount value
by using the constructor. For example to set the RowFetchCount to
1, complete either of the following steps:
- IfxCommand SelCmd = new IfxCommand(SQLcom, conn1); SelCmd.RowFetchCount = 1
- int rowFetchCount = 1; IfxCommand SelCmd = IfxCommand(cmdText, connection, rowFetchCount)
The UpdatedRowSource property can have any of the following
values:
- Both—Both the output parameters and the first returned row are mapped to the changed row in the DataSet object.
- FirstReturnedRecord—The data in the first returned row is mapped to the changed row in the DataSet object.
- None—Any returned parameters or rows are ignored.
- OutputParameters—Output parameters are mapped to the changed row in the DataSet object.