As I stated earlier, this business object will map to column data values in our database.
如上所述,此业务对象将映射到数据库中的列数据值。
Second, DB2 9.7 has extended its support for changing column data types on existing tables.
其次,DB2 9.7扩展了它修改已有表中的列数据类型的支持。
Column data types are pre-filled based on the DB2 platform for the procedure for easy selection.
列数据类型是根据过程的DB 2平台预先填写的,以便于选择。
Always match the DB2 column data type to the application variable data type, or the JDBC set method.
始终匹配DB 2列数据类型与应用程序变量数据类型或JDBCset方法。
First, ensure the data is bound to parameter markers using the correct setxxx method for the column data-type.
首先,确保已经针对列数据类型使用恰当的setxxx方法将数据绑定到参数标记。
For example, you can replicate from small column data lengths at the source to larger data lengths at the target.
例如,您可以将源系统上较小的列数据长度复制为目标系统上较大的数据长度。
Just think of each row in your table as potentially having column data, as well as optionally having child nodes.
您表中的每行可能有列数据,也可能有子节点。
In the above query, you had to construct the outer Customer element and add the attributes from the CUSTXML column data.
在上面的查询中,必须构造外层的Customer元素并添加来自custxml列数据的属性。
Sybase: If the source table has a column data type of LONG VARCHAR, the nickname is created with a data type of VARCHAR (32672).
Sybase:如果源表具有数据类型为LONGVARCHAR的列,就要用数据类型VARCHAR(32672)创建别名。
With the ALTER NICKNAME statement, you have the option to change the column data type on the federated server for a remote object.
通过ALTERNICKNAME语句,您可以选择为远程对象更改联邦服务器上的列数据类型。
Although it's easy to create relational views over XML column data, you should consider their use carefully if you are not on V9.7.
虽然在xml列中的数据上创建关系视图很容易,但是用起来要小心。
If you don't specify an index or long table space, partitioned indexes and long column data will go in the same table space as the data.
如果不为索引或长列指定表空间,分区索引和长列数据会存储在与数据相同的表空间中。
When getting XML data, the application also gets the column data for identifying the XML schema, and processes the XML data based on it.
在获取XML数据时,应用程序也获取那个列数据以便识别XMLschema,并基于该schema处理XML数据。
The num_quantiles database configuration parameter specifies the number of sections into which the column data values should be grouped.
num_quantiles数据库配置参数指定应将列数据值分成的组数。
In a table model (Figure 2), a graphical component that enables you to list row and column data, along with scroll bars to provide paging.
在表格模型中(图2),图形化组件使您可以列出行和列的数据,同时有滚动条来提供分页功能。
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.
在这些属性中,rows尤其方便,因为您可以使用它来在整个结果集中进行迭代和根据名字访问列数据。
DB2 extends its common services, such as optimization, indexing, concurrency control, and utilities, across the traditional relational and XML column data.
DB 2对其涉及传统关系数据和xml列数据的常用服务进行了扩展,例如优化、索引、并行控制和实用工具。
In simple terms, fragment-level statistics allows storage of column data distributions per fragment, and building the table level from its constituent fragments.
简单来说,片段级统计允许按片段存储列数据分布,并从组成的片段中构建表级别。
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.
如果需要在修改列数据类型期间对数据库执行写访问,可以使用下一小节描述的ADMIN_MOVE_TABLE例程。
If you want to use the balance sheet and income statement account information in the same the file then you will need to define the periods correctly in column data pulled.
如果您想在相同的文件夹中使用资产负债表和损益表的账户信息,需要在拖入的列数据中正确定义期间。
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.
如果编目中没有列数据值分布信息,DB 2就会假设值是均匀分布的,这可能导致优化器选择非最优的访问路径。
In our example, the XQuery expression that we pass to XMLEXISTS() is a simple XPath expression where $t is the XML column data: $t/marketinfo/sales/customer/address[zip = "79081"].
在我们的示例中。传递给XMLEXISTS()的XQuery表达式是一个简单的XPath 表达式,其中的 $t 是XML列data:$t/marketinfo/sales/customer/address[zip = "79081"]。
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.
在平台允许更改列数据类型的情况下,可用的数据类型预先填写有该平台的有效兼容数据类型,使类型选择更为容易。
If the column type and the data content are compatible, the data type is successfully altered.
如果列类型和数据内容是兼容的,那么就能够成功更改数据类型。
First, we cover creating an infrastructure or an object model that starts with a request, access definition, and column maps for data extraction.
首先,我们创建一个基础或者对象模型,从分析需求、访问定义,以及数据提取的列映射开始。
If so, then the corresponding data column is changed with the input parameter value.
如果是,那么使用输入参数值更改相应的数据列。
Through this capability, analysts can evaluate a broad range of column combinations against data samples or specific targeted combinations against the full data volume.
通过这种功能,分析师可以根据数据样本评价很多的列组合,或者根据所有数据评价特定的目标组合。
Technical metadata includes host server, database type, database schemas, table name, column names, and data types, all of which are described in technical detail.
技术元数据包括主机服务器、数据库类型、数据库模式、表名、列名和数据类型,这些都是在技术数据中描述的。
However, since DB2 does not force you to associate an XML schema with an XML column, the data types for elements or attributes are not predetermined.
不过,由于DB 2不强制要求将XML模式与xml列相关联,所以元素或属性的数据类型不是预先确定的。
This can take the form of adding a column, changing the data type for a column, adding a constraint, or even deleting a column.
这可以采用添加列、更改列的数据类型、添加约束或者甚至删除列的方式来实现。
应用推荐