远程表被删除。
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.
可以定义远程视图的昵称,就像定义远程表的昵称一样。
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数据库中,那么我们将简单地为我们数据库中的这个远程表创建一个别名。
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.
创建“现有表”时,首先会创建一个代理表,然后检索和存储远程表中的元数据,并将该元数据放入到这个代理表中。
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.
如果为一个昵称收集了统计信息,那么在数据源上对相应远程表的远程统计信息进行更新时,这些统计信息不会自动更新。
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.
如果为一个昵称收集了统计信息,那么在数据源上对相应远程表的远程统计信息进行更新时,这些统计信息不会自动更新。
应用推荐