RE: Long process time

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

Dwayne,

I haven't used OPNQRYF in a while (switched to SQL) but my understanding is 
that it used the same engine that SQL uses.  Because creating logical path 
improved SQL performance I would think it would also improve OPNQRYF 
performance.

If you are going to create the logical files I would omit the OPNQRYF command.  
In that situation it would be duplication.  Use OVRDBF to specify which logical 
to use for each program call.

HTH,

Rick

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Dwayne Allison
Sent: Wednesday, December 08, 2004 8: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


Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain legally 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.