|
Are these fields always in the same format? For example, maybe your dates are always stored as '8S 0' fields in '*ISO' format? If so, you could program describe one field that would be the entire record, then use a "based" variable to point to the appropriate spot in that record... If they're not always in the same format, you could write routines to translate them. News/400 did an article in May 2000 which was intended to allow you to read & write a database in CL. But, what they actually did was have it call an RPG program, passing the file name, field name, etc, and they read and returned the contents of the field... you might check that out.... On Tue, 7 Aug 2001, Fran Denoncourt wrote: > I have two files: The first is a data base file, XXX, with many date > fields. I would like to validate the contents of each specific date fields. > The second file is an output file, XXXFIELDS, from a query over a file > generated from DSPFFD. File XXXFIELDS has only four fields (file name, > library, field name, field text). The query selects specific date fields to > analyze. So, I would have XXX/Lib/Fld1/text; XXX/Lib/Fld2/text…..etc. > Since there will be several files to analyze - each with several date > fields - I wanted a more generic program with as little hardcoding as > possible. The intent was to read a record from XXX then get all of the date > field names from XXXFIELDS retrieving and analyzing the contents of each > date field before going on to the next XXX record. > Is there a way to get the contents of the date field using the field name > retrieved from XXXFIELDS. There must be a way to reference the data. > Pointers? %ADDR? > Thanks again for your help. > Fran Denoncourt > +--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-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-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.