RE: Selection / Omission

From
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzakb/rzakbmst48.htm...

You must use the DYNSLT keyword when you want to select or omit fields
and any of the following are true:

    * The logical file has arrival sequence (no key fields are
specified). See example 1 below.
    * The logical file is a join logical file with the JDFTVAL keyword
specified.
    * The logical file is a join logical file, select/omit fields come
from more than one of the physical files the logical file is based on,
and one of the following is true:
          o The select/omit fields are on the same select or omit
statement. See example 3 below.
          o The select/omit fields are on a mixture of select and omit
statements. See example 4 below.
          o The select/omit fields are on select statements that are
ORed together.
          o The select/omit fields are on omit statements that are ANDed
together. 


> -------- Original Message --------
> Subject: Selection / Omission
> From: "Douglas W. Palme" <dpalme@xxxxxxxxxxx>
> Date: Fri, December 16, 2005 9:40 am
> To: "Mid Range List" <midrange-l@xxxxxxxxxxxx>
> 
> I am trying to build a simple joined logical that must have a selection on 
> two separate fields, but the compiler continues to burp at me, something 
> about DYNSLT which I have never used in the past.  What I want to do is 
> simply select ONLY those records that are equal to the TWO selection 
> fields....nothing else and I am not sure what the compiler wants it to be 
> dynamic.
> 
> Here is the source:
> 
> A          R TRAFFIC                   JFILE(IMPILN00 IMPIHD00)
> A          J                           JOIN(IMPILN00 IMPIHD00) 
> A                                      JFLD(ILNINV# IHDINV#)   
> A            ILNINV#A           I      SST(ILNINV#A 1 1)       
> A            ILNEPRICE                                         
> A            ILNEUAVCST                                        
> A            ILNINVDATE                                        
> A            IHDDELIV                                          
> A            ILNLNTYP                                          
> A          K ILNINV#A                                          
> A          K ILNINVDATE                                        
> A          S IHDDELIV                  VALUES('999')           
> A          S ILNLNTYP                  VALUES(0)               
> 
> Any help would be appreciated.
> 
> Douglas
> 
> If you bought it, it was hauled by a truck - somewhere, sometime.
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.