Pack Syntax Elements - Teradata® Database

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.

Accumulate

[Optional] Specify the input columns to copy to the output table.

ColCast

[Optional] Specify whether to cast each numeric target_column to VARCHAR.

Specifying 'true' decreases run time for queries with numeric target columns.

Default: false