Example: Populate a File System Information Table for SHOWWHERE Output, Option 'S' - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
qqu1556127655717.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

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