17.10 - Example: Populate a File System Information Table for SHOWWHERE 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)

To populate data into a target table for the short display output:

exec dbc.populatefsysinfotable('Call_Logs','t','showwhere','s','Call_Logs','showw_s');
sel * from Call_Logs.showw_s;

                TheDate  15/01/28
				TheTime  01:00:57.780000
		   DataBaseName  Call_Logs
			  TableName  t
			    TableID  0000130B0000
			 TableIDTAI    0
					Vproc -1
					Drive -1
				LrgCyls   10
				SmlCyls    0
				MapName
			  TableType  PERM
				  Grade
				GradePct   .00
				  VHCyls     0
				 HotCyls     0
				WarmCyls     0
				ColdCyls    10
			   CylsinSSD     0
TemperaturesMature  Y

To populate data onto the screen for short display:

exec dbc.populatefsysinfotable('Call_Logs','Daily_Log','showwhere','s','','');
 *** Warning: 3212 The stored procedure returned one or more result sets.
 *** Total elapsed time was 6 seconds

*** ResultSet# 1 : 1 rows returned by "SYSLIB.POPULATEFSYSINFOTABLESP".
 
                   Date  15/01/28
				   Time  09:01:46
				DB Name  Call_Logs
	           Tbl Name  Daily_Log
					TID     0000130B0000
				TID_TAI       0
					Vproc      -1
					Drive      -1
		    	Lrg Cyls     10
		    	Sml Cyls
		    	MapName
    		TableType  PERM
					Grade
		    Grade(%)
					 VH Cyls
		   Hot Cyls
		  Warm Cyls
		  Cold Cyls        10
	 Cyls in SSD
Temperatures Mature  Y