Examples

Restriction: This topic applies to Windows environments only.

Client1 is logged into the XDB Server xdbserve and is running the SQL Wizard (Windows) or Interactive SQL (UNIX). Client1 issues a SELECT command that references the table orders.eastern.may.

This request is received by the XDB Server xdbserve. The xdbserve server checks its system catalog table SYSIBM.SYSLOCATIONS. This table indicates that the location orders is controlled by the XDB Server sales.

The request is then passed on to the XDB Server sales, which processes the query. The query result is returned to xdbserve, which passes the data back to the SQL Wizard (Windows) or Interactive SQL (UNIX) on client1.

Now consider that, in the next SQL statement issued, client1 references products.gui.productlist. Again, the same system catalog tables on xdbserve are checked.

This time, the request is sent to the XDB Server, develop.