17.00 - DECOMPRESS USING - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

Algorithmically decompress data in this column. For a list of data types that can be algorithmically compressed, see "COMPRESS and DECOMPRESS Phrases" in Teradata Vantage™ - Data Types and Literals, B035-1143.

To specify DECOMPRESS USING compress_UDF_name, the table cannot be populated with rows. 
The default containing database for decompress_UDF_name is SYSUDTLIB. If decompress_UDF_name is an embedded services UDF, then its default containing database is TD_SYSFNLIB. If decompress_UDF_name is not contained in SYSUDTLIB or TD_SYSFNLIB, Vantage returns an error to the requestor.

decompress_UDF_name
The name of the UDF to be used to algorithmically decompress data in this column.