Algorithmically decompress data in this column. For a list of data types that can be algorithmically compressed, see the 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.