Re: RPG enhancement suggestion

["James W. Kilgore" <qappdsn@xxxxxxx>]

Scott,

I agree with you that the purpose of some logicals would be to restrict
access to information.  It's a part of the whole physical/logical virtual
reality of RDBMS. All you see is what is real.

I believe the original thread had to do with performance of unused fields
with a read/cycle get operation.

AFAIK, since the S/32 unused fields have not generated a buffer to variable
move operation.

Removing unused fields has a null computer/negative labor effort effect BTW.
(Oops. wrong thread!)

If one is to blast through a file looking at only one field (delete status =
"Y" or lastused<currentdate-3years) why build a special logical?

Let me play the role of the red-headed stepchild (I do it so well) ;-)

What ever you are trying to do, use the unkeyed physical, (you do have
unkeyed physicals don't you?)  Use OPNQRYF to perform record selection (it's
more efficient than RPG) if you can.  But the point is that an Input Primary
can be blocked without any record locking.  If you process a record which
meets your delete/update requirement you can use a keyed logical or renamed
relative record number physical to perform the required operation.

IMHO, If a process takes too long, it's because a human interfered with the
machines innate ability.

"Scott P. Johnson" wrote:

> One of the reasons for Logical Files.  The other is setting up a key
> for a file. In the SQL world there are VIEWs and INDEXs.  So don't be
> afraid to set up a LF just to get a "limited" view of a file. Or just
> use SQL and Create View to set it up for ya.
>
> We do this for our Employee Master file.  Some people need to be able
> to view some of an employee's info.  The pay stuff and such stays
> 'hidden' from this view.

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