|
Thanks Pete That did the trick. I knew SQL could do it but I wasn't aware of the create view. This also gave much more leeway on my selection criteria. Thanks Again. >We have files which the application secures based on the USERID. I am >trying to define a logical file in DDS incorporating the USERs name into >the CMP selection. i.e > >A R RECORD1 >A R FUSER >A S CMP(FUSER EQ USER) > >Unfortunately it treats USER as a field and generates an error. Does >anyone know of a way this can be accomplished. Thankyou in advance. All >suggestions are welcomed. > I haven't tried this on the AS/400, but SQL has a USER special register. I > believe you could create a view and specify USER in a where clause. I've > done this with CURRENT DATE, and that works. I'd expect that USER would also. > Pete Hall > peteh@inwave.com > http://www.inwave.com/~peteh > +--- Michael Kenney University of Windsor Windsor ON N9B 3P4 Canada (519)253-3000 extension 2754 KENNEY@UWINDSOR.CA +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.