データを短形式出力のターゲット テーブルに挿入する場合:
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