CreateFsysInfoTable/CreateFsysInfoTable_ANSI Macros | Teradata Vantage - 17.10 - CreateFsysInfoTable/CreateFsysInfoTable_ANSI - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

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.
Valid values:
  • PERM
  • GLOBALTEMP
  • VOLATILE
is_fallback
Specifies whether the database maintains a fallback copy of the table.
Valid values:
  • Y for yes, meaning the table will have fallback
  • N for no, meaning the table will not have fallback
SHOWBLOCKS
SHOWCOMPRESS
SHOWWHERE
The Ferret SHOW command that this output will resemble.
The listed SHOW* command includes a MapName column. The MapName column appears in the listed SHOW* command displays, and is usually 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 not required 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.