Specifying Retrieval Arguments in a Query File

You can specify retrieval arguments in the SQL editor when you add saved query files for your SQL statement operations in the Database Service editor.

To specify retrieval arguments in a query file:

Open the query file you want to edit in the SQL editor.
Click inside the SQL editor and select Design|Retrieval Arguments from the main menu bar to open the Specify Retrieval Arguments dialog and add an argument.
Adding an argument to create a Where clause:
1. Enter the argument name and type, and click OK.
2. Select the column from the Column drop-down list in the Where tab.
3. Select the operator from the Operator drop-down list.
4. Right-click in the Value column, select Arguments from the context menu, select the argument, and click Paste.
5. Save the query file. Select File|Save in the main menu bar
Preview the results:
1. Select Execute from the Design menu to open the Specify Retrieval Arguments dialog.
2. Enter a value for the argument you created, and click OK.
3. Select the Results tab to preview the results.
4. Save the query file. Select File|Save in the main menu bar.

Adding a SQL Statement Operation by Importing Query Files