RE: Selection / Omission

Thanks Mike


On Fri, 16 Dec 2005 07:45:56 -0700, michael wrote
> 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.
> 
> -- 
> 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.


If you bought it, it was hauled by a truck - somewhere, sometime.