A better solution is to define a nickname over each remote table, and to define views over these nicknames on the federated server if necessary.
更好的解决办法是定义每个远程表的昵称,必要的时候在联邦服务器上定义这些昵称上的视图。
This statement creates both a remote table on the data source, referred to by the server name CREDIT_SERVER, as well as a nickname referring to this new remote table.
该语句在被称作CREDIT_SERVER的远程数据源上创建一个远程表,同时创建一个引用这个新的远程表的昵称。
The query on the remote Asia.Sales table will begin when the one on the middle leg is complete and has delivered its entire result set to the federated server.
当中间那条查询执行完毕并且已经将整个结果集提交给联邦服务器时,才开始执行对远程表 Asia.Sales 的查询。
In WebSphere Federation Server Version 9.1, a nickname cannot be created over a remote table or view that contains an XML-type column.
在WebSphereFederationServer 9.1内,昵称不能在包含xml类型列的远程表或视图之上创建。
This is a hash join between the CUSTOMERS table, local to the federated server, and the BAD_CREDIT nickname that references a remote Oracle table.
这是表CUSTOMERS与昵称BAD_CREDIT之间的一个散列连接(hash join),前者在联邦服务器本地,后者引用一个远程oracle表。
The CREATE REMOTE SERVER statement stores the login data for the back-end server in the SYS_SERVER table.
CREATEREMOTE SERVER语句在 SYS_SERVER表中存储后端服务器的登录数据。
The REVIEW table exists on the SQL Server 2005. Its XML data is serialized into a BLOB using the following remote view.
表review位于SQLServer 2005上,其XML数据通过如下所示的远程视图序列化进blob。
The REVIEW table exists on the SQL Server 2005. Its XML data is serialized into a BLOB using the following remote view.
表review位于SQLServer 2005上,其XML数据通过如下所示的远程视图序列化进blob。
应用推荐