Query from DC_AdsStatement leaving files open

[Tim K]

I'm using a query using DC_AdsStatement that does a SELECT INTO a file which works great except the files selected from and created remain open, but not as open work areas. How do I release these files? Is DROP TABLE the proper way or is will that restrict future use?

[rdonnay]

You should use oAdsStatement:close() when you are finished with a work area that contains a SQL Cursor.

This will insure that Ads statement handles are closed on the server and also any data files associated with the cursor.

[Tim K]

That's what I was missing. Thanks.