Netezza ODBC connection - equivalent of "use database"
netezza
Solution
Prior to `Version 7.0` there wasn't an equivalent to `USE`. You had to log in to specific databases on the server however you can still access any object using. `database.schema.objectname`
Post `Version 7.0` the equivalent is `Set Catalog`
SET CATALOG <database_name>
Regarding your specific inquiry. Please consider using `_V_TABLE_XDB` instead of `_V_TABLE`. This system table should provide you with a list of all tables, not just those in the database you are connected to.
Problem
After connecting to a Netezza system is there any way to switch the database? For instance, in MSSQL one could send the command `use database_name` in order to switch to the database_name. Is there anything in Netezza like "use" on mssql? http://technet.microsoft.com/en-us/library/ms188366.aspx My reason for asking is in regards to metadata queries; I can only access _v_table of the "currently connected database".