Re: i5 data mining tools for users

  Rob,
  Although I agree that Query/400 is a nice tool, it can only use the old CQE 
Query engine. In order to take advantage of the newer SQE you need to use an 
SQL-based application, like Query Manager or SEQUEL (I'm sure there most be 
more, but these two are the ones that come to mind right now).
  As always, of course, it depends on your business needs and resources.
  Regards,
  Luis Rodriguez

midrange-l-request@xxxxxxxxxxxx wrote:------------------------------

message: 4
date: Fri, 30 Mar 2007 09:02:12 -0400
from: rob@xxxxxxxxx
subject: Re: i5 data mining tools for users

Query/400.

The problem is not the tools.
It is not the users.

It is in the developers.

Developers need to create powerful views.  What use is it to give the 
users some slick GUI tool and still expect them to know that you join ECL 
on ECH and IIM and, to calculate on hand you need to take 
IOPB+IADJ+IRCT-IISS?  When you can create a view that:
- joins these files together
- Calculates these simple fields like onhand
- renames fields into something meaningful
...

We still have users that upload data from their PC's to the i5 so that 
they can analyze it using Query/400.  Frankly, it's a great tool.  Now, a 
user like me prefers SQL so that I can use parenthesis, etc.  But for a 
quick and dirty I may fall into query/400 the way some of you may bypass 
WDSC into SEU for a quick and dirty.

Rob Berendt