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 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 SQL Data Definition Language - Detailed Topics, B035-1184 and 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.