例: SHOWWHERE出力のファイル システム情報テーブルの挿入(オプション'S') - 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','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

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

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