16.20 - Pack Syntax Elements - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)
TargetColumns
[Optional] Specify the names of the input table columns to pack into a single output column. Column names must be valid object names, which are defined in Teradata Vantage™ SQL Fundamentals, B035-1141.
These names become the column names of the virtual columns. If you specify this syntax element, but do not specify all input table columns, the function copies the unspecified input table columns to the output table.
Default behavior: All input table columns are packed into a single output column.
Delimiter
[Optional] Specify the delimiter—a single Unicode character in Normalization Form C (NFC)—that separates the virtual columns in the packed data. The delimiter is case-sensitive.
Default: ',' (comma)
IncludeColumnName
[Optional] Specify whether to label each virtual column value with its column name (making the virtual column target_column:value).
Default: 'true'
OutputColumn
Specify the name to give to the packed output column. The name must be a valid object name, as defined in Teradata Vantage™ SQL Fundamentals, B035-1141.