您表中的每行可能有列数据,也可能有子节点。
Just think of each row in your table as potentially having column data, as well as optionally having child nodes.
如上所述,此业务对象将映射到数据库中的列数据值。
As I stated earlier, this business object will map to column data values in our database.
单元格的内容是由XML中行和列数据相交生成的。
The content of cells is created by intersecting items from the XML's data sets for rows and columns. Only cells that have data are part of the XML.
还可以将变量类型改为与其映射的列数据的类型不相同的类型。
Optionally you can also change the variable type name to be different than its mapping columns data type.
列数据类型是根据过程的DB 2平台预先填写的,以便于选择。
Column data types are pre-filled based on the DB2 platform for the procedure for easy selection.
当您想要在滚动或查看其他列数据时冻结一个或一组列时将会很有用。
Column locking is useful for when you want to freeze a column or collection of columns while scrolling and reviewing data in the other columns.
num_quantiles数据库配置参数指定应将列数据值分成的组数。
The num_quantiles database configuration parameter specifies the number of sections into which the column data values should be grouped.
例如,您可以将源系统上较小的列数据长度复制为目标系统上较大的数据长度。
For example, you can replicate from small column data lengths at the source to larger data lengths at the target.
若选择一列,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.
始终匹配DB 2列数据类型与应用程序变量数据类型或JDBCset方法。
Always match the DB2 column data type to the application variable data type, or the JDBC set method.
首先,确保已经针对列数据类型使用恰当的setxxx方法将数据绑定到参数标记。
First, ensure the data is bound to parameter markers using the correct setxxx method for the column data-type.
在上面的查询中,必须构造外层的Customer元素并添加来自custxml列数据的属性。
In the above query, you had to construct the outer Customer element and add the attributes from the CUSTXML column data.
通过ALTERNICKNAME语句,您可以选择为远程对象更改联邦服务器上的列数据类型。
With the ALTER NICKNAME statement, you have the option to change the column data type on the federated server for a remote object.
监控和调优数据库配置参数,这部分按照重要性的顺序描述了一列数据库管理器参数和数据库参数。
Monitoring and tuning database configuration parameters, which describes a list of database manager parameters and database parameters in the order of importance.
在这些属性中,rows尤其方便,因为您可以使用它来在整个结果集中进行迭代和根据名字访问列数据。
Of these properties, rows is particularly convenient, because you can use it to iterate through the result set and access the column data by name.
他们采用这种格式,平均减少了20%的存储需求,同时可以达到更好的性能(按需延迟对列数据的解压)。
They have adopted this format and are seeing reduced storage requirements of about 20% on average and they can achieve improved performance by using it (by lazily decompressing columns as needed).
DB 2对其涉及传统关系数据和xml列数据的常用服务进行了扩展,例如优化、索引、并行控制和实用工具。
DB2 extends its common services, such as optimization, indexing, concurrency control, and utilities, across the traditional relational and XML column data.
如果编目中没有列数据值分布信息,DB 2就会假设值是均匀分布的,这可能导致优化器选择非最优的访问路径。
Without column data-value distribution information in the catalog, DB2 will assume an even distribution of values, which may lead the optimizer to a sub-optimal access path.
在平台允许更改列数据类型的情况下,可用的数据类型预先填写有该平台的有效兼容数据类型,使类型选择更为容易。
In cases where the platform allows altering the column data type, the list of data types available is pre-filled with the valid compatible data types for that platform, making the type selection easy.
如果需要在修改列数据类型期间对数据库执行写访问,可以使用下一小节描述的ADMIN_MOVE_TABLE例程。
If you need to have write access to the database available while column data type is changed, you can use of ADMIN_MOVE_TABLE routine described in the next section.
在获取XML数据时,应用程序也获取那个列数据以便识别XML schema,并基于该schema处理XML数据。
When getting XML data, the application also gets the column data for identifying the XML schema, and processes the XML data based on it.
一些错误看起来是无心之失——庞大的电子数据表中错移的一行或一列数据;还有一些无法解释的错误,杜克的团队轻描淡写地解释为“笔误”。
Some seemed careless — moving a row or a column over by one in a giant spreadsheet — while others seemed inexplicable. The Duke team shrugged them off as “clerical errors.”
对于应用程序,加载一个包含雇员数据的简单表;该表将支持对其任何列进行排序。
For the application, load a simple table with employee data; the table will support sorting on any of its columns.
生成具有相关列的数据。
列可用于分类数据。
如果是,那么使用输入参数值更改相应的数据列。
If so, then the corresponding data column is changed with the input parameter value.
函数索引对列中的数据进行转换并按照顺序保存转换后的值。
A functional index transforms the data in a column and stores the derived values in sorted order.
verify选项检验主节点和当前在被实现的节点之间的表、列、数据类型,等等。
The --verify option verifies the tables, columns, data types, and so forth between the master node and the node on which the template is being realized.
还可以将变量类型改为与它所映射的列的数据类型不同的类型(见图17)。
Optionally you can also change the variable type name to be different than its mapping columns data type (See Figure 17).
这样设计,参与索引的表和列的数据不得不从SQLServer运送到全文检索服务。
With this design, data from tables and columns to be indexed have to be shipped from SQL Server to the Full Text Search service.
应用推荐