Parameter prompts

SQL statements can contain parameter names enclosed within $$ (double dollar signs). When you execute the statement, the SQL Whiteboard prompts you for values for all parameters in that statement. You can reuse values for those parameters.

For example, consider a table, T that contains a column T1. You can enter the following statement in the Statement field:

Select T1 from T where T1 = $$p1$$

When you click Execute, the Parameters dialog appears.

Enter a value, for example 1. The statement is executed, and the following tabs will appear in Statement Details dialog:

  • Execution Results—Displays the output generated by the statement after the parameter is replaced by the value you entered.

  • Execution Parameters—Lists p1 parameter with value 1.

  • Executed Statement—Contains Select t1 from T where t1 = 1.

You can enter another statement that uses the parameter, p1. The statement will be executed. For example, if you enter Select * from T where T1 = $$p1$$ + $$p2$$, the same dialog appears. However, p1 (with value one) and p2 appear.

You can enter values again.