[This topic is migrated from our old forums. The original author name has been removed]
I'm using Netezza and I would like to know if it is possible to change the default database (in our case correspond to schema) by a command.
Our scenario is that we usually have scripts that manipulate tables in one database/schema and then create views in another one.
I found a post from 3 years ago saying it wasn't possible, so I'm just checking it there has been any change.
Alternatively, I wanted to know if from the SQL Commander we could execute some java code to do something like "Connection.setCurrentCatalog"?
almost 5 years ago
[This reply is migrated from our old forums.]
Re: Trying to change Database from SQL Commander
Sorry, but there is still no DbVisualizer client side command for setting the database/catalog. Have you checked if there is a Netezza command for setting it, e.g. ALTER SESSION SET or something similar?
When you execute a script, the Catalog drop-down value is used for a call to Connection.setCatalog(). Does that work as it should with Netezza? If so, we can look into adding a client side command for doing the same. The problem is that it may not work for all databases. There are similar issues with changing the schema for some databases.