15.10 - DECOMPRESS USING - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
Content Type
Programming Reference
Publication ID
English (United States)

Algorithmically decompress data in this column for the following data types: ARRAY/VARRAY, BLOB, CLOB, BLOB-related UDT, CLOB-related UDT, JSON, XML, geospatial, CHARACTER, GRAPHIC, BYTE, TIME, TIME WITH TIME ZONE, TIMESTAMP, or TIMESTAMP WITH TIME ZONE. 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.

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