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 .