Re: logical file select/omit

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

Mike,

You can, such as,

   S   RECTYP               COMP(EQ 'A')
  S   ACCOUNT            COMP(EQ 1234)
  S   COMPANY            COMP(EQ 01)

However, these are the only transactions that you will see when using 
this logical. 


If, rather, you want to vary this selection from time-to-time, 
hard-coding the LF is not the way to go.  You could build the DDS source 
dynamically in a preceding program, run the CRTLF, and then use that 
logical.  But, again, you would be restricted to those records during 
that cycle.  I.e., while possible (using OPEN and CLOSE) to vary this 
within a single program, if you want variety in your view (access 
different record types, accounts, and or companies) from run-to-run, my 
suggestion is to use embedded SQL.  A sill at which I do not feel 
proficient to suggest coding samples.


But, if you want a static view (same record set each time), the DDS 
sample would work.


        * Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
        615.995.7024
fax
        615.995.1201
email
        jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Mike Berman wrote:

> hi, i need to select certain type of record,and also
> one specific account and company.can u spec both on logical?
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
>