In the SQL Elements category Run Units, select SQL Text with Arguments and drop or move it into the Run Unit tab. A Properties dialog appears in which one or more SQL statements may be entered, with optional placeholders for substitution arguments. If placeholders are included, they are matched with SQL elements or expressions placed in the Arguments folder underneath the element. The SQL generated for these expressions is substituted for the <P1> to <Pn> symbols in the SQL text, where n is the number of arguments. Note that the SQL Text With Arguments element is also available in the Other category.
The Sql Text With Arguments Run Unit may be used to execute one or more SQL statements separated by semi-colons. However, it cannot be used to create a Stored Procedure or Macro.
When dragging a SQL Text with Arguments element onto a Run Unit, the following tree element is created.
This leads to the following Properties dialog.
