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
- 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.