SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

DMS - Delete Table in Data Connection

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 88
Accepted Solution

DMS - Delete Table in Data Connection

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!


Accepted Solutions
Solution
‎11-29-2016 02:26 PM
Frequent Contributor
Posts: 88

Re: DMS - Delete Table in Data Connection

@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

View solution in original post


All Replies
Super User
Posts: 5,254

Re: DMS - Delete Table in Data Connection

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.

Data never sleeps
Solution
‎11-29-2016 02:26 PM
Frequent Contributor
Posts: 88

Re: DMS - Delete Table in Data Connection

@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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 277 views
  • 0 likes
  • 2 in conversation