|
Hi Mapics ML: (This question may not be on point as far as Mapics is concerned but it deals with a Mapics (or IBM AS/400) related utility.) Is there a way, using Query/400, to extract the Record Number from a record in a Non-Keyed Physical DB File onto the face of the Query Report? With a Non-Keyed Physical DB File, there is no KEY so access to a particular record in the file, using either DBU or DFU, requires prior knowledge of the record's Record Number. In our case, the DB file is a Sales Order Listing file that if it were a Keyed Physical DB File, the principal KEY field would be the Sales Order Number field. If there's "no" way to get a known Sales Order's Record Number printed on a Query Report using Query/400, are there other ways of obtaining this information outside of Query/400? At the present time, our Sales Department lady just searches thru the DB file (probably using DBU) until she finds the record she need to edit. It's time consuming and there must be a more efficient way to accomplish this task. I look forward to your comments. Regards, Al Gershen Grants Pass, OR aldg1@charter.net ps: Please notice my new email address. Thank you.
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.