RE: Query/400 Question: Obtaining DB File Record Number

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.