You specify a queue map, target table options, and other preferences.
您将指定队列映射、目标表选项以及其他参数。
You only need to configure the server info and select the target table.
这里只需配置服务器信息和选择目标表。
Select the target table (see Figure 27), and load columns for each DB2 stages.
选择目标表(参见图27),为每个DB2stage装载列。
Refresh (Snapshot) replicates a snapshot of the source table to the target table.
Refresh (Snapshot) 把源表的快照复制到目标表。
To open the DB2 Connector that represents the target table, double-click on its icon.
要打开表示目标表的DB 2Connector,双击它的图标。
On the server with the target table, run the merge statements, as shown in Listing 14.
在目标表所在的服务器上,运行merge语句,如清单14所示。
The target table of detach becomes available only after the asynchronous detach completes.
只有在异步分离完成后,分离的目标表才可见。
ADMIN_MOVE_TABLE moves triggers and views defined on the source table to the target table.
ADMIN_MOVE_TABLE将源表中定义的触发器和视图移动到目标表。
If you are creating a CCD target table manually, your syntax should follow the example below.
如果手动创建CCD目标表,则语法应该像下面这个例子一样。
You see that each attribute is annotated with its path and a target column in a target table (" rowset ").
可以看到,每个属性都带有注释,其中包含该属性的路径和它在目标表中的目标列(“rowset”)。
It depends on the type and a few other properties of the target table while performing the loading operation.
执行加载操作时,这取决于目标表的类型和其他几个属性。
Therefore during merge-insert operation, only for-each-row insert triggers on the target table are activated.
因此,在merge -insert操作过程中,仅激活目标表上的for - each -row insert触发器。
If the target table is a multidimensional clustering (MDC) table, the source table must also be an MDC table.
如果目标表是多维集群化(Multidimensional Clustering,mdc)表,则源表也必须是mdc表。
The import utility uses the SQL INSERT statement (or the SQL UPDATE statement) to write data to the target table.
import工具使用SQLINSERT语句(或 SQLUPDATE 语句)将数据写到目标表中。
On the other hand, ALLOW NO access (the default) prevents concurrent applications from accessing target table data.
另一方面,ALLOWNOACCESS(默认值)防止并发应用程序访问目标表中的数据。
Edit the XML Relational Mapping operator, deleting all column definitions except those required by the target table.
编辑XMLRelationalmapping操作符,删除目标表不需要的所有列定义。
Use the column mapping field to change the default mapping of source columns to columns in the non-DB2 target table.
使用Columnmapping字段来修改非db 2目标表中源列到列的默认映射。
Optionally, inspect the data in the target table by selecting View Data in the stage editor for the target DB2 stage.
或者,您也可以在目标DB2阶段的阶段编辑器中选择ViewData查看目标表中的数据。
From the target Tables list, expand the database user or schema you want to use and select the target table from the list.
在Target Tables列表中,展开要使用的数据库用户或模式并选择目标表。
Each Stored Procedure populates a target table that is fully refreshed (i.e., population type of Replace) at each execution.
每个存储过程填充一个在每次执行时被完全刷新(即填充类型为Replace)的目标表。
Matched rows in the target table are updated or deleted based on update or delete clause specifications, as shown in Figure 2.
对于目标表中匹配的行,将依据更新或者删除子句规范来进行更新或者删除,如图2所示。
Next, you'll customize the Transformer stage so that the data will be modified as needed before it's loaded into the target table.
接下来,您将定制Transformer阶段,以在将数据装载到目标表之前根据需要修改它。
If a table is in set integrity pending state at the beginning of the copy operation, the data is not loaded into the target table.
如果在复制操作开始时表处于setintegritypending状态,那么数据不会装载到目标表中。
Failed editions may be purged safely from the WIP, since there is no data that was filled in the target table for a failed edition.
可以将失败的版本从WIP中安全地清除,因为一个失败版本没有向目标表填充任何数据。
The output from one of the XML Relational Mapping operators (shown on the lower branch of Figure 4) can feed the target table directly.
一个XMLRelationalMapping操作符(见图4下方的分支)的输出可以直接用于填充目标表。
For automatic loading of the target table by the Q Apply program, federated Q replication supports only the EXPORT and IMPORT utilities.
为了通过QApply程序自动装入目标表,联邦q复制仅仅支持EXPORT和IMPORT实用程序。
The merge statement first does a join (outer join or inner join, depending on the merge statement) between source and target table rows.
merge语句首先进行(外部联接或者内部联接,取决于merge语句)源与目标表行之间的联接。
DELUXE mode provides more concurrency to the target table while loading, whereas EXPRESS mode expects the target table to be a RAW table.
DELUXE在加载时向目标表提供更多并发性,而EXPRESS模式期望目标表是一个raw表。
The Replication Center always creates a new nickname for a non-DB2 target table even if one or more nicknames already exist for the table.
ReplicationCenter总是为非db2的目标表创建一个新的别名,即使该表已经存在一个或多个别名。
应用推荐