16.20 - DECOMPRESS USING - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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, Teradata Database returns an error to the requestor.

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