Adding a SQL Statement Operation by Importing Query Files

You can save your SQL select statements in query files if you plan to use them more than once. To create a query file, see Creating and Saving Query Files.

To import a query file:

Select the Service Interface page in the database service editor.
Select Add SQL Statement Operation|Add Request-Response Operation to add a default operation to the interface.
Invoke the Properties Panel by double-clicking or right-click and select Show Properties Panel.
From the Properties Panel Source tab, click Import.
The Import Query File dialog appears.
Select your query file and click OK.
The Source tab of the Database Operation Parameters dialog displays the path to the query file and the SQL text. The Parameters tab displays the query's parameters, and the Result Sets tab displays the results.
Click OK to import the query file into the SQL statement operation.

Adding a SQL Statement Operation Using SQL Dialog

Adding a SQL Statement Operation Manually

Adding a SQL Statement Operation