Cross Server Joins

• Remote servers

  CREATE SERVER NTSERV
  
  CLASS 'asaodbc' USING 'NTSERV';

• External logins

  CREATE EXTERNLOGIN NTSERV_DBA TO NTSERV
  
  REMOTE LOGIN DBA IDENTIFIED BY SQL;

• Proxy tables

  CREATE EXISTING TABLE
  
  NTSERV_sales_order_items
  AT 'NTSERV;;DBA;sales_order_items';

Previous slide

Next slide

Back to first slide

View graphic version

The CREATE SERVER names a server "NTSERV" of connection type "ASA ODBC" using the ODBC DSN called "NTSERV". The CREATE EXTERNLOGIN names a local user id NTSERV_DBA as being equivalent to DBA/SQL on the server called NTSERV. This user id will only be used by ASA behind the scenes to make a connection to the other server NTSERV. The CREATE EXISTING TABLE uses the definition of DBA.sales_order_items on the server NTSERV to define a local proxy or template table called NTSERV_sales_order_items. These three commands are all that's required to make a table on another server visible to this one.