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