Verastream Host Integrator .Net Reference

HostIntegratorSession.ExecuteSQLStatement Method (String, Int32)

Executes an SQL statement on a table defined in the model.

[Visual Basic]
Overloads Public Function ExecuteSQLStatement( _
   ByVal statement As String, _
   ByVal maxRows As Integer _
) As DataSet
[C#]
public DataSet ExecuteSQLStatement(
   string statement,
   int maxRows
);

Parameters

statement
Specifies the SQL statement to execute.
maxRows
Specifies the maximum number of rows to return. A value of zero will return all rows.

Return Value

This method returns a DataSet containing the results of the query. If no data are returned, this method returns an empty DataSet.

Remarks

Executes an SQL statement on a table defined in the model.

Exceptions

Exception TypeCondition
HostIntegratorModelDataExceptionThrown if the SQL statement cannot be resolved
HostIntegratorTerminalExceptionThrown if there is an execution error
HostIntegratorConnectorExceptionThrown when client is not connected
HostIntegratorExceptionThrown if the connection is for metadata only

See Also

HostIntegratorSession Class | HostIntegratorSession Members | WRQ.Verastream.HostIntegrator Namespace | HostIntegratorSession.ExecuteSQLStatement Overload List