RE: AS/400 Report Writers

george, here are a couple possibilities.

1. i believe that the as/400 has a system value called QQRYTIMLMT which set the 
maximum time limit for queries. when a query is submitted the estimated time 
that it will take to process is compared against this system value and if the 
estimated time is greater, the query is not run. this time limit can be 
increased.
2. as far as allowing users to run update queries from access, i believe that 
you can configure the ODBC DSN as read only. if you constructed a read only DSN 
and told the users to use that one, i don't think it would allow an access 
update query to run.
3. access and other tools can do a great job in the users hands. but be careful 
how you use these tools. they do not relieve you (the user?) from documenting 
what queries exist, where they are, how to run them, etc. remember, the user 
that develops all of these queries may not be with your organization forever!

chick doe
barton instrument systems

>>> gsagen@primesourcetech.com 05/04/00 11:11PM >>>
Paul,

Thanks for the feedback.  Maybe you can help me lick this one. The issue I'm
getting is when I join multiple large tables. The error I get isn't a
timeout. I can't remember the exact verbiage, but it implied that it
forecasted how long the query would take, and the forecast exceeded some
threshold. The message was returned immediately after submitting the
request. I get the same message in green screen SQL command line on the 400
sometimes. It happens when I do a monster query against the
GHH==>GLH==>GCR==>GSV. Pass throughs in this situation get the same
response.

Oracle and Informix seem to be able to recognize that most of the records
are being filtered out of the primary and apply the filter to the parent
table before joining to the children. The 400 seems to do all the joins
first then filter on the conditions last. Am I writing the queries wrong?

While we're on the subject of pass-through queries, do you know of a way to
pass a where condition into the pass-through query like you do with a
regular one by putting your prompt text into square brackets on the criteria
line? I know you can do it in VBA, but I'm wondering if there's something
I'm missing in the query builder.

Also on your point about MS Abcess being robust and user friendly--I agree,
but am scared to show users too much because of the damage they can do with
update queries. I'm afraid of what the sysadmin would say if he saw the big
hole we blow in security too. Any ideas on how to secure the ODBC service to
limited users?

Geo.
(801) 360-6360

+---
| 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 
+---

+---
| 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
+---