Generally we create a file in QTemp when returning data for a stored procedure. The cursor is left open so the data can be accessed. I neglected to copy the file to qtemp and now on our test system, I can't close the file, I can't clear the file. I've deleted each of the records in the file manually, however I am concerned the status of 'file in use' will cause problems. How can I get the file closed?
March 9, 2011 7:09 PM
March 10, 2011 1:30 AM