SQL Text with Arguments - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
fcf1492702067123.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

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.

Variable Creation > Input > Variables: SQL Elements pane - Run Units > SQL Text With Arguments

This leads to the following Properties dialog.

Variable Creation > Input > Variables: SQL Elements pane - Run Units > SQL Text With Arguments Properties