16.20 - SQL Interface to Ferret SHOWCOMPRESS - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

The Ferret SHOWCOMPRESS command displays compression information. This new feature provides an SQL interface that is equivalent.

The SQL SHOWCOMPRESS command makes it easy to get the compression information into a standard SQL table, making that information accessible through SQL queries. This gives you more options for using SHOWCOMPRESS output.

Benefits

  • The resulting set of rows produced by the SQL function can easily be displayed or uploaded to other applications.
  • Unlike the Ferret utility, does not require console access privileges and is available to all users with correct privileges.

Considerations

This feature does not include any new SQL macros. It can be used with these existing macros, which have two versions, one if you are using Teradata (BTET) session mode, and one if you are using ANSI session mode:
  • CreateFsysinfoTable

    PopulateFsysinfoTable

  • CreateFsysinfoTable_ANSI

    PopulateSysinfoTable_ANSI

Additional Information

  • For information on file system information macros, see File System Information Macros in Teradata Vantage™ SQL Operators and User-Defined Functions, B035-1210.
  • For information on the Ferret utility, see Teradata Vantage™ - Database Utilities , B035-1102 .