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.
Required Privileges
In addition to the privileges already mentioned, to run this macro you must have EXECUTE privileges on the CreateFsysInfoTable macro or on the database containing the macro.
The macro name and arguments are case-insensitive.
Syntax
[DBC.] { CreateFsysInfoTable | CreateFsysInfoTable_ANSI } ( 'target_database_name', 'target_table_name', 'target_table_type', 'fallback', { 'SHOWBLOCKS' | 'SHOWWHERE' | 'SHOWCOMPRESS' }, 'display_option', 'mapname' )
Syntax Elements
- 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
- 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.