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查询公式来填充数据,而不是使用视图选择公式。
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 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甚至其他表选取数据到查询视图的一种方式。
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.
不能将现有的视图转换为查询视图;必须在创建视图的时候指定该视图为查询视图。
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所示。
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文件中的数据。
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或您选择的其他工具来查看查询的访问计划。
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或您选择的其他工具来查看查询的访问计划。
应用推荐