Re: FMTDTA Vs OPNQRYF..

[DAsmussen@xxxxxxx]

Rajee,

In a message dated 97-05-27 09:11:31 EDT, you write:

>    In the application we are using there are many CLPs with FMTDTA. now we
>  are planning to change all these instants by OPNQRYF statement. We donot
>  know much about FMTDTA(..Especially the sort specifications used..). Can
>  anybody let us know how to go about with it.

Depending upon what you are trying to do (and whether or not the application
itself has been reengineered), you might be making a mistake.  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.

HTH,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@AOL.COM

"As for butter vs. margarine, I trust cows more than chemists." -- Joan
Gussow
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *