Access, Analyze, and Summarize Your Data with Tables

SEQUEL helps you access, analyze, and summarize your data with two easy-to-use table options.

Do you need to extract lots of System i transaction data to your PC for analysis—too much data for your PC to handle? Do you need to move (pivot) the data in a spreadsheet for ease‑of‑use? Do you have staff members that need to take this data on the road to critical accounts? Wouldn’t it be nice to have a tool that could summarize the data and show you the detail behind the summaries?

SEQUEL is that tool. With SEQUEL's tabling options—Host Tables and Client Tables—you can summarize your transaction data into spreadsheet-like tables

Host Tables

Use SEQUEL Host Tabling to automatically summarize DB2 transaction data into spreadsheet‑like files with summary rows and columns. You can easily add totals, rankings, percent of total, and other calculations. The SEQUEL Host Tabling views organize data into columns for regions, time periods, or other categories. And, you can output this summarized data to multiple formats, including XLS, XML, or CSV.

Client Tables

SEQUEL Client Tabling is an interactive solution for dynamic data mining and analysis. It offers drill-down, reporting, analysis, ranking, and graphing functions to help you analyze your data like you never thought you could. First, you consolidate data from your database into a portable, standalone module. Then, you use the Client Tabling drag‑and‑drop features to reorganize (pivot) the data and view the results instantly without affecting the data in the database.

See how SEQUEL tables can stop the data overload on your desktop. 

Related Topics

Tabling

SEQUEL