Sends the CommandText to the Connection and builds a DB2ResultSet while specifing DB2ResultSetOptions.
[Visual Basic]
Public Function ExecuteResultSet( _
options As DB2ResultSetOptions _
) As DB2ResultSet
[C#]
public DB2ResultSet
ExecuteResultSet(
DB2ResultSetOptions options
);
[C++]
public: DB2ResultSet
* ExecuteResultSet(
DB2ResultSetOptions options
);
[JScript]
public function ExecuteResultSet(
options : DB2ResultSetOptions
) : DB2ResultSet
;
A DB2ResultSet instance.
[C#] The following example demonstrates how to read data from a scrollable DB2ResultSet.
[C#]
public static string getSalesData(DB2Connection conn)
{
string salesQuery = "SELECT * FROM SALES";
string salesData = "";
DB2Command cmd = new DB2Command(salesQuery, conn);
DB2ResultSet salesRS = cmd.ExecuteResultSet(
DB2ResultSetOptions.Scrollable |
DB2ResultSetOptions.Sensitive |
DB2ResultSetOptions.SkipDeleted |
DB2ResultSetOptions.Updatable);
if (salesRS.Scrollable)
{
if (salesRS.ReadLast())
{
salesData = salesRS.GetDB2Date(0).ToString();
salesData += ", " + salesRS.GetDB2String(1).ToString();
salesData += ", " + salesRS.GetDB2String(2).ToString();
salesData += ", " + salesRS.GetDB2Int32(3).ToString();
}
}
return salesData;
}