15.00 - CreateFsysInfoTableCreateFsysInfoTable_ANSI - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)

CreateFsysInfoTable
CreateFsysInfoTable_ANSI

Purpose  

Creates a database table to hold file system information generated by PopulateFsysInfoTable macro.

Note: If you use ANSI session mode, use the _ANSI form of the macro.

Creating a table is unnecessary if the PopulateFsysInfoTable or PopulateFsysInfoTable_ANSI macro is called with empty strings for the database and table names, which redirects the output to the screen.

Syntax  

 

Syntax element …

Specifies …

target_database_name

the database in which the table will be created.

Note: 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.

Note: You must have appropriate privileges to create tables in the target database.

storage_type

whether the table is a permanent, global temporary, or volatile table.

Valid values for storage_type are:

  • PERM
  • GLOBALTEMP
  • VOLATILE
  • fallback

    whether the database maintains a fallback copy of the table.

    Valid values for fallback are:

  • Y for yes, meaning the table will have fallback
  • N for no, meaning the table will not have fallback
  • display_opt

    the level of file system detail that can be stored in the table.

    Valid values for display_opt are:

  • S provides minimal amount of file system information detail
  • 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” on page 906.

    Note: The display option chosen for CreateFsysInfoTable must match the display option that will 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.

    Authorization

    In addition to the privileges mentioned above, to run this macro you must have EXECUTE privileges on the CreateFsysInfoTable macro or on the database containing the macro.

    Usage Notes  

    The macro name and arguments are case-insensitive.

    Example : Create a File System Information Table for Short Display

    This statement creates a volatile, non-fallback table to hold a minimal display of disk block information.

    exec dbc.createfsysinfotable 
         ('mytestdb','datablockinfo','volatile','n','showblocks','s');