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子句定义的列将以二进制形式从源传递到目标,所使用的代码页是零。
If you want to move a subset of data, you should modify the SELECT clause accordingly.
如果您只希望移动其中一部分数据,那么您应该相应地修改select子句。
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 ”子句)。
The data type for the function return type can be specified directly or using the REFERENCES clause.
函数返回类型的数据类型可以直接指定,或使用references子句指定。
It will not use a FOR UPDATE clause when loading the data, so the rows will not be locked.
在装载数据时它并不使用FOR update子句,所以行并不会被锁定。
But this is likely to be very inefficient - we would rather the WHERE clause be evaluated closer to the data.
不过这有可能会非常低效——我们希望WHERE子句的计算更接近数据端。
It can also be a data structure of a type that is fitting to the SELECT clause.
也可以是类型与select子句相匹配的数据结构。
When creating a partitioned table space in DB2 UDB V7, DB2 divides the data among the partitions according to the part clause of the CREATE INDEX statement.
在DB 2UDBV 7中创建分区的表空间时,DB 2根据CREATEindex语句的part子句将数据划分到几个分区上。
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列。
Common table expressions (the WITH clause) allow efficient pipelining of data-change-operations.
公共表表达式(with子句)允许数据更新操作的高效管道。
Add a WHERE clause to limit the number of rows to test the movement of data.
添加where子句以限制转移的数据行数。
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 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 类型。
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片段。
XML data can be validated during load using the XMLVALIDATE USING clause.
在load期间可以使用XMLVALIDATE USING 子句对XML数据进行验证。
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 fullselect that is part of the definition of a summary table contains a GROUP BY clause summarizing data from the tables that are referenced in the fullselect.
fullselect是总结表定义的一部分,它包含一个GROUPBY 子句,该子句总结 fullselect 中所引用表中的数据。
The refresh DEFERRED clause means that the data in the table can be refreshed at any time using the refresh table statement.
REFRESHdeferred子句的意思是,在任何时候都可以用REFRESHtable语句刷新该表中的数据。
The contents are extracted with the data() function in the return clause; otherwise, I'd get more than just the text in the node, I'd get all the markup, too.
内容是用return子句中的data()函数提取的;否则,不仅仅会得到节点中的文本,还会得到所有的标记。
Instead, use a virtual table with a WHERE clause, or define the join as a view in the data source, and execute the rule on this view.
相反,可使用具有where子句的虚拟表,或者将连接作为数据源的视图进行定义,并在这一视图中执行规则。
But we're not done yet. If the data provider is an SQL database, the WHERE clause must be applied to each record.
事情还没有完结,如果数据提供者是一个SQL数据库的话,WHERE子句必须应用在每条记录上。
If the data provider is an SQL database, the WHERE clause must be applied to each record.
如果数据提供程序是一个SQL数据库,则必须将where子句应用于每条记录。
Keeping data change operations in the WITH clause imposes a very natural order which can be used to solve conflicts.
让数据更改操作留在with子句中,实际上便强加了一个非常自然的顺序,这样可用于解决冲突。
Use the WHERE clause to filter data in the SQL instead of bringing it all into your program to filter.
在SQL中使用where子句过滤数据,而不是在程序中到处使用它进行过滤。
DB2 accesses the historical data automatically and transparently only if the FROM clause of the query includes the period specifications.
只有在查询的from子句包含周期规范时,DB 2才会自动且透明地访问历史数据。
The FOR clause of this function loops through the entity nodes contained in the transient XML data.
该函数的for子句循环通过包含在临时XML数据中的实体节点。
DB2 automatically rewrites the queries with appropriate WHERE clause predicates depending on the data types used in the start and end columns of the temporal tables.
DB 2依据时态表的开始和结束列中使用的数据类型,使用合适的where子句谓词自动重写查询。
The table space placement for XML data is determined by the LONG in clause, which can be specified at partition level, table level, or any combination thereof.
XML数据的表空间位置由LONGin子句决定,其可在分区级别、表级别、或它们的任何组合中指定。
A filter (e.g., SQL statement sub-clause) is used to filter out data records not belonging to the current tenant.
使用筛选器(例如sql子句)筛选掉不属于当前租户的数据记录。
The WHERE clause joins the transient and persistent XML data based on asset names.
WHERE 子句基于资产名称联接临时和永久XML数据。
应用推荐