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 information about the rules you must follow to create valid algorithmic decompression UDFs for UDT columns, see “CREATE FUNCTION (External Form)/ REPLACE FUNCTION (External Form)” in Teradata Vantage™ SQL Data Definition Language Detailed Topics , B035-1184 and Teradata Vantage™ SQL External Routine Programming , B035-1147 .

If you specify DECOMPRESS USING, you must also specify COMPRESS USING. You can specify COMPRESS USING and DECOMPRESS USING in either order.

decompress_UDF_name
The name of the UDF to be used to algorithmically decompress data in this column for the following data types:
  • ARRAY/VARRAY
  • BLOB
  • BLOB-related UDT
  • BYTE
  • CHARACTER
  • CLOB
  • CLOB-related UDT
  • Geospatial
  • GRAPHIC
  • TIME
  • TIME WITH TIME ZONE
  • TIMESTAMP
  • TIMESTAMP WITH TIME ZONE
  • Distinct UDTs
  • XML
Structured UDTs cannot be algorithmically compressed.
database_name
The default containing database for decompress_UDF_name is SYSUDTLIB. If decompress_UDF_name is an embedded services UDF, the default containing database is TD_SYSFNLIB. If decompress_UDF_name does not reside in SYSUDTLIB or TD_SYSFNLIB, the system returns an error.