テーブルの作成:
create multiset table Call_Logs.Daily_Log as dbc.tvm with data;
SHOWCOMPRESSデータを含むデータ テーブルの作成:
exec
createfsysinfotable('Call_Logs'
,'showcTrgTableShort'
,'perm'
,'y'
,'showcompress'
,'S'
,'TD_Map1');
ストアド プロシージャを使用してデータをターゲット テーブルに挿入する手順:
exec
populatefsysinfotable('Call_Logs'
,'Daily_Log'
,'showcompress'
,'s'
,'Call_Logs'
,'showcTrgTableShort');
*** Procedure has been executed.
.foldlineおよび.sidetitles書式設定の修飾子でbteqを使用して短い表示出力のデータを表示する手順:
exec populatefsysinfotable('Call_Logs','Daily_Log','showcompress','s','','');
*** Procedure has been executed.
*** Warning: 3212 The stored procedure returned one or more result sets.
*** Total elapsed time was 1 second.
*** ResultSet# 1 : 4 rows returned by "SYSLIB.POPULATEFSYSINFOTABLESP".
Date 17/12/08
Time 07:16:07
DB Name Call_Logs
Tbl Name Daily_log
TID 0000BF270000
TID_TAI 1024
TLA BLC Option DEFAULT
System BLC Option MANUAL
TLA BLC ALG DEFAULT
System BLC ALG ZLIB
TLA BLC Level DEFAULT
System BLC Level 6
Map Name TD_MAP1
Date 17/12/08
Time 07:16:07
DB Name Call_Logs
Tbl Name Daily_log
TID 0000BF270000
TID_TAI 2048
TLA BLC Option DEFAULT
System BLC Option MANUAL
TLA BLC ALG DEFAULT
System BLC ALG ZLIB
TLA BLC Level DEFAULT
System BLC Level 6
Map Name TD_MAP1
Date 17/12/08
Time 07:16:07
DB Name Call_Logs
Tbl Name Daily_log
TID 0000BF270000
TID_TAI 2052
TLA BLC Option DEFAULT
System BLC Option MANUAL
TLA BLC ALG DEFAULT
System BLC ALG ZLIB
TLA BLC Level DEFAULT
System BLC Level 6
Map Name TD_MAP1
Date 17/12/08
Time 07:16:07
DB Name Call_Logs
Tbl Name Daily_log
TID 0000BF270000
TID_TAI 2056
TLA BLC Option DEFAULT
System BLC Option MANUAL
TLA BLC ALG DEFAULT
System BLC ALG ZLIB
TLA BLC Level DEFAULT
System BLC Level 6
Map Name TD_MAP1