RE: AS/400 Report Writers

George,

I've had great success with MS Access.  If you're having a problem with ODBC
timeouts, you can set the "ODBC Timeout" property to 0.  This will prevent
any timeouts.

You can also have the query run on the AS400 directly by using what's called
a "Pass-Through" query in Access.

Access is such a robust tool that I wouldn't hesitate to recommend it to
anyone.

As a brief "Shameless Plug", I'd like to mention that my company has begun
teaching an "MS Access for BPCS" public education class.

Paul Holstein
iWork Software, L.L.C.


On Thu, 4 May 2000 07:02:40 -0600, BPCS-L@midrange.com wrote:

>  This one keeps coming up so you might download the history from
midrange.com
>  for additional detail.
>  
>  I like the Windows based tools myself because of their easy integration
with
>  other tools like MS Excel and web browsers. I would look at Seagate
Crystal
>  Reports, Cognos, and Showcase. MSAccess can provide reports to end users
>  pretty easily, plus other database functionality. Beware of using the
pure
>  ODBC tools (Crystal, MS Access) however because of some limitations. I
have
>  seen queries and reports that won't run correctly on big tables because
the
>  optimizer on the 400 incorrectly forecasts the amount of time it will
take
>  to run the query as exceeding the allowed limit. Showcase and I believe
>  Cognos get around this by having an engine that runs on the 400 and
performs
>  the actual querying using 400 friendly database calls, then passes only
the
>  results back to the workstation client.
>  
>  http://www.seagatesoftware.com/homepage/ (download it for free)
>  http://www.cognos.com/impromptu/index.html
>  http://www.showcasecorp.com/strategy/strategy.html
>  
>  Best Wishes,
>  
>  Geo.
>  
>  +---
>  | This is the BPCS Users Mailing List!
>  | To submit a new message, send your mail to BPCS-L@midrange.com.
>  | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>  | To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>  | Questions should be directed to the list owner: dasmussen@aol.com
>  +---





_______________________________________________________
Get 100% FREE Internet Access powered by Excite
Visit http://freelane.excite.com/freeisp

+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---