Hi Ashley,
You can open 65535 tables per datasessions!
>Hi,
>
>This is not a question, just a comment on the results of some faulty maintenance code I ran yesterday.
>I was attempting to clean up some archival files by removing possible duplicate records, getting rid of deleted ones, making sure the index tags existed, etc.
>I use SELECT DISTINCT * FROM &Sourcefile INTO TABLE TEMP, then appended the records to a good, empty "template" file and then wrote the file to a new copy of the original.
>There were about 2800 files. At 2699 files done, the system slowed to a crawl.
>I discovered that I had not closed the source files opened by the SELECT DISTINCT * statement.
>
>I had 2699 files open in as many work areas! (possible reason for the slowdown :))
>
>I thought that the limit was 255.