15.10 - DECOMPRESS USING - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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.

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