File System Information in an SQL Table
To see Ferret SHOWBLOCKS-like file system information in an SQL table, use the CreateFsysInfoTable and PopulateFsysInfoTable macros.
The following example creates a volatile, non-fallback table to hold a small display of disk block information:
exec dbc.createfsysinfotable('targetdatabasename','targettablename','volatile','n','showblocks','s');
The next example populates that volatile table with data block histogram and block-level compression details for the specified input table:
exec dbc.populatefsysinfotable('inputdatabasename','inputtablename','showblocks','s','targetdatabasename','targettablename');
For details, see SQL Functions, Operators, Expressions, and Predicates.