在右边,选择状态数据集然后选择STATE列。
On the right side, select the state data set and then select the STATE 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.
列集/散集(marhaling/unmarshaling)原始大型机数据所需要的消息转换动作是由LegStart在设计时产生的,其细节将在下一节中描述。
The transformation actions that are needed to marshal/unmarshal raw mainframe data are generated by LegStar at design time as described in the next section.
在数据类型结果集上进行迭代并输出type_name列。
Iterate over the data type result set and output the TYPE_NAME column.
如果sybase现有表定义没有为存储过程结果集的某一列指定适当的数据类型,就可能发生上述错误。
The above error can occur if the Sybase existing table definition did not specify the appropriate data type for a column of the stored procedure's result set.
清单3 .包括新计算列的工作项数据集。
Listing 3.the work items data set including the new computed column.
最后一个select语句展示了包含原始数据集的 stock_num列。
The final select statement shows the stock_num column with the original set of data.
在Selectcolumns之下,选择列以显示数据集的输出。
Under select columns, select the columns to show in the output of the data set.
要为Column数据集创建一个新的列映射。
To create a new column mapping for the column data set, complete the following steps.
换句话说,报表由一个表组成,这个表的行数和数据集的记录数相同,而列数与细节区域中定义的元素数相同。
In other word, the report consists of a table with as many rows as records in the dataset and as many columns as elements defined in the detail band.
这些结果集并不是BIRT的数据集,但却包含了数据容器中绑定的列,而该数据容器中的数据则来自于一个数据集。
These result sets are not BIRT data sets, but contain the bound columns from the data container, which are usually retrieved from a data set.
让数据集跨越不同的服务器需要在应用程序层做大量工作,比如跨两个数据库联结列并确保数据是一致的。
To split your dataset across different servers requires a lot of work at the application level, such as joining columns across two databases and making sure data is consistent.
本文讨论了如何构建一个测试数据集,以使该数据集达到用于测试的规模,并且具有期望的值分布和列间相关性。
This article discusses how to make up a test data set so that it is large enough to be useful for testing and has the expected distribution of values and correlation between columns.
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.
在创建联邦过程时,使用默认的转发类型映射将远程过程参数和结果集的列的数据类型映射为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.
索引也是一种DB 2对象(一个单独的VSAM数据集),它由一组排好序的键组成,这些键是从相应表中的一个列或多个列抽取出来的。
An index is a DB2 object (a separate VSAM dataset) that is comprised of an ordered set of keys extracted from one or more columns of the corresponding table.
类似于SQL的语言要求返回列集(元组),与SQL相同,但是对象数据库不会以这种方式工作——它希望返回对象,而不是随机集。
A language so similar to SQL would seem to want to return column sets (tuples), like SQL does, but an object database doesn't work that way — it wants to return objects, not arbitrary sets.
创建一个列出工作项的数据集,包括state_name列。
Create a data set that lists work items, including the STATE_NAME column.
第一列是已标注的规则编号,第二列是为示例数据集触发规则的次数。
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.
然而,XMLTable还包括一些子句,用于将目标XML数据映射到SQL数据类型的结果集列。
However, XMLTable also includes clauses to map the target XML data into result set columns of SQL data types.
例如,如果一个数据集具有一个叫做firstname的列,还有一个叫做last name的列,那么你可以利用表达式构建器将二者连接起来组成一个新的数据元素。
For example, if a data set contains a column for first name and another for last name, using the expression builder you can concatenate the values into one data element.
若选择一列,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.
例如,以下语句产生类似于上述结果的结果集,不同的是“Message ”数据被包含在一个xml列中,而不是包含在一个SQL varchar列中。
For example, the following statement produces a result set similar to the previous one, except that "Message" data is contained in an XML column rather than an SQL VARCHAR column.
XPath语言是用来快速查询每个UML模型数据集的行和直列的。
The XPath language is used to express queries for both the rows and columns of each UML model data set.
向名为“STATEID”的工作项数据集添加一个计算的列,它将下面区域名字与state_name列联系起来(参见代码清单6)。
Add a computed column to the work items data set named "STATE ID" that concatenates the project area name with the STATE_NAME column (see Listing 6). The value for this column might look like this.
指定用于对结果集进行排序的数据列的排序优先级。
Specifies the sort priority for data columns used to sort the result set.
原因是返回此值使用的逻辑内置于生成的数据集类中特定数据列的属性设置程序。
The reason for this is that the logic to return this value is built into the property setter of the specific data column in the generated dataset class.
数据集对象可以定义和强化表之间的关系和列的约束,确保使用的商业规则对数据库没有缺陷。
Data set object can define the tie that expresses the relation between and kind with aggrandizement, ensure use commercial regulation does not have blemish to the database.
“简单绑定”使您得以在控件中显示单个数据元素,如来自数据集表的列值。
Withsimple binding, you can display a single data element, such as a column value from a dataset table, in a control.
应用推荐