Required Syntax Elements for Unpack - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™
TargetColumn
Specifies the name of the input column that contains the packed data.
OutputColumns
Specifies the name for the output columns, in the order in which the corresponding virtual columns appear in target column. The names must be valid object names, as defined in Teradata Vantage™ - SQL Fundamentals, B035-1141.
If you specify fewer output column names than there are virtual input columns, the function ignores the extra virtual input columns. That is, if the packed data contains x+y virtual columns and the OutputColumns syntax element specifies x output column names, the function assigns the names to the first x virtual columns and ignores the remaining y virtual columns.
OutputDataTypes
Specifies the data types of the unpacked output columns. Supported data types are VARCHAR, INTEGER, DOUBLE PRECISION, TIME, DATE, and TIMESTAMP.
If OutputDataTypes specifies only one value and OutputColumns specifies multiple columns, the specified value applies to every output_column.
If OutputDataTypes specifies multiple values, it must specify a value for each output_column. The nth datatype corresponds to the nth output_column.
The function can output only 16 VARCHAR columns.