17.10 - Example: Populate a File System Information Table for SHOWWHERE Output, Option 'M' - 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 medium display output:

exec dbc.populatefsysinfotable('Call_Logs', 'Daily_Log','showwhere','m','Call_Logs','showw_m');

SELECT * from Call_Logs.showw_m;

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

To populate data onto the screen for Medium display:

exec dbc.populatefsysinfotable('Call_Logs','Daily_Log','showwhere','m','','');
 *** Warning: 3212 The stored procedure returned one or more result sets.

                           Date  15/01/28
						   Time  09:04:14
						DB Name  Call_Logs
					   Tbl Name  Daily_Log
							TID  0000130B0000
						TID_TAI       0
						  Vproc       0
						  Drive      -1
					   Lrg Cyls    2
					   Sml Cyls
					   MapName
					  TableType  PERM
						  Grade
					   Grade(%)
						VH Cyls
					   Hot Cyls
					  Warm Cyls
					  Cold Cyls    2
					Cyls in SSD
			Temperatures Mature  Y
						   Date  15/01/28
						   Time  09:04:14
						DB Name  Call_Logs
					   Tbl Name  Daily_Log
							TID  0000130B0000
						TID_TAI       0
						  Vproc       1
						  Drive      -1
					   Lrg Cyls    2
					   Sml Cyls
					   MapName
					  TableType  PERM
						  Grade
					   Grade(%)
						VH Cyls
					   Hot Cyls
					  Warm Cyls
					  Cold Cyls    2
					Cyls in SSD
			Temperatures Mature  Y
						   Date  15/01/28
						   Time  09:04:14
						DB Name  Call_Logs
					   Tbl Name  Daily_Log
							TID  0000130B0000
						TID_TAI       0
						  Vproc       2
						  Drive      -1
					   Lrg Cyls    3
					   Sml Cyls
					   MapName
					  TableType  PERM
						  Grade
					   Grade(%)
						VH Cyls
					   Hot Cyls
					  Warm Cyls
					  Cold Cyls     3
					Cyls in SSD
			Temperatures Mature  Y
						   Date  15/01/28
						   Time  09:04:14
						DB Name  Call_Logs
					   Tbl Name  Daily_Log
							TID  0000130B0000
						TID_TAI       0
						  Vproc       3
						  Drive      -1
					   Lrg Cyls    3
					   Sml Cyls
					   MapName
					  TableType  PERM
						  Grade
					   Grade(%)
						VH Cyls
					   Hot Cyls
					  Warm Cyls
					  Cold Cyls    3
					Cyls in SSD
			Temperatures Mature  Y