远程表被删除。
Creating a remote table from the federated system.
从联邦系统上创建远程表。
Internally, a shadow nickname is created on the remote table.
在内部，会创建远程表上的一个影子昵称。
No table is an external table, remote table, view, or derived table.
没有外部表、远程表、视图或派生表。
Invalid table - The remote table, view, or data set has been dropped.
无效表——远程表、视图或数据集被删除。
Nickname - the nickname is a local alias for the remote table in the source database.
别名-别名是源数据库中的远程表的本地别名。
A nickname can be defined over a remote view just as it can be defined over a remote table.
可以定义远程视图的昵称，就像定义远程表的昵称一样。
Therefore, it is very important for the remote table definition to include column nullability.
因此，远程表的定义允许列可以为空这一点非常重要。
Defining indexes on the remote table on the data store might sometimes improve query performance.
在数据源上的远程表上定义索引有时候可以提高查询性能。
The number of distinct values, and the maximum and minimum values of each column of a remote table
远程表中每个列中不同值的个数、最大值和最小值
First a cursor is defined that reads all rows in the remote table using the nickname created above.
首先，定义一个游标，它使用上面创建的别名读取远程表中的所有行。
Click on Add, and fill in the remote schema (public) and remote table name (DELIM1), then click on OK when finished.
单击add，然后填充远程模式(public)和远程表名(DELIM1)，完成之后单击ok。
Specifying the nickname, the remote table can be queried in SQL statements on the target database like any other local table.
指定了别名，就可以在目标数据库中用sql语句查询远程表，就像查询任何本地表一样。
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类型列的远程表或视图之上创建。
If the relational data resided in a remote DB2 or OEM database, we would simply create a nickname for this remote table in our database.
如果关系数据驻留在远程DB 2或OEM数据库中，那么我们将简单地为我们数据库中的这个远程表创建一个别名。
The most significant of the newly-retrieved nickname statistics are the minimum and maximum values stored in each column of a remote table 1.
新获取的昵称统计信息中，最重要的是存储在远程表的每个列中的最小值和最大值1 。
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.
更好的解决办法是定义每个远程表的昵称，必要的时候在联邦服务器上定义这些昵称上的视图。
Creating an "existing table" creates a proxy table, then retrieves and stores metadata from a remote table and places the metadata into the proxy table.
创建“现有表”时，首先会创建一个代理表，然后检索和存储远程表中的元数据，并将该元数据放入到这个代理表中。
Given the remote table definitions for items and suppliers, you can declare check constraints on the corresponding nicknames with the following commands.
给items和suppliers的定远程表定义，便可以用以下语句声明相应昵称上的检查约束。
In an application, a nickname brings back data from a remote table, view, or date set. However, the following conditions will cause such an application to fail.
在应用程序中，别名可以从远程表、视图或数据集中取回数据。
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的远程数据源上创建一个远程表，同时创建一个引用这个新的远程表的昵称。
Once the statistics are gathered for a nickname, they are not automatically modified when the remote statistics are updated on the data source for the corresponding remote table.
如果为一个昵称收集了统计信息，那么在数据源上对相应远程表的远程统计信息进行更新时，这些统计信息不会自动更新。
Please note that this table is accurate as of the time of publication, but that work to discover and collect more remote statistics is ongoing.
记住，在本文发表之际，这个表还是准确的，但是发现和收集更多远程统计信息的工作还在继续。
After this information is added successfully, the remote machine will be listed in the location table (Figure 23).
在这些信息被成功添加之后，远程机器将在位置表中被列出，如图23所示。
A nickname is a representation of a table, view, or any other form of data set residing on the remote data source.
别名是远程数据源上驻留的数据集的表、视图或任何其他形式的数据的表示。
Assume that there is a LINEITEM fact table on one remote source and a PART dimension table on another.
假设在一个远程数据源上有一个lineitem事实表，在另一个远程数据源上有一个part维表。
Table 1 provides an overview of contributors and contributed data for caching in remote caches.
表1提供了关于提供者及其提供的数据(供在远程缓存中进行缓存时使用)的概述。
Data modeling: a wrapper is responsible for mapping the data representation of remote query results into the table format as required by the federated engine.
数据建模：包装器负责将远程查询结果的数据表示映射为联邦引擎所要求的表格式。
That means these steps can generally be used to create a nickname for a table in a remote database.
这意味着这些是为远程数据库中的表创建别名的通用步骤。
The CREATE REMOTE SERVER statement stores the login data for the back-end server in the SYS_SERVER table.
CREATEREMOTESERVER语句在 SYS_SERVER表中存储后端服务器的登录数据。
应用推荐