Architecting, installing and maintaining your SAS environment

Renaming Registered TAbles

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

Renaming Registered TAbles

Hi Community,

 

I've tables registered using ODBC Library and I renamed those registered tables. When I schedule the Data Query which uses the renamed tables. Does they get updated or because I renamed it'll give me an error.

Kindly clarify this doubt.

 

Kind Regards,

Balraj P


Accepted Solutions
Solution
‎05-09-2016 03:11 AM
Super User
Posts: 5,434

Re: Renaming Registered TAbles

If you just renamed the metadata name (not the physical name in metadata) it should work.

But why do you ask? If you already renamed them, just try...?

Data never sleeps

View solution in original post


All Replies
Super User
Posts: 5,434

Re: Renaming Registered TAbles

Please describe the steps in much more detail.
What is Data Query, in what tool are you?

Generally, renaming in metadata doesn't automatically renames physical data, and vice versa.
Data never sleeps
Frequent Contributor
Posts: 80

Re: Renaming Registered TAbles

Hi @LinusH,

I'm using SAS VA,

1. In SMC I've imported tables using ODBC server and registered them. I've renamed the Imported tables as per my convinience.

2. In SAS VA Databuilder, I've used the renamed tables to build my Data Query and scheduled it.

3. When scheduler runs it fetches data from DB.

will the data imported by the scheduler updates the renamed tables or not is my question?

 

Kind Regards

Balraj P

Solution
‎05-09-2016 03:11 AM
Super User
Posts: 5,434

Re: Renaming Registered TAbles

If you just renamed the metadata name (not the physical name in metadata) it should work.

But why do you ask? If you already renamed them, just try...?

Data never sleeps
Frequent Contributor
Posts: 80

Re: Renaming Registered TAbles

[ Edited ]

Yeah did that It's working. Smiley Happy forgot to post here.. Thank you so much Smiley Happy

☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 324 views
  • 2 likes
  • 2 in conversation