I am not sure how you come to this conclusion about running on i and scheduling - there have been 3 solutions offered here that can fulfill that requirement - SEQUEL, NGS-IQ, IBM Web Query, and maybe BCD's Clover.

As an example, with SEQUEL, which we have, one command can do all of this - once a server is defined for the SQL Server connection - easy to do.

SEQUEL/EXECUTE can be used run an ad hoc SELECT statement over an SQL Server source or a SEQUEL view, convert it to XLSX, and email it. I'm sure the other solutions have similar capabilities. The XLSX is, admittedly, pretty basic - column headings and data, although both can be enhanced a bit.

Oh, yeah, as to consolidating things over disparate data sources - a SEQUEL script view can run queries to different RDBMS' and combine the results, which will be temporary results - no federation. Or all this can be done with several commands in a CL.

As to scheduling - well, Robot and the rest can all run commands on a schedule.


On 8/29/2015 2:51 AM, D*B wrote:
Does anyone know of a query tool that meets the following criteria:

- It runs on the IBM i and can be scheduled by Robot

- It can email results as an Excel spreadsheet

- It can query Microsoft SQL Server 2012 and the native database

- It DOES NOT require manually configuring JDBC?



The first requirement might be the show stopper for most of them, if not all.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].