17.00 - DECOMPRESS USING - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

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.