Defining a Parameter

You can define a parameter in a number of different ways:

• in the SQL window use Parameters > View/Edit Parameter to add or edit a parameter
• in the SQL window, use the Parms tab on the listboxes to view and edit parameters.
• use the queryparm command to query the user for the value of a parameter
• use the setparm command to set a parameter to a particular value

The Add Parameter dialog makes it easy to add a queryparm or setparm command to your query. When you add one of these commands, it will be placed at the top of your SQL at the end of the existing query queryparm / setparm commands.

Parameters Dialog

You open this with (from the SQL window) Parameters > View/Edit Parameter

Parameter Character

By default, parameters are indicated with $. On the Parameters Dialog, you can specify the character to be used.

You can also specify the character with the following command. This command might, for example, be included in a script:

--aqt options,parmchar=$

Parameters Tab

The SQL window has a tab which allows you to view and alter parameter values.