You can now reference the nickname in your application as if it were a local table.
你现在可以在你的应用程序中引用这个昵称,就像它是一个本地表一样。
When I call or invoke a function, think of it as creating a local table.
当我调用一个函数时,想象一下它是在这里创建了一个局部表。
He USES a distributed query to load information into this local table.
他使用一个分布式查询将信息装载到这个本地表。
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 table in the kitchen was made by a local craftsman.
厨房里的桌子是当地一名工匠做的。
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.
重新排序和重新组合谓词是基于谓词的种类(本地或联接)和表引用。
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.
已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。
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.
换句话说,优化器过高估计了本地谓词对表格的选择性。
Local indexes are partitioned in the same way as the table they are based on.
如同其所基于的表一样,本地索引也进行了分区。
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.
加速数据滚入的最佳实践是,确保在滚入之前,附加表已具有与已分区表上所有本地索引精确匹配的索引。
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的本地数据库中维护的。
应用推荐