A three-column data table was generated.
接着将会生成一个三列的数据表。
How to rename columns and change column data type?
如何重命名列并修改列数据类型?
Under "Column data," click Add to add an attribute.
在 "Column data" 下,点击Add 增加一个属性。
Unexpected column data types were returned from query.
查询结果返回意外的列数据类型。
In MEDIUM or HIGH mode, a histogram of the column data is created.
在MEDIUM或HIGH模式下,将创建列数据的柱状图。
To create a new column mapping for the column data set, complete the following steps.
要为Column数据集创建一个新的列映射。
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平台预先填写的,以便于选择。
You might want to change a column data type to a different type to match the data more closely.
您可能希望将一种列类型改为另一种列类型,以便进一步匹配数据。
Always match the DB2 column data type to the application variable data type, or the JDBC set method.
始终匹配DB 2列数据类型与应用程序变量数据类型或JDBCset方法。
You can also use AES_ENCRYPT and AES_DECRYPT functions for encryption and decryption of column data.
还可以使用AES_ENCRYPT和AES_DECRYPT函数对列数据进行加密和解密。
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"]。
应用推荐