SEQUEL Tabling Example

SEQUEL Tabling automatically summarizes DB2 transaction data into spreadsheet-like files with summary rows and columns along with totals, rankings, percent of total and other aggregate calculations. SEQUEL Tabling views accumulate data into "buckets" for regions, time periods or any other summary categories.

Before Tabling

The results of a standard SEQUEL view show normalized transaction data, as shown below.

After Tabling

The same data as summarized in a SEQUEL table. Rows and columns are automatically generated for each occurrence of data (e.g. each region and product category in the example). Once a Table is defined, no further modifications would be required if a new region or product occurs in the data, such as when a new product is introduced.