If you want to move a subset of data, you should modify the SELECT clause accordingly.
如果您只希望移动其中一部分数据,那么您应该相应地修改select子句。
It will not use a FOR UPDATE clause when loading the data, so the rows will not be locked.
在装载数据时它并不使用FOR update子句,所以行并不会被锁定。
XML data can be validated during load using the XMLVALIDATE USING clause.
在load期间可以使用XMLVALIDATE USING 子句对XML数据进行验证。
It can also be a data structure of a type that is fitting to the SELECT clause.
也可以是类型与select子句相匹配的数据结构。
In DB2 9.7, the compression capability for XML data is enabled simply through the compress YES clause of the CREATE table statement, which compresses both relational and XML columns in the table.
在DB 2 9.7中,只需通过CREATEtable语句的COMPRESSyes子句启用XML数据的压缩功能,这会同时压缩表中的关系和xml列。
Similar to DB2 UDB for Linux, UNIX, and Windows, in DB2 UDB for z/OS you can store and retrieve Unicode data if you have used the CCSID UNICODE clause on the object definitions, such as the following
与DB2UDBforLinux,UNIX,andWindows相似,在 DB2 UDBfor z/OS 中,如果您在对象定义上使用了CCSIDUNICODE子句,就可以存储并检索 Unicode数据,例如
Beyond the embedded original SQL query, no representation is kept of the table or tables that were queried for data (the "FROM" clause).
除了嵌入的原始sql查询以外,没有保留用于查询数据的一个或多个表的表示(“FROM ”子句)。
You will recall that a summary table is a specialized type of MQT whose fullselect contains a GROUP BY clause summarizing data from the tables that are referenced in the fullselect.
您应该记得,总结表是一种特殊类型的MQT,它们的fullselect包含一个GROUPBY子句,该子句总结fullselect中所引用表中的数据。
The data type for the function return type can be specified directly or using the REFERENCES clause.
函数返回类型的数据类型可以直接指定,或使用references子句指定。
The REF USING INTEGER clause specifies that the INTEGER data type will be used to represent the REFERENCE type of this structured type and all of its subtypes.
REF USINGINTEGER子句指定了 INTEGER数据类型,将使用这个数据类型表示该结构化类型及其所有子类型的 REFERENCE 类型。
If your table contains relational and XML data and you want to refresh the relational statistics only, you can execute RUNSTATS with the new clause "EXCLUDING XML COLUMNS".
如果表包含关系数据和XML 数据,而您又只想刷新关系数据的统计信息,那么可以带新的子句 “EXCLUDING XMLCOLUMNS”来执行RUNSTATS。
When you have determined that the table contains data that is not uniformly distributed, run RUNSTATS with the WITH DISTRIBUTION clause.
当您已确定表中包含不是统一分布的数据时,可以运行包含WITHDISTRIBUTION子句的RUNSTATS。
The LET clause extracts referenced entity information from the collection of credit default swap data that DB2 returns after executing the named query defined in Listing 6.
let子句从执行清单6中定义的已命名查询之后DB 2返回的信用违约掉期数据集合中摘取所引用的实体信息。
Subsequent portions of the query use the XQuery where clause to filter returned data further and to transform portions of the selected comments into new XML fragments.
该查询中随后的部分使用XQuerywhere子句进一步过滤返回的数据,并将选中的评论的一些部分转换成新的xml片段。
Add a WHERE clause to limit the number of rows to test the movement of data.
添加where子句以限制转移的数据行数。
In this window you will find the mapping of columns, and you will have the option to restrict the data that will be replicated in case this is a requirement, using a WHERE clause or row filters.
在这个窗口中,您将发现列的映射,并且如果需要,可以使用where子句或者行过滤器来限制要复制的数据。
The RUNSTATS repeatable clause allows the same sample to be generated across RUNSTATS statements a long as the table data has not changed.
RUNSTATSrepeatable子句允许通过runstats语句生成相同的样本,只要表数据没有发生更改。
An Open SQL select clause always needs a data structure where it can put the results of the call, such as a structure or an internal table for bulk calls.
OpenSQLselect子句总是需要一个数据结构,比如结构或内部表(对于大量调用),它要把调用的结果放在这个数据结构中。
The refresh DEFERRED clause means that the data in the table can be refreshed at any time using the refresh table statement.
REFRESHdeferred子句的意思是,在任何时候都可以用REFRESHtable语句刷新该表中的数据。
But this is likely to be very inefficient - we would rather the WHERE clause be evaluated closer to the data.
不过这有可能会非常低效——我们希望WHERE子句的计算更接近数据端。
Columns defined with the BLOB data type, or using the FOR BIT data clause will be passed as binary from the source to the target, and the code page used is zero.
通过BLOB数据类型或使用FORBITdata子句定义的列将以二进制形式从源传递到目标,所使用的代码页是零。
Common table expressions (the WITH clause) allow efficient pipelining of data-change-operations.
公共表表达式(with子句)允许数据更新操作的高效管道。
Add WHERE Clause dialog box enables you to further define a SELECT statement of a SQL data source by specifying search conditions that restrict the rows returned.
“添加where子句”对话框可以通过指定限制返回的行的搜索条件,进一步定义SQL数据源的SELECT语句。
Add ORDER by Clause dialog box enables you to further define a SELECT statement for a SQL data source by specifying how the results are sorted.
“添加orderby子句”对话框可以通过指定结果的排序方式,进一步为SQL数据源定义SELECT语句。
You can also update, delete, and query data using a FOR PORTION OF BUSINESS_TIME clause.
还可以使用一个FORPORTION OF business_time子句来更新、删除和查询数据。
DATAFILES is a mandatory clause for each external table. It specifies the file path where the data can be read from or written to.
DATAFILES是每个外部表的必需子句,它指定读写数据的文件路径。
If it is not immediately obvious why the error is occurring, examine the query carefully and trace the type of the result of each clause from the data source to the point where the error is occurring.
如果发生此错误的原因不十分明显,请仔细检查查询,并跟踪从数据源到错误发生点的每个子句的结果的类型。
The Data Protection Act, which normally prevents companies from sharing such information, has a get-out clause for cases where it is clear that a crime has been committed.
而一般会防止公司透露这类信息的《数据保护法案》针对犯罪事实清楚的情况规定了特例条款。
You can delete data pertaining to specific business time periods by specifying the time range in the FOR PORTION OF BUSINESS_TIME clause.
通过在FORPORTION OF business_time子句中指定时间范围,您可以删除与特定业务时段相关的数据。
You can specify the path for XML data using the XML FROM clause.
可以使用FROM 子句为XML数据指定路径。
应用推荐