Re: Build a logical using a partial key and select certain records

[CRPence <CRPbottle@xxxxxxxxx>]

  There are no requirements for any key field specifications, 
although then either K *NONE or the file-level DYNSLT may be 
required to allow the file to create.

Regards, Chuck

Pat Barber wrote:
> Does STATE have to be key  ???
>
> Jerry Adams wrote:
> > You mean like this:
> >
> >   R PRCOVRR                   PFILE(QS36F/PRCOVR)
> >     STATE              I      SST(PRTXCD 1 2)
> >     TXCODE             I      SST(PRTXCD 3 3)
> >     PRTXCD
> >     PRPRIC
> >     PRPITM
> >   K STATE 
> >   K PRPITM
> >   S TXCODE                    COMP(EQ '01R')
> >
> > In this example PRTXCD is the tax code.  For New Mexico
> > the full code might be NM01R, NMU1R, etc.