政府成立了第二个这样的机构——他们给它起了个带有昵称的男孩名字——叫做房地美。
The government created a second such institution called—and they gave it a boy's name with a nickname—Freddie Mac.
我们还将给出一个使用昵称的示例。
从一个引用昵称的游标装载数据。
从引用昵称的查询中导出数据。
库存信息则来自两个关系昵称的连接。
The inventory information comes from a join of two relational nicknames.
对昵称的数据移动操作。
MQT 优于昵称的限制
在联邦服务器上,不会建立代表该昵称的物理索引。
No physical index is built at the federated server on behalf of this nickname.
注意,该视图是以两个昵称的联合为基础的。
联邦过程与昵称的相似之处是它们允许访问远程存储过程。
Federated procedures are similar to nicknames in that they allow access to remote stored procedures.
SP _ TABS是我们要创建的昵称的名称。
表和视图之类的远程对象在联邦服务器上以昵称的形式注册。
Remote objects such as tables and views are registered on the federated server as nicknames.
SYB_VIPER是我们所要创建的昵称的模式。
但是,只涉及昵称的查询获得那样的异步性的机会却非常有限2。
But queries that involve only nicknames have only very limited opportunities for such asynchrony 2.
MQT必须从根昵称到这个子昵称引用昵称的整个层次结构。
The MQT must reference the whole hierarchy of nicknames from the root nickname to that child nickname.
另一个例子是XML昵称的限制,即不能为子xml昵称创建MQT。
Another example is the restriction for XML nicknames that a MQT cannot be created for a child XML nickname.
然而,这样做也将删除其他的数据库对象,例如依赖于这个昵称的索引。
However, doing so would also drop other database objects, such as indexes that depend on this nickname.
下面给出了更新统计信息的两种方法——不删除依赖于昵称的对象。
Two ways to update statistics — without dropping of objects dependent on the nickname — are outlined below.
在关系昵称的注册步骤中,包装器模块试图获取底层对象的远程编目信息。
During the registration step for relational nicknames, the wrapper modules try to retrieve remote catalog information for the underlying object.
UNIONALL视图上的初始查询现在被简化为对一个昵称的查询。
The original query against the UNION ALL view is now simplified to a query against one single nickname.
为了阅读或修改远程数据源中的数据,您提交引用了昵称的SQL查询给联邦DB 2服务器。
To read or modify data from remote data sources, you submit SQL queries that reference nicknames to the federated DB2 server.
下面是在不使用ControlCenter的情况下为现有表创建昵称的命令。
Here is the command to create the nickname for the existing table if the Control Center is not used.
Sybase现有表j 15user1 . sp _ tabs的昵称的列属性。
Column attributes of the nickname for the Sybase existing table j15user1.sp_tabs.
维冈并不是唯一一个以竞技者为昵称的球队。一级联赛的奥尔·德姆竞技队同样以此为昵称。
Wigan are not on their own with this nickname with League 1 side Oldham Athletic also claiming it.
然而,有些查询本身可能是潜在的更新目标(例如只引用最外面的SELECT上的一个昵称的查询)。
However, some queries might present themselves as potential update targets (such as a query referencing only one nickname on the outermost SELECT).
昵称的注册提供了位置透明性,因为昵称对于联邦服务器上的用户来说看上去就像一个本地db2表。
The registration of nicknames provides location transparency, since a nickname looks just like a local DB2 table to the users on the federated server.
在DPF(分区的)系统中,某些只涉及昵称的查询可使用那些采用计算分区组的访问计划来执行。
Some nickname-only queries in DPF (partitioned) systems may be executed using access plans that make use of computational partition groups.
如果远程视图包含一个复杂的查询,那么使用表级统计信息(例如视图昵称的基数)可能使人产生误解。
If the remote view contains a complex query, using table-level statistics such as the cardinality for the nickname over the view can be misleading.
ControlCenter中的缓存表功能,它使您可以使用复制作为刷新机制来建立昵称的本地缓存。
The cache table facility in the Control Center, which lets you set up local caches of nicknames using replication as the refresh mechanism.
NNSTAT的标签中有一些新的参数,其中一个参数允许用户控制用于获取或刷新一个或一组特定昵称的方法。
One of several new arguments in NNSTAT's signature allows the user to control the method to be used in obtaining or refreshing statistics for a particular nickname or set of nicknames.
应用推荐