Re: Arrays

the problem does not seem to be there, add one intermediate level to the
criteria :

    1 list salesman behind one salesman (if ther is only autority for one
jump automatically to step 3)
    2 Select one salesman from the list
    3 for one salesman list customer ...

Again SQL seems to be a good candidate

----- Original Message ----- 
From: "Douglas W. Palme" <dpalme@xxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, March 29, 2005 5:02 PM
Subject: RE: Arrays


> In some cases a salesman has the authority to view several salesman
numbers
> and their respective customer numbers.
>
> IE: WF has access to salesman 100, 110, 120, 200, and 300.
>
>
> On Tue, 29 Mar 2005 08:46:39 -0600, Bruce Guetzkow wrote
> > Doug:
> >
> > <snip>
> > I thought about creating a logical file for each salesman in customer
> > order
> > but maintenance would be heavy, as each time we add a new salesman I
> > have to
> > create a new logical file and then modify the code.
> >
> > I suppose I could create a logical joined file with the pertinent
> > info and then key in on the salesman and then customer, but I am not
> > sure if that is the best answer.
> >
> > I am open ears to anyone with any suggestions :)
> > </snip>
> >
> > Be careful what you ask for...you just might get it!   ;-)
> >
> > I don't know the layout of your file, but I don't see why you'd need
> > to create a new logical every time you add a salesman.  If the key
> > to the file is CUSTOMER/SALESMAN, then your data records could be
> > retrieved by doing a SETLL for the Customer/Salesman combination
> > specified and do a READE to retrieve ONLY the records for that
> > combination.  If you want a different salesman, clear the subfile
> > and repeat the process with the new Customer/Salesman combo.  One LF
> > should be all that you need.
> >
> > Am I missing something?
> >
> > --Bruce Guetzkow
> >
> > -- 
> > This is the RPG programming on the AS400 / iSeries (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.
>
>
> --
> Open WebMail Project (http://openwebmail.org)
>
> -- 
> This is the RPG programming on the AS400 / iSeries (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.
>
>