避免重复行。
You can use the --extratargetrows option with either of these three options: keep, delete, and merge to specify how to handle duplicate rows.
可以使用 --extratargetrows选项，加上keep、delete和merge这三个选项中的一个，来规定如何处理重复行。
When having duplicate rows in the lock table (see the Create a DB2 table for resource locking section), concurrent use of the resource is possible.
如果锁表中有重复的行(参见为资源锁定创建一个DB 2表一节)，就可以对资源进行并发使用。
It is a good practice to delete any pruned rows from the table that you loaded in order to ensure that you do not load duplicate rows into the table at a later time.
从您装载的表中删除被修剪过的行，确保以后不会将重复的行装载到表中，这是一种很好的做法。
However, if there are many duplicate rows per distinct index value, and the associated table is highly clustered, the added costs of joining through the index can be slight.
然而，如果每个不同的索引值都有许多重复的行，而所关联的表是高度群集的，那么通过索引添加的连接成本可能很低。
I'd like to prevent duplicate rows.
我想防止重复行。
If you have duplicate rows in your table, they will not be returned as distinct.
如果在你的表中有重复的记录，那么它们将不会作为不同的的记录返回。
A primary key is a constraint that assures that each table contains no duplicate rows.
主键是确保每个表都不包含重复行的约束。
Each row of a table is uniquely identified by a primary key composed of one or more columns. This implies that a table may not contain duplicate rows.
表的每一行都是由一个唯一的主键标识的。主键由一列或多列构成。这意味表里不会有重复的行。
However, if the session data conflicts with a new index, (such as duplicate rows conflicting with a unique index), the index is not materialized for that session until the data is corrected.
但是，如果会话数据与某个新索引冲突(比如重复行在唯一的索引上冲突)，则在数据纠正之前不会为该会话物化该索引。
However, if the session data conflicts with a new index, (such as duplicate rows conflicting with a unique index), the index is not materialized for that session until the data is corrected.
但是，如果会话数据与某个新索引冲突(比如重复行在唯一的索引上冲突)，则在数据纠正之前不会为该会话物化该索引。
应用推荐