Re: Returning from a procedure

["Buck Calabro" <buck.calabro@xxxxxxxxxxxx>]

> On the performance, what I am trying to do is
> hide the database behind accessor functions.
> Many times only a few fields are actually
> needed from a file and I thought putting those
> in a service program would cut down on the
> number of programs that access these files
> and make database changes easier

The database purists would say that this 'problem' is a database
design issue.  That is, if you often CHAIN to a file to retrieve a few
fields, then you have too many fields in the record format (it's not
normalised enough.)

One way to retrofit the database is to use a logical file which only
has the fields you're interested in.  That can help your performance
in the service program.  (Fewer fields to decode and buffer for you.)
  --buck