Netezza Cross Database Access and its Restrictions

Netezza cross database access does allows you to execute the objects such as tables, view, synonyms that are available on the same Netezza server. You can can INSERT, UPDATE or DELETE data from current database by referring objects in other database on same server. For example, TRAINING1.ADMIN(ADMIN)=>SELECT * FROM TRAINING1..TEST1; Read: Access Netezza Database, Tools and Examples Netezza nzsql Command and its Usage Netezza Synonym Best Practices and Examples Referencing Database Object from other Database To access objects in other databases on the same Netezza system, you must use three-level…

Continue ReadingNetezza Cross Database Access and its Restrictions
Comments Off on Netezza Cross Database Access and its Restrictions

Netezza Synonyms Best Practices and Examples

Netezza synonyms allow you to create easily typed names (you can remember and type easily) for long table, view names, or any other objects. You can create SQL synonyms as an alternate way of referencing tables or views that present in the current or other databases on the Netezza same system. Netezza Synonyms allow you to create another level of abstraction for the database objects (tables, views) and that allows and enable you to swap the underlying database objects without modifying the code that references these objects. You can even…

Continue ReadingNetezza Synonyms Best Practices and Examples
2 Comments