RE: [Junk released by Allow List] Re: Build a logical using a partial key and select certain records

[Jerry Adams <Jerry@xxxxxxxxxxxxxxx>]

No, Pat.  That was just needed for the logical that I was using.  Just illustrating that the key can be a partial field.  I thought that was part of what you wanted, but I may have misinterpreted.  

Anyway, the key fields can be "normal" fields or partial fields; anything that is in the list of fields.  There, just to confuse the issue some more, fields in the physical (PRCOVR) that are not included in the logical.

Jerry C. Adams
IBM System i Programmer/Analyst
--
B&W Wholesale
office: 615-995-7024
email:  jerry@xxxxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pat Barber
Sent: Friday, March 19, 2010 1:00 PM
To: Midrange Systems Technical Discussion
Subject: [Junk released by Allow List] Re: Build a logical using a partial key and select certain records

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.  
>
>
>