Gain insight from the data in your databases
Use aXes browser-based DB2 query tool for exploring your data
Use the aXes DB2 query tool to build and run queries against IBM i (System i, iSeries or AS/400) DB2 databases from a browser. You can query DB2 tables, print the query results and/or copy the results into applications like Microsoft Excel.
Create and run queries from a browser
Use the aXes browser-based query tool to create distributed SQL database queries for DB2 databases and any ODBC/JDBC accessible data sources.
Building queries with aXes requires no knowledge of, or experience with SQL. You can build a query via point-and-click by displaying a list of tables, choosing columns and adding selection filters. aXes generates the SQL code that is used to retrieve the data from the database. Using the query editor, experienced users have the option to extend the generated SQL code or write SQL code from scratch.
Save DB2 queries and recall them for later use
Saving queries makes it quick and easy to rerun frequently used queries by setting the selection filters (e.g. a date range) and running the query.
View query results in a web browser
aXes DB2 query tool displays real-time query results as a web page. aXes uses IBM i database authorization so that users only see data they are authorized to view.
Use query results in applications like Microsoft Excel and Word
Query results can be used in applications such as Excel and Word without writing macros. Copy-and-paste the information from the query results web page directly into the application. Use tools like Excel to analyse the data and produce graphs and charts.