17.05 - Pack Syntax Elements - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K
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.