|
I don't use QTEMP for work files unless creating a temporary file through SQL. I usually add a member using the job number to an existing file and then remove the member when the job is complete. This avoids problems with object locks and is supposed to be faster than duplicating the entire object to QTEMP. The disadvantage of this techinique is these members will remain if the job is ended abnormally for some reason. The good news about that is debugging and recovery is made easier since QTEMP objects are deleted when the job ends. Donald R. Fisher, III Project Manager Roomstore Furniture Company (804) 784-7600 extension 2124 DFisher@xxxxxxxxxxxxx <clip> a friend suggested that I use a work file in qtemp for the processing of the data...however, I have never used work files before, let alone in qtemp. <clip>
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.