Adding a SQL Statement Operation by Importing Query Files

Add a SQL statement operation to your database service by using an imported query file.

Prerequisites

Create a query file.
Edit the select statement.
For the edits to be picked up by the database service, you must enter the edits from in the view of the service editor. You cannot edit the query file directly.

You can also edit the database service interface using this procedure.

Open the database service you want to add a SQL statement to.
Select the Service Interface tab in the editor.
To add a SQL statement to the service interface, do one of the following:
- Select the Service Interface page in the editor, right-click the Interface box, and select Add SQL Statement Operation > Add Request-Response Operation.
- Open the Tool Palette, drag SQL Statement - Request Response from the palette, and drop it onto the interface.
- Drag a query file from the WorkSpace Navigator and drop it onto the interface.
A default operation is added to the service interface.
Select to add a default operation to the interface.
Expand the Properties section.
The Source tab describes the query file. The Basic Properties tab lists properties, which you can edit.
To add a SQL statement, do the following:
1. In the service editor, select the operation.
2. In Properties, select the Source tab.
3. Click Import Query File.
  The Import Query File dialog opens.
4. Select a Query file from your project and click OK to import the query file into the database service interface.
  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.
Select File > Save.