Re: How to treat obsolete information from a physical file

[manish soni <pesfunk@xxxxxxxxx>]

Hi,

I think it if pretty simple. If you are doing a load-all subfile, while
writing the record to subfile, just check if it is active or inactive in a
subroutine and based on that write to subfile.

I think that could solve your problem.

Best Regards
Manish

On Fri, Nov 6, 2009 at 4:47 PM, David FOXWELL <David.FOXWELL@xxxxxxxxx>wrote:

> Hi,
>
> I'd like to know how you are treating such records, for example, a client
> that is no longer with you. In our client file, the client would be flagged
> as being no longer active, but never deleted. The trouble is, this has led
> to us creating logical files that omit these inactive records and that is a
> problem for the programs that use SQL.
>
> Now, my RPG program needs to list clients in a subfile where the user types
> part of a name and/or town. If I don't use the OMIT logical, then my program
> must read all active and inactive clients then do the same with the address.
>
> Any thoughts will be appreciated.
> --
> This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.