I guess I have never noticed that all of my SELECT -SQL statements end up using the tables EXCLUSIVE. THis is fine if you are closing them afterward but that is not the case in some of them. THey are using tables that are already opened SHARED. Here's an example:
m.dStartDate={07/28/2000}
m.dEndDate={07/28/2000}
SET STAT BAR ON
SELECT ach_final.*;
FROM ach_final ;
WHERE BETWEEN(TTOD(ach_final.cleared), m.dStartDate, m.dEndDate) ;
ORDER BY ach_final.bankname, ach_final.settdate, ach_final.mid ;
INTO TABLE ach_final1.DBF
The ach_final file is already opened shared. IT then opens it exclusive. It's driving me crazy. It does the same to the ach_final1 table.
Any ideas as to why this is happening?
Thanks for your support in advance! :-)
Thanks in advance for your help! :-)
Randall L. Johnson