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.
No default string is provided - use the Properties panel to change it. Double-click on String or highlight and click 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.