Re: FMTDTA Vs OPNQRYF..

[cmassoglia@xxxxxxxxxxx (Charlie Massoglia)]

Dean wrote:
>I've seen many
>instances in which FMTDTA actually ran MUCH faster than OPNQRYF.
>
>FMTDTA is basically a facility by which you can use S/36 #GSORT
>specifications on the AS/400.  In native mode, these specifications are
>placed in a source member (usually in file QFMTSRC, QTXTSRC, or QS36SRC for
>standard migrations).  All documentation can be found in the "Sort User's
>Guide" (sorry, don't have the BM# handy).  I would SERIOUSLY consider
>benchmarking the performance of OPNQRYF programs against FMTDTA programs
>prior to switching.
>
I agree FMTDAT used to be MUCH faster than OPNQRYF on large files.  As I
recall, on A S/38 our rule of thumb was 20,000 or more record use FMTDTA.  I
do not think that FMTDTA is that much faster than OPNQRYF on the AS/400. I
have not run any structured performance comparisons recently.  Has anyone else?


Charlie Massoglia, Massoglia Technical Consulting, Inc.
PO Box 1065, Okemos, MI 48854, USA
517-676-9700  Fax: 517-676-1006  EMAIL: cmassoglia@voyager.net


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *