Create table:
create multiset table Call_Logs.Daily_Log as dbc.tvm with data;
Create data table that contains SHOWCOMPRESS data:
exec
createfsysinfotable('Call_Logs'
,'showcTrgTableShort'
,'perm'
,'y'
,'showcompress'
,'S'
,'TD_Map1');
To populate data into a target table using the stored procedure:
exec
populatefsysinfotable('Call_Logs'
,'Daily_Log'
,'showcompress'
,'s'
,'Call_Logs'
,'showcTrgTableShort');
*** Procedure has been executed.
To display data for the short display output using bteq with the .foldline and .sidetitles formatting qualifiers:
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