|
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.
midrange.com
* 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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
