RE: Long process time

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

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