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
- ft:locale
- en-US
- ft:lastEdition
- 2025-07-09
- dita:mapPath
- gjn1627595495337.ditamap
- dita:ditavalPath
- qkf1628213546010.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.