Text - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Teradata Warehouse Miner
Release Number
November 2018
English (United States)
Last Update
Product Category

SQL Text literal values consist of any valid SQL text and are placed in the SQL “as-is” without formatting. When dragging a literal Text value into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Literals > Text

No default text is provided - use the Properties panel to change it. Double-click on Text or highlight and click Properties.

Variable Creation > Input > Variables: SQL Elements pane - Literals > Text Properties

Type in any valid Teradata SQL text.

An example of a SQL Text literal might be a hexadecimal literal such as '00'XC, or a literal string with more than one quote, such as ‘If it isn’’t broken, don’’t fix it’.

Since the Text literal is used “as-is” the user must enter any necessary quote marks. Also, in the second example, embedded quote marks must be “escaped” by the user by adding an extra quote mark for each one. The second example requires a Text literal due to the fact that embedded quote marks in String literals are ignored when there are more than one.

Standard right-click menu options are available within the text box, namely Undo, Cut, Copy, Paste, Delete and Select All. Note, however, that the Paste option will convert a columnar list of values separated by carriage returns into a comma separated list, making it easier to copy values from other tools such as Microsoft Excel. Conversion of the values into valid Teradata literals are attempted for each of the incoming values, first into various numeric types, then if these fail, into date values; finally, if these conversions fail, the values are converted into a list of String literals.

When pasting a list of values into this field, care should be taken that the items comprising the list do not themselves contain the current locale's list separator character, leading to undesired results.