topic Re: Renaming Registered TAbles in Administration and Deployment

Renaming Registered TAbles

balraj — Fri, 06 May 2016 08:10:10 GMT

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

Re: Renaming Registered TAbles

LinusH — Sat, 07 May 2016 15:07:07 GMT

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.

Re: Renaming Registered TAbles

balraj — Mon, 09 May 2016 04:25:57 GMT

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

Re: Renaming Registered TAbles

LinusH — Mon, 09 May 2016 07:06:40 GMT

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...?

Re: Renaming Registered TAbles

balraj — Mon, 09 May 2016 07:14:06 GMT

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