Concatenate - 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

The standard concatenate operator is supported for joining two character or byte expressions together, generating the SQL expression1 || expression2. Numeric or date expressions are converted to characters before concatenating. The resulting type can be BYTE as well as one of the character data types, depends on the type of the expressions. For concatenation operator argument types and rules, see Teradata® Database SQL Functions, Operators, Expressions, and Predicates, B035-1145. When dragging a Concatenate operator into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - String Functions > Concatenate

Columns and/or other expressions can be moved into the (empty) branches of the tree, where the first argument is to the left of the concatenation operator, the second to the right.

There are no special properties for the Concatenate operator.