[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 to create the table.
You must have appropriate privileges to create tables in the target database.
- target_table_name
- The name of the table to create 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.
- Valid values:
- is_fallback
- Specifies whether the database maintains a fallback copy of the table (Y for yes or N for no).
- SHOWBLOCKS
- SHOWCOMPRESS
- SHOWWHERE
- The listed SHOW* command includes a MapName column. The MapName column appears in the listed SHOW* command displays, and is typically passed the default Teradata map name.
- display_option
- The level of file system detail that can be stored in the table.
- Valid values:
- S provides minimal amount of file system information
- M provides a medium amount of file system information
- L provides the maximum amount of file system information
- For more information about the specific information displayed, see PopulateFsysInfoTable/PopulateFsysInfoTable_ANSI.
The display option chosen for CreateFsysInfoTable must match the display option to be used for the corresponding execution of the PopulateFsysInfoTable macro.
If output is directed to the screen (for example, empty strings are specified for database and table names), then table creation is optional using CreateFsysInfoTable or CreateFsysInfoTable_ANSI macro call. Any display option can be used.
- 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.