您可以选择将在每次执行该查询时显示(在EclipseUI和Web UI中)的自定义列集。
You can choose a custom set of columns that will be shown every time you execute the query (both in the Eclipse UI and the Web UI).
作者为马林百列集选区前议员。
完美散列函数是一种在时间和空间方面都十分高效的静态搜索集实现。
Perfect hash functions are time- and space-efficient implementations of static search sets.
删除目标表不需要的所有结果集列。
Delete all result set columns except those required by the target table.
应该保留的结果集列是id、holdingtype、symbol和qty,见图8。
The result set columns that should remain are id, holdingtype, symbol, and qty, as shown in Figure 8.
创建具有计算列和参数的数据集。
一个结果集中的所有行具有相同的列数量和列类型,而不同的结果集可以具有不同的列布局。
While all rows in a result set share the same number of columns and column types, different result sets can have different column layouts.
在右边,选择状态数据集然后选择STATE列。
On the right side, select the state data set and then select the STATE column.
若选择一列,Explorer窗口的右侧就会显示数据集内该列数据的信息。
By selecting each column, the right section of the Explorer window will also give you information about the data in that column of your data set.
每个RETURNROW调用向返回的结果集增添一个新行,该结果集中的列值为结果集列名的当前值。
Each return row call adds a new row into the returned result set where column values are the current values of the result set column names.
然而,XMLTable还包括一些子句,用于将目标XML数据映射到SQL数据类型的结果集列。
However, XMLTable also includes clauses to map the target XML data into result set columns of SQL data types.
表1列出了每种DB 2内存集的限制。
Table 1 lists the memory limits for each of the DB2 memory sets.
现有表定义必须指定存储过程第一个结果集的各列的特征。
The existing table definition must specify the characteristics of the columns of the stored procedure’s first result set.
对于单一分组集或多个分组集,分组列的次序是无所谓的;但是对于ROLLUP,列的次序不能随意安排。
While the ordering of the grouping columns does not matter for a single grouping set or multiple grouping sets, the order of the columns does matter for ROLLUP.
这些方法使您的应用程序可以更新单个的列值,或者前后滚动结果集。
These enable your applications to update individual column values, or to scroll through result sets backward or forward.
确认结果集包括输出中的info列(xml列)。
Verify that the result set includes the INFO column (the XML column) in the output.
创建一个列出工作项的数据集,包括state_name列。
Create a data set that lists work items, including the STATE_NAME column.
对于存储过程,您可以将该存储过程的的输入和输出参数映射到select命令中所定义的数据集源列。
For stored procedures, you can map the input and output parameters of the stored procedure to the data set source columns as defined in the select command.
在创建联邦过程时,使用默认的转发类型映射将远程过程参数和结果集的列的数据类型映射为DB2 数据类型。
When the federated procedure is created, the data types of the remote procedure parameters and the columns of the result set are mapped to the DB2 data types using the default forward type mapping.
可能有些情况,您想要对根据特定的列值分割的记录集进行一些计算,但是不希望在报表中打印该列。
There may be scenarios where you would like to do some computations on sets of records broken based on particular column values, but would not like to print that column in the report.
DB 2V9.5去掉了这个限制,并且允许用户用任意代码集创建包含xml列的数据库。
DB2 V9.5 removes this restriction and allows a user to create the database with an XML column in any code set.
第一列是已标注的规则编号,第二列是为示例数据集触发规则的次数。
The first column is the annotated rule number, and the second column is the number of times the rule is fired for the sample dataset.
根据步骤3中获取的结果集,选择其列族affiliations中有一个WorldHealthOrganization成员的行。
From the result set obtained in step 3, select the row whose column family affiliations has a member World Health Organization.
要为Column数据集创建一个新的列映射。
To create a new column mapping for the column data set, complete the following steps.
最后一个select语句展示了包含原始数据集的 stock_num列。
The final select statement shows the stock_num column with the original set of data.
结果集还包含其他一些列,这些信息也很有用。
The result set contains some other columns with helpful information.
本示例最终的结果集显示两个列:fullrecord (XML)和id(整数),如图9 所示。
The final result set in the sample shows two columns: fullrecord (XML) and id (integer), as shown in Figure 9.
此工具在列表视图中显示结果集(如果有的话),每个列代表一个属性。
The tool will display the result set, if any, in a list view where each column represents one attribute.
可在ORDERBY 子句中使用伪列LEVEL按照搜索宽度优先顺序返回结果集。
The pseudo column LEVEL can be used in the ORDER BY clause to return the result set in search breadth first sequence.
如果需要根据某个特定的列值将报表分成多个记录集,那么您可以使用BREAK命令。
If a report needs to be broken into separate sets of records based on a particular column value, then you can use the BREAK command.
应用推荐