|
Message text written by INTERNET:MIDRANGE-L@midrange.com >Hi 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. Thanx in advance. Rajee thomas Ambarish R. Bagali. Sriven Computer Soln. Hyderabad - India < Rajee; I guess you got a converted S/36 system eh? First analysis your data base and determine which files you will Querying most often. Find what your predominate sorts(order by's) are that you will be using via OPNQRYF . Then create some Logical Files by those keys (NO select/Omits in the LF's) Now convert the FMTDTA (which used the S/34-S/36 sort spec's) to the OPNQRYF's. The reason to go to the trouble of creating the LF's first (if they do not exist) is that the OPNQRYF's will run much quicker. And they can be used INSTEAD of the FMTDTA in some cases(where a simple order by is needed). You may find that you may use the logical in the program alot of the time by itself. Creating the LF's will hopefully save the OPNQRYF from having to build indexes a good percentage of the time. John P. Carr CDP EdgeTech 5921 Acorn Ridge CT. Midlothian VA. 23112 74711.77@compuserve.com Ph. 804-739-7689 Fax 804-739-7950 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 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 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.