× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Al,

If you are already using DBU to find the record, why not use the search
function? F15 allows you to define the search and F16 performs it. You then
have the record or records you want in a subfile to do with as you wish.

Regards,
Jon Le Roi
Director of Information Systems
Tegal Corporation


-----Original Message-----
From: Al Gershen [mailto:aldg1@charter.net]
Sent: Thursday, June 27, 2002 2:02 PM
To: MAPICS Mailing List
Cc: Gershen, Al
Subject: Query/400 Question: Obtaining DB File Record Number


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.
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
or email: MAPICS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.