A Query view allows you to show DB2 data within a Notes view.
查询视图允许在Notes视图中显示DB 2数据。
If you hover your mouse over the icon, it tells you that the view is a DB2 Query view.
如果将鼠标置于图标上,系统将提示该视图为DB 2查询视图。
For this example, the Query view will use a similar format to the All Documents view in Discussion.
对于本示例,查询视图将使用与Discussion中的AllDocuments视图相似的格式。
This is one of the ways we can get data from multiple NSFs, or even other tables, into a Query View.
这是可以从多个NSF甚至其他表选取数据到查询视图的一种方式。
A query view is dynamic, and the SQL query will be re-executed every time the Domino view is refreshed (see figure 2).
查询视图是动态的,每当Domino视图刷新时将重新执行SQL查询(参见图2)。
A query view USES a formula that evaluates to an SQL query to populate its data, instead of using a view selection formula.
查询视图使用SQL查询公式来填充数据,而不是使用视图选择公式。
Existing views cannot be converted into Query views; you must specify that a view is a Query view at the time the view is created.
不能将现有的视图转换为查询视图;必须在创建视图的时候指定该视图为查询视图。
A DB2 query view USES an SQL query to populate its data instead of a view formula that selects documents from within the NSF file.
DB 2Query视图使用SQL查询而不是视图公式来填充数据,SQL查询从nsf文件内选择文档。
When you edit the SQL Query View in Domino Designer, a new event, SQL Query, appears in the programmer's pane, as shown in figure 11.
当在DominoDesigner中编辑SQL查询视图时,一个新的事件(SQLQuery)将出现在编程窗格中,如图11所示。
For example, we created a query view based on the All Documents view in the discussion database. These are the fields that we wrote down.
例如,我们基于discussion数据库中的AllDocuments视图创建了一个查询视图。
A Query view can also join data from multiple DB2 tables and views, allowing you to join data from two NSF files indirectly by joining two separate DB2 Access views.
Query视图还可以联合多个db2表和视图中的数据,允许通过连接两个单独的DB 2Access视图,间接地联合两个NSF文件中的数据。
Under the Work Items folder, open the Shared Queries and Predefined folders and double-click the open assigned to me query. This will open the query view shown in Figure 41.
在WorkItems文件夹下,打开SharedQueries和Predefined文件夹然后双击openassignedtome查询,这将会打开图41显示的查询视图。
XML tasks: create and maintain tables and views with XML data; create and tune XML indexes; query and view XML documents; store and manage XML schema documents.
XML任务:创建并维护具有XML数据的表和视图;创建并调优xML索引;查询并查看XML文档;存储并管理XML模式文档。
Of course, you cannot explicitly create or drop these system catalog tables, but you can query and view their content.
当然,不能显式地创建或删除这些系统编目表,但是可以查询和显示这些表的内容。
XML: Create and manage XML database objects, and query and view XML data.
XML:创建并管理XML数据库对象,以及查询并查看XML数据。
Even choosing only a subset of the columns from the view would be a simple SQL query.
即使是只从视图中选择列的一个子集,也能用一个简单的SQL查询实现。
Using the same sample data just discussed above, the following illustrates the difference in cardinality estimates with and without the use of statistical view for the query.
下面使用以上讨论的相同的示例数据,阐释在使用和不使用查询的统计视图的情况下基数估计的差别。
You can query this view to obtain a dependency summary for the MQTs that we have created (Listing 5).
您可以查询这个视图,获得对我们创建的MQT(清单5)的依赖关系的总结。
Exposing the relational columns helps to query this view efficiently.
暴露关系列有助于有效地查询这个视图。
You can make the SQL query on the predefined BPC database view.
您可以在预定义的BPC数据库视图上执行SQL查询。
The data federation server is responsible for receiving a query directed at an integrated view of diverse sources.
数据联合服务器负责接收定向到各种源的集成视图的查询。
The original query against the UNION ALL view is now simplified to a query against one single nickname.
UNIONALL视图上的初始查询现在被简化为对一个昵称的查询。
The above query is an alternative to the query with XMLTABLE used to define the view.
上面的查询可以代替使用XMLTABLE定义视图的查询。
All the user needs is a web browser, for example Internet Explorer, Safari, Firefox, or Chrome, to upload, download, query and view the models.
用户只需网络浏览器,例如IE,Safari,Firefox或Chrome,就可以对模型进行上传,下载,查询以及查看了。
To determine if asynchrony was enabled within a federated query, view the access plan of the query using db2exfmt,Visual Explain or a tool of your choice.
要确定一个联邦查询中是否启用了异步,可以使用db2exfmt、VisualExplain或您选择的其他工具来查看查询的访问计划。
You can select the costliest query, and you can launch Optim Query Tuner directly from that view.
您可以选择成本最低的查询,并可以从那个视图直接启动OptimQueryTuner。
Using standard Cognos features, you can create a more sophisticated query over this view that filters out specific columns and rows of data, as desired.
可以使用标准的Cognos特性创建更复杂的查询,根据需要过滤掉某些列或行。
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.
如果远程视图包含一个复杂的查询,那么使用表级统计信息(例如视图昵称的基数)可能使人产生误解。
Defining a nickname over a remote view is useful in cases where you want to push down the query defining the remote view to the data source.
如果您想将定义远程视图的查询下推到数据源,那么定义远程视图的昵称会比较有用。
You can either call the function directly, or create a view based on this statement and then query the view.
可以直接调用此函数,也可以根据这个语句创建视图,然后查询视图。
应用推荐