× 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.



You should not need separate logicals for the 2 values, the recommended index will aid in the selection if it can. And I would not specify the logical in the OPNQRYF - that's a misconception that this will sway the optimizer to use it. At least, this is the case with SQL, which uses the same engine. In fact, naming the logical might slow things down a little, compared to naming the physical after the logical has been created.

HTH
Vern

At 09:06 AM 12/8/2004, you wrote:
It should.

But, as a test, you can always run the OPNQRY in debug & it will make
suggestions in the joblogs about logical paths.

STRDBG
OVRDBF     FILE(PA0PBR) TOFILE(PASPBR) SHARE(*YES)
OPNQRYF    FILE((PASPBR)) QRYSLT('ARBGRP *EQ "*R*"')
CALL       PA00061R
CLOF       OPNID(PASPBR)
DLTOVR     FILE(PA0PBR)
ENDDBG


\Vincent

 -----Original Message-----
From:   Dwayne Allison [mailto:Dwayne.Allison@xxxxxxxxx]
Sent:   December 8, 2004 9:40 AM
To:     Midrange Systems Technical Discussion
Subject:        RE: Long process time

Will this save time or not

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Forbes, Vincent
Sent: Wednesday, December 08, 2004 8:41 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Long process time


Create a logical file sorted by the field ARBGRP as the first key, then by whatever else you might need, say account # or a date.

\Vincent


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.