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

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

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
2021年1月
Language
日本語
Last Update
2021-03-31
dita:mapPath
ja-JP/xwv1596137968859.ditamap
dita:ditavalPath
ja-JP/xwv1596137968859.ditaval
dita:id
B035-1210
Product Category
Software
Teradata Vantage

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

exec dbc.populatefsysinfotable('Call_Logs', 'Daily_Log','showwhere','l','Call_Logs','showw_l');
sel * from Call_Logs.showw_l;

                    TheDate  15/01/28
				   TheTime  01:06:52.710000
			  DataBaseName  Call_Logs
				 TableName  Daily_Log
				   TableID  0000130B0000
				TableIDTAI     0
					       Vproc  2
					       Drive  2
				   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:06:52.710000
			  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:06:52.710000
			  DataBaseName  Call_Logs
				 TableName  Daily_Log
				   TableID  0000130B0000
				TableIDTAI       0
					       Vproc    0
					       Drive    0
				   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:06:52.710000
			  DataBaseName  Call_Logs
				 TableName  Daily_Log
				   TableID  0000130B0000
				TableIDTAI    0
					       Vproc 3
					       Drive 3
				   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','l','','');
 *** Warning: 3212 The stored procedure returned one or more result sets.
 
                  Date  15/01/28
					   Time  09:07:54
					DB Name  Call_Logs
				   Tbl Name  Daily_Log
						TID  0000130B0000
					TID_TAI      0
					     Vproc   0
					     Drive   0
				   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:07:54
					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:07:54
					DB Name  Call_Logs
				   Tbl Name  Daily_Log
						TID  0000130B0000
					TID_TAI       0
					     Vproc    2
					     Drive    2
				   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:07:54
					DB Name  Call_Logs
				   Tbl Name  Daily_Log
						TID  0000130B0000
					TID_TAI       0
					     Vproc    3
					     Drive    3
				   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