× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. March 2015

Re: SQL Tools and Performance

On Thu, Mar 12, 2015 at 12:32 PM, Gerald Kern <jp2558@xxxxxxxxx> wrote:
Vern - putting the B and pressing enter displays the bottom of the result
set *IMMED.

As usual, Chuck did cover this possibility. The default value for the
REFRESH parameter on our system is *ALWAYS, and as I'm trying it right
now, it does seem to be able to jump to the bottom pretty quickly.
(If I'm reading Chuck right, he's saying that *FORWARD can cause
scrolling to the bottom to take more time.)

I must say the quickness was a little surprising to me. I could have
sworn it wasn't always that fast. I will say that STRSQL is still a
fairly new thing at our shop, and I'm still in that awkward phase
where I sometimes use RUNQRY/WRKQRY and sometimes use STRSQL. Maybe
Vern and I are both remembering the slowness of getting to the bottom
of a RUNQRY result, or maybe he has his refresh set to *FORWARD.

John Y.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.