Page 1 of 1

Query from DC_AdsStatement leaving files open

Posted: Tue Jun 11, 2019 9:30 am
by 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?

Re: Query from DC_AdsStatement leaving files open

Posted: Wed Jun 12, 2019 5:58 am
by 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.

Re: Query from DC_AdsStatement leaving files open

Posted: Wed Jun 12, 2019 2:07 pm
by Tim K
That's what I was missing. Thanks.