RE: OPNQRYF a flat file?

[D.BALE@xxxxxxxxxxxxx]

Buck,

I was trying to avoid copying the flat file to an externally described work
file.  I need to investigate what the typical record counts of this file will
be to determine whether the time to do the copy just so it can be externally
described to be copied again is a show-stopper or not.  Obviously, if the
typical record count is low, then I'll just do the copy.

But even if I end up doing that, I'll still be curious about my original
question.  There's just *gotta* be a way to use OPNQRYF to do this, don't ya
think?

And, yes, I thought for a split second of using FMTDTA, although I have zero
experience with it.  So, please educate me with your examples.

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------
Dan Bale wrote:

>Can OPNQRYF be used on a non-externally described flatfile?

I have never tried it, but your MAPFLD approach is the way to do it.  If you
are forced to use OPNQRYF, copy the flat file to a work file that is
externally described and do your compares against that.  If alternate
solutions are allowed, look at FMTDTA.  FMTDTA can do record selection and
sorting.  I can provide examples if you wish.

Buck Calabro
Commsoft; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.midrange.com
+---
| 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
+---