Verastream Host Integrator .Net Reference

HostIntegratorSession.ExecuteSQLStatement Method (String)

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

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

Parameters

statement
Specifies the SQL statement to execute.

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