DECOMPRESS USING - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
ncd1596241368722.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.