A table-valued object can be a table, a view, a function, a synonym, or a local table.
表值对象可以是表、视图、函数、同义词或本地表。
In the example above, we are joining two nicknames and this local table containing an XML column.
在上例中,我们连接了两个昵称和一个包含xml列的本地表。
RAD Version 6.0 supports mapping a local table -- as well as a read-only table (in the data server view) -- to an EJB.
RAD 6.0版本支持映射一个本地表--也就是一个只读表(在数据服务器视图中)--到一个EJB 。
Specifying the nickname, the remote table can be queried in SQL statements on the target database like any other local table.
指定了别名,就可以在目标数据库中用sql语句查询远程表,就像查询任何本地表一样。
You can now reference the nickname in your application as if it were a local table, and they will appear to clients as DB2 tables.
您现在可以在应用程序中引用昵称,就像它是本地表一样,它们将对客户端显示为db2表。
The target server converts the row data from the master dictionary format to the local table dictionary format before applying the data.
目标服务器在应用数据之前,将行数据从主字典格式转换为本地表字典格式。
Since MQTs are local tables that cache the results of a query, the same considerations for creating an index on a local table apply to creating indexes on MQTs.
因为MQT是缓存查询结果的本地表,所以在本地表上创建索引的相同步骤也可应用于在 MQT 上创建索引。
Similarly, before applying replication data, a target server first converts replication data that is in mastered dictionary format to the local table dictionary format.
类似地,在应用复制数据之前,目标服务器首先将主字典格式的复制数据转换为本地表字典格式。
By calling AirportMapping.iata , you are free to change the datasource from a local table to the remote GeoNames service while preserving the client-side interface.
而通过调用AirportMapping . iata,则就可以随意更改本地表和远程GeoNames服务中的数据源,并保证客户端界面不受影响。
Before putting replication data into the send queue, the source server first converts the data from the local table dictionary format to the master replicate dictionary format.
在将复制数据放入到发送队列之前,源服务器首先将数据从本地表字典格式转换为主复制字典格式。
In order to ensure that the global warehouse maintains a backup list of the customers with bad credit or bankruptcy records, the warehouse credit officer creates a local table named BAD_CUSTOMERS.
为了确保全球仓库维护一份有不良信用或破产记录的客户名单,仓库信用调查分析人员创建一个名为BAD_CUSTOMERS的本地表。
The registration of nicknames provides location transparency, since a nickname looks just like a local DB2 table to the users on the federated server.
昵称的注册提供了位置透明性,因为昵称对于联邦服务器上的用户来说看上去就像一个本地db2表。
Predicates are reordered and regrouped based on the kind of predicate (local or join) and the table reference.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
The makeovers began after a local resident put a sofa and table inside the bus stop, but over the years extra facilities have been added - including an Amstrad computer and a microwave.
一开始是因为一个当地居民在里面放了张沙发和桌子,然后这个小公交车站就逐渐被武装起来,后来连电脑与微波炉都有了。
Q: Can the local index partition and data partition be in the same table space for each partition?
Q:每个分区的本地索引分区和数据分区能否处于同一表空间中?
Customize the formatting ordering of the predicates according to various criteria such as local predicates or join predicates, and table references.
根据各种标准,如本地谓词或连接谓词,以及表引用来定制谓词的格式化顺序。
The replication target (on the local system) would be a real table, so the trigger-based mechanism outlined in this article would work.
复制目标(在本地系统上)是一个真正的表,所以本文中描述的基于触发器的机制是可行的。
Any indexes on the table being attached that match the existing local indexes on the partitioned table can be utilized.
已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。
The NAT router translates the inside global address of the packet to the inside local address and then checks the routing table before it sends it to the destination computer.
NAT路由器将这个数据包中的内部全局地址 (即其目的地址,译者)转换成内部本地地址后再查看路由表。
Another potential problem is the local predicate on the table reference CUST_ORDER_HEADER (COHE) in the inner sub-query (see also in Figure 9).
另一个潜在问题是内部子查询中CUST_ORDER_HEADER (COHE)表引用上的本地谓词(见图9)。
In other words, the optimizer overestimated the selectivity of the local predicates on the table.
换句话说,优化器过高估计了本地谓词对表格的选择性。
The following example demonstrates the table space specification for local and global indexes on the table.
以下例子演示了用于表的本地和全局索引表空间规范。
Q: Why can't I specify a table space for my local index using the CREATE index statement?
Q:为什么我无法利用CREATEindex语句为我的本地索引指定表空间?
The number associated with QUALIFIED_ROWS represents the estimated number of records that would qualify all the local predicates of the underlying table reference.
与 QUALIFIED_ROWS相关的数代表将使基础表引用的所有本地谓词合格的估计的记录数量。
The best practice to speed up data roll-in is to ensure that, prior to roll-in, the table being attached has indexes that exactly match all local indexes on the partitioned table.
加速数据滚入的最佳实践是,确保在滚入之前,附加表已具有与已分区表上所有本地索引精确匹配的索引。
We walked over to some local food place, and sat outside on plastic chairs, several beers quickly appearing on the table.
我们来到了当地的路边摊,坐在外面的塑料椅子上,很快便上来了几瓶啤酒。
The first statement within the stored procedure is a DELETE to remove the existing rows in the local destination table SALES.
存储过程中的第一个语句是DELETE,它删除本地目标表 SALES 中现有的行。
QUALIFIED_ROWS (see number 2 in Figure 5) : number of qualified rows after applying local predicates on the table.
QUALIFIED_ROWS(见图5中2):对表应用本地谓词后符合条件的行数目。
These orders, in the form of XML documents, are routed to the global warehouse, while customer information is maintained in a local database table called CUSTOMERS.
这些XML文档格式的订单被路由到全球仓库,而客户信息是在一个名为CUSTOMERS的本地数据库中维护的。
Nickname - the nickname is a local alias for the remote table in the source database.
别名-别名是源数据库中的远程表的本地别名。
应用推荐