DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
Sends the CommandText to the Connection and builds a DB2ResultSet.
The DB2Command.ExecuteResultSet() method queries catalog tables to obtain the metadata information. Therefore, in some cases DB2Command.ExecuteReader() will work faster than DB2Command.ExecuteResultSet().
| Method | Description |
|---|---|
| ExecuteResultSet(IBM®.Data.DB2®CursorType) | Sends the CommandText to the Connection and builds a DB2ResultSet based on a DB2CursorType. |
| ExecuteResultSet(IBM.Data.DB2ResultSetOptions) | Sends the CommandText to the Connection and builds a DB2ResultSet based on DB2ResultSetOptions. |
| ExecuteResultSet(System.Data.CommandBehavior, IBM.Data.DB2CursorType) | Sends the CommandText to the Connection and builds a DB2ResultSet based on CommandBehavior and a DB2CursorType. |
| ExecuteResultSet(System.Data.CommandBehavior, IBM.Data.DB2CursorType, bool) | Sends the CommandText to the Connection and builds a DB2ResultSet based on CommandBehavior, a DB2CursorType, and a value determining if the operation will be aborted should the cursor be downgraded. |
| ExecuteResultSet(System.Data.CommandBehavior, IBM.Data.DB2ResultSetOptions) | Sends the CommandText to the Connection and builds a DB2ResultSet based on CommandBehavior and DB2ResultSetOptions. |
| ExecuteResultSet(System.Data.CommandBehavior, IBM.Data.DB2ResultSetOptions, bool) | Sends the CommandText to the Connection and builds a DB2ResultSet based on CommandBehavior, DB2ResultSetOptions, and a value determining if the operation will be aborted should the cursor be downgraded. |