Purpose
Creates a database table to hold file system information generated by PopulateFsysInfoTable macro.
If you use ANSI session mode, use the _ANSI form of the macro.
The PopulateFsysInfoTable or PopulateFsysInfoTable_ANSI macro can be called with empty strings for the database and table names, which redirects the output to the screen.
Syntax
[DBC.] { CreateFsysInfoTable | CreateFsysInfoTable_ANSI } ( 'target_database_name', 'target_table_name', 'target_table_type', 'fallback', { 'SHOWBLOCKS' | 'SHOWWHERE' | 'SHOWCOMPRESS' }, 'display_option', 'mapname' )
- 'target_database_name'
- The database in which the table will be created.You must have appropriate privileges to create tables in the target database.
- 'target_table_name'
- The name of the table that will be created to hold file system information.You must have appropriate privileges to create tables in the target database.
- 'target_table_type'
- Specifies whether the table is a permanent, global temporary, or volatile table.
- 'is_fallback'
- Specifies whether the database maintains a fallback copy of the table.
- 'SHOWBLOCKS', 'SHOWCOMPRESS', or 'SHOWWHERE'
- The Ferret SHOW command that this output will resemble.
- 'display_option'
- The level of file system detail that can be stored in the table.
- 'mapname'
- Supports table creation in the specified map. If you do not want to choose a map name for the target table creation, you can specify empty strings (' ') for this parameter. In that case, the table is created in the default map.