例: SHOWWHERE出力のファイル システム情報テーブルの挿入(オプション'M') - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL演算子およびユーザー定義関数

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
2021年7月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/fsi1592016213432.ditamap
dita:ditavalPath
ja-JP/wrg1590696035526.ditaval
dita:id
B035-1210
Product Category
Software
Teradata Vantage

データを中形式出力のターゲット テーブルに挿入する場合:

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

データを中形式の画面に挿入する場合:

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