16.20 - Unpack - 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)

The Unpack function unpacks data from a single packed column into multiple columns. The packed column is composed of multiple virtual columns, which become the output columns. To determine the virtual columns, the function must have either the delimiter that separates them in the packed column or their lengths.

Unpack complements the function Pack, but you can use it on any packed column that meets the input requirements.

  • To use Pack and Unpack together, you must run both on NewSQL Engine platform. Pack and Unpack are incompatible with ML Engine functions Pack_MLE and Unpack_MLE.
  • This function requires the UTF8 client character set.
  • This function does not support locale-based parsing with the SDF file.
  • This function does not support Pass Through Characters (PTCs).

    For information about PTCs, see Teradata Vantage™ NewSQL Engine International Character Set Support, B035-1125.

  • This function does not support KanjiSJIS or Graphic data types.