Re: Interactive Queries - again!

[Pete Massiello <pmassiello@xxxxxxxxxxxxxxxx>]

Bob,

    You may wish to check out our ShowMe/400 product at 
http://www.os-solutions.com
which allows you to create drill down inquiries which can then be converted to
RPG/DDS.  They perform very similar to a program that you would write yourself. 
 We
take advantage of Logical files, just as you would when you write a program.  
We have
taken queries that ran in hours, and converted them into ShowMe definitions and 
ran
them as interactive displays in just seconds.  Think of the CPU savings and the 
I/O
savings that you will receive.

    If you want further information, contact me via phone or email.

    Pete

Bob Clarke 3rd x4502 wrote:

> Hello All.  I've been off of the list for a while and recently
> re-subscribed now that I've once again had additional AS/400
> responsibilities thrown at me - but it's nice to be back.
>
> Recently an old ongoing problem has reared it's ugly head and caused me
> fits - that of rogue users running queries interactively during normal
> business hours.  This of course results in numerous complaints about
> response time, etc.  As I recall from way back then, there really wasn't
> a whole lot one could do to stop or restrict these miscreants.  However
> quite some time has passed (since I've been involved or concerned about
> the issue anyway), and I wondered if there has been any new light shed on
> the matter.  Also, we've since upgraded from V3r1 to V3r2 - any changes
> there that might help?
>
> I hope I'm not beating a dead horse here - my apologies if that's the
> case.  Either way, I'd appreciate any feedback (short of anything
> resulting in insult or injury, that is).  Thanks in advance!
>
> Regards,
>
> Bob Clarke
>
>   ------------------------------------------------------------------------
>                   Name: WINMAIL.DAT
>    WINMAIL.DAT    Type: Text Document 
>(application/x-unknown-content-type-txtfile)
>               Encoding: BASE64

--
Pete Massiello
OS Solutions International
Phone: (203)-744-7854  Ext 11.
http://www.os-solutions.com
mailto:pmassiello@os-solutions.com


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---