Create table:
create multiset table Call_Logs.Daily_Log as dbc.tvm with data;
Create data table that will contain SHOWCOMPRESS data:
exec createfsysinfotable('Call_Logs' ,'showcTrgTableLong' ,'perm' ,'y' ,'showcompress' ,'l' ,'TD_Map1');
To populate data into a target table using the stored procedure:
exec populatefsysinfotable('Call_Logs' ,'Daily_Log' ,'showcompress' ,'l' ,'Call_Logs' ,'showcTrgTableLong'); *** Procedure has been executed.
To display data for the long display output using bteq with the .foldline and .sidetitles formatting qualifiers:
exec populatefsysinfotable('Call_Logs','Daily_Log','showcompress','l','',''); *** Procedure has been executed. *** Warning: 3212 The stored procedure returned one or more result sets. *** Total elapsed time was 2 seconds. *** ResultSet# 1 : 9 rows returned by "SYSLIB.POPULATEFSYSINFOTABLESP". Date 17/12/08 Time 07:11:01 DB Name Call_Logs Tbl Name Daily_log TID 0000BF270000 TID_TAI -1 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 Comp State COMPRESSED Comp Algo IPPZLIB Comp Level 6 Exact Comp Ratio(%) 85.38 Exact (%) of Blocks 91.17 Exact (%) of Data 88.28 Exact Used GB Date 17/12/08 Time 07:11:01 DB Name Call_Logs Tbl Name Daily_log TID 0000BF270000 TID_TAI -1 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 Comp State UNCOMPRESSED Comp Algo N/A Comp Level N/A Exact Comp Ratio(%) Exact (%) of Blocks 8.82 Exact (%) of Data 11.71 Exact Used GB Date 17/12/08 Time 07:11:01 DB Name Call_Logs Tbl Name Daily_log TID 0000BF270000 TID_TAI 0 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 Comp State UNCOMPRESSED Comp Algo N/A Comp Level N/A Exact Comp Ratio(%) Exact (%) of Blocks 100.00 Exact (%) of Data 100.00 Exact Used GB Date 17/12/08 Time 07:11:01 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 Comp State COMPRESSED Comp Algo IPPZLIB Comp Level 6 Exact Comp Ratio(%) 87.31 Exact (%) of Blocks 100.00 Exact (%) of Data 100.00 Exact Used GB Date 17/12/08 Time 07:11:01 DB Name Call_Logs Tbl Name Daily_log TID 0000BF270000 TID_TAI 1028 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 Comp State UNCOMPRESSED Comp Algo N/A Comp Level N/A Exact Comp Ratio(%) Exact (%) of Blocks 100.00 Exact (%) of Data 100.00 Exact Used GB Date 17/12/08 Time 07:11:01 DB Name Call_Logs Tbl Name Daily_log TID 0000BF270000 TID_TAI 1032 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 Comp State UNCOMPRESSED Comp Algo N/A Comp Level N/A Exact Comp Ratio(%) Exact (%) of Blocks 100.00 Exact (%) of Data 100.00 Exact Used GB Date 17/12/08 Time 07:11:01 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 Comp State COMPRESSED Comp Algo IPPZLIB Comp Level 6 Exact Comp Ratio(%) 87.31 Exact (%) of Blocks 100.00 Exact (%) of Data 100.00 Exact Used GB Date 17/12/08 Time 07:11:01 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 Comp State COMPRESSED Comp Algo IPPZLIB Comp Level 6 Exact Comp Ratio(%) 54.00 Exact (%) of Blocks 100.00 Exact (%) of Data 100.00 Exact Used GB Date 17/12/08 Time 07:11:01 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 Comp State COMPRESSED Comp Algo IPPZLIB Comp Level 6 Exact Comp Ratio(%) 61.00 Exact (%) of Blocks 100.00 Exact (%) of Data 100.00 Exact Used GB