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装载列。
The trigger instead of is not supported on views if the target table is a view.
如果目标表是视图,则触发器 instead of不支持视图。
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目标表,则语法应该像下面这个例子一样。
In the next step, you'll customize the DB2 Connector representing the data warehouse target table.
在下一个步骤中,您将定制表示数据仓库目标表的DB 2Connector。
The connector generates the query SQL at runtime based on the target table and the column definitions.
连接器将根据目标表和列定义在运行时生成查询s QL。
You defined the result set for this step's output link in the "Edit the DB2 target table stage" section.
并且在“编辑DB 2目标表阶段”小节为这个阶段的输出链接定义了结果集。
You see that each attribute is annotated with its path and a target column in a target table (" rowset ").
可以看到,每个属性都带有注释,其中包含该属性的路径和它在目标表中的目标列(“rowset”)。
Now define a Target table operator to populate the DWADMIN.HOLDINGS table by completing the following steps.
现在通过以下步骤定义一个Target table操作符,用于填充dwadmin. holdings表。
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阶段,以在将数据装载到目标表之前根据需要修改它。
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中安全地清除,因为一个失败版本没有向目标表填充任何数据。
To only get current rules for each run, check the Delete previous content check box in the properties of the target table operator.
要想只获得针对每次运行的当前规则,选中表目标操作符属性中的Deletepreviouscontent复选框。
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实用程序。
应用推荐