String - Teradata Warehouse Miner

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

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

SQL String literal parameter values consist of zero or more characters enclosed in single quotes and are treated as being of type character varying with length equal to the number of characters which are enclosed in quotes. The feature allowing specification of the character set is not supported. When dragging a literal String parameter into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Literal Parameters > String

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

Variable Creation > Input > Variables: SQL Elements pane - Literal Parameters > String Properties

  • Parameter — Either ‘<NewParameter>’ may be selected, or an existing parameter may be selected via the pull-down list.
  • Name — When ‘<NewParameter>’ is selected, the Name of the new parameter may be entered here. The name must be unique among all parameters defined in the analysis.
  • Description — A description of the parameter may be entered here. It should be limited to 512 characters if the analysis is ever to be published to the Model Manager application.
  • String Literal — Type in any valid Teradata String literal. It should be limited to 8192 characters if the analysis is ever to be published to the Model Manager application.
  • Add single quotes — By default, this box is checked to indicate that the String literal should automatically be enclosed in single quote marks when SQL is generated for it. If a single quote mark is already included in the String literal and this box is checked, the single quote mark will automatically be “escaped” by doubling it. If, however, the String literal already contains more than one quote mark, the string is placed in the generated SQL “as-is.” This makes it possible to enter a hexadecimal literal if desired, such as '00'XC.
    If this box is not checked, the String literal will be placed in the SQL “as-is” and therefore behaves just like a Text parameter would.
    The String parameter option “Don't add quotes” must not be used when outputting to a stored procedure.