Executing Procedures without SQL

The procedure feature in Host Integrator is often associated with SQL, but you can also explicitly execute a procedure directly through the Host Integrator connector APIs using the PerformTableProcedure method. This enables you to bypass procedure resolution and post-fetch filtering. Depending on the structure of your host application and whether you benefit from the additional capabilities provided by SQL, executing procedures directly might improve the performance of your deployed models.

The process for creating procedures is the same whether you execute the procedure using SQL or the PerformTableProcedure method.

See Using Host Integrator Connector APIs for information on using the PerformTableProcedure method.

 

Related Topics
Bullet SQL syntax
Bullet SQL overview
Bullet Creating tables
Bullet Connector APIs