17.10 - Example: Populate a File System Information Table for SHOWCOMPRESS Output, Option 'S' - 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)

Create table:

create multiset table Call_Logs.Daily_Log as dbc.tvm with data;

Create data table that will contain SHOWCOMPRESS data:

exec 
     createfsysinfotable('Call_Logs'
		   ,'showcTrgTableShort'
		   ,'perm'
		   ,'y'
		   ,'showcompress'
		   ,'S'
		   ,'TD_Map1');

To populate data into a target table using the stored procedure:

 exec 
     populatefsysinfotable('Call_Logs'
     		,'Daily_Log'
     		,'showcompress'
     		,'s'
     		,'Call_Logs'
     		,'showcTrgTableShort');

*** Procedure has been executed. 

To display data for the short display output using bteq with the .foldline and .sidetitles formatting qualifiers:

exec populatefsysinfotable('Call_Logs','Daily_Log','showcompress','s','','');

 *** Procedure has been executed. 
 *** Warning: 3212 The stored procedure returned one or more result sets.
 *** Total elapsed time was 1 second.

 *** ResultSet# 1 : 4 rows returned by "SYSLIB.POPULATEFSYSINFOTABLESP".

             Date  17/12/08
             Time  07:16:07
          DB Name  Call_Logs
         Tbl Name  Daily_log
              TID  0000BF270000
          TID_TAI    1024
   TLA BLC Option  DEFAULT
System BLC Option  MANUAL
      TLA BLC ALG  DEFAULT
   System BLC ALG  ZLIB
    TLA BLC Level  DEFAULT
 System BLC Level  6
         Map Name  TD_MAP1
         
             Date  17/12/08
             Time  07:16:07
          DB Name  Call_Logs
         Tbl Name  Daily_log
              TID  0000BF270000
          TID_TAI    2048
   TLA BLC Option  DEFAULT
System BLC Option  MANUAL
      TLA BLC ALG  DEFAULT
   System BLC ALG  ZLIB
    TLA BLC Level  DEFAULT
 System BLC Level  6
         Map Name  TD_MAP1
         
             Date  17/12/08
             Time  07:16:07
          DB Name  Call_Logs
         Tbl Name  Daily_log
              TID  0000BF270000
          TID_TAI    2052
   TLA BLC Option  DEFAULT
System BLC Option  MANUAL
      TLA BLC ALG  DEFAULT
   System BLC ALG  ZLIB
    TLA BLC Level  DEFAULT
 System BLC Level  6
         Map Name  TD_MAP1
         
             Date  17/12/08
             Time  07:16:07
          DB Name  Call_Logs
         Tbl Name  Daily_log
              TID  0000BF270000
          TID_TAI    2056
   TLA BLC Option  DEFAULT
System BLC Option  MANUAL
      TLA BLC ALG  DEFAULT
   System BLC ALG  ZLIB
    TLA BLC Level  DEFAULT
 System BLC Level  6
         Map Name  TD_MAP1