RE:Logicals?

[Buck Calabro <mcalabro@xxxxxxxxxxxx>]

>>Good day to all;
>>I am wondering about using logical files; say I have a logical built
>>over a large file and we need another logical which is very close to the
>>structure of the already logical file, with the exception of one field
>>and the logicals key sequence.  Is there another way to manipulate the
>>existing logical (without having to build another logical)?
>>I appreciate all responses
>>:-Tim & Dana Truax-:
>
>
>So why are you against another logical?  How many do you have over the
>PF?  10?  50?
>
>If you need it build it.  Especially if it will be used by users using 
>Query, SQL, etc.   Or use OPNQRYF or something.  How many records?

Agreed.
The AS/400 is very very good at amanging access paths; even over large 
files.  My prior employer's standard was to build a logical when needed
for an interactive application, and to use OPNQRYF when needed for batch.
I'm not sure if I'd follow that advice anymore, because the performance of
the machine has become very, very good.

Also, be aware that if you have multiple logical files with the same key
structure, the /400 will share the access path, minimising the overhead
involved in maintaining the access path...

Buck Calabro
Commsoft

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---