Concatenate All - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

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

A variation of the standard concatenate operator is supported for joining two or more character or byte expressions together, generating the SQL: expression1 || expression2 ||…|| expression_n. Numeric or date expressions are converted to characters before concatenating. The resulting type, one of the character or byte data types, depends on the type of the expressions. For more information, refer to the chapter titled Concatenation Operator, in the section titled Argument Types and Rules, found in the SQL Functions, Operators, Expressions and Predicates document, B035-1145. When dragging a Concatenate All operator into a variable, the following tree element is created.

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

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, etc. In the example below, letters ‘A’, ‘B’ and ‘C’ are concatenated together to yield the SQL 'A' || 'B' || 'C', which displays as ‘ABC’.

Variable Creation > Input > Variables: SQL Elements pane - String Functions > Concatenate All (Expressions)

There are no special properties for the Concatenate All operator.