Re: PC Memory/Data Bases

>The point--  the AS/400 does the job that the PC platform does.  Faster.
>When used properly.  It's important to have someone who knows the database
>and the Query application write or review the project.  This same expert
>has
>performed similar magic for some of our manufacturing locations.

>The advantage of downloading a file for use in a query on a PC is that the
>user can do the job independent of IS resources.

I think that is pretty much exactly what I was saying. Let's face it, what
happens is that because we don't want users trouncing the system every
time they have some idea about how a report can save the world, we don't
give them the access they want. Next thing you know, a company that
couldn't produce bug free code on a bet controls the market. Why? Because
they give the end user some control. A user would rather reboot six times
and get a report than wait six months for someone in MIS to write it for
them.

My point on this is that I think we AS/400 biggots should use available
solutions when necessary to provide better service to our users. 

>Why isn't there an option on the Query command that says, "Search all
>available access paths?   {*YES *NO}."  This would at least give us the
>option of making that choice.

Isn't that a time related option? I haven't checked it in a long time, but
I could have sworn you can up the time limit that query uses for searching
access paths. I believe the reason for giving it a time limit is so that
it won't spend more time picking a path than the query would run if it
just read the twentyfive records involved. 



Chris Rehm             | You have to ask yourself, "How
Mr.AS400@ibm.net       | often can I afford to be unexpectedly 
                       | out of business?" 
Get Warped or Get Bent!| Then get an AS/400.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *