topic Re: DMS - Delete Table in Data Connection in SAS Data Management

DMS - Delete Table in Data Connection

jwhite — Fri, 11 Nov 2016 17:20:03 GMT

Using Data Management Studio 2.5/Dataflux I have a SAS Data Connection that I need to delete some tables out of.

I can't find the option to delete the tables from the Data Connections folder in the Data riser in Dataflux, and when I go to the physical folder to delete the actual dataset I get a message that it is in use by Dataflux.

This table is not used in any job or profile, I only see it as an object in the SAS Data Connection folder.

Does a table being part of a Data Connection mean it's always locked by Dataflux? Do I have to delete the whole Data Connection to be able to delete the physical table?

Thanks!

Re: DMS - Delete Table in Data Connection

LinusH — Mon, 14 Nov 2016 15:03:11 GMT

What is the data format?

Since you are talking about delete if from the file system, I presume it's not a table in multi user database.

My guess would be that you somehow have a read lock from DM studio, what happens if you close DM Studio?

Not that I know DM Studio very much, but my impression is that it manages data from one place, and the result is usually stored in another location. So iwouldn't expect DBMS functionality in this tool. Deleting tables is probably beast done in the source system.

Re: DMS - Delete Table in Data Connection

jwhite — Tue, 29 Nov 2016 19:26:47 GMT

@LinusH, sorry for the delayed response. Was out for the holidays.

I've found the issue.

So, when a DM Studio session is running and a connection to a table has been made, the table will be locked. The DM Studio session needs to be closed, delete the table, then when restarting DM Studio the connections will not find that table.

Thanks!

-Jeff