The following command loads the data into the target database.
下面的命令加载数据到目标数据库中。
One set of control tables is needed for each federated target database.
每个联邦目标数据库都需要一组控制表。
For the example in this article, the target database server is DB2 UDB.
对于本文中的示例,目标数据库服务器是DB 2UDB。
Based on the target database capabilities, the DDL can also be rolled back.
DDL还可以回滚,但这取决于目标数据库的功能。
Use XML configuration files to define different SQL for each target database.
使用XML配置文件为每个目标数据库定义不同的SQL。
Use the same steps as a guide for adding a datastore for your target database.
为目标数据库添加数据存储的步骤是相同的。
Approach 1 requires that the target database is configured as federated database.
方法1要求目标数据库被配置为联邦数据库。
Bind the configured capture file into DB2 packages, if the target database is DB2.
如果目标数据库是DB2,将已配置的捕获文件绑定到db2包。
The user name must match the schema name where tables are created in target database.
用户名必须与目标数据库中创建表时所在的模式相匹配。
LOAD_ONLY: Loads all specified tables from the source database to the target database.
LOAD_ONLY:将指定的所有表从源数据库装载到目标数据库中。
Accessing the target database does not require the execution of a data-consolidation process.
访问目标数据库不需要执行数据整合过程。
Until now, only an empty copy of table SALES in the target database MYSAMPLE has been created.
到目前为止,只在目标数据库mysample中创建了sales表的空拷贝。
There are five steps to extract data from the source database and load it to the target database.
这里共有五个步骤,来实现从源数据库中提取数据并且加载到目标数据库中去。
This report indicates the number of source database objects deployed to Informix target database.
这份报告表明被部署到Informix目标数据库的源数据库对象的数量。
The following table shows the source and target database combinations that MTK currently supports.
下面的表展示了MT K目前支持的源数据库与目标数据库的组合。
This means in order to perform the replication successfully, the target database needs to be accessed.
也就是说,为了成功地执行复制,需要访问目标数据库。
The source database must be cataloged if it does not reside in the same instance as the target database.
如果源数据库和目标数据库不在同一个实例中,那么必须对源数据库进行编目。
MTK presents the same user interface for steps one through three, regardless of your chosen target database.
不论选择哪种目标数据库,MTK为步骤 1 到步骤3 提供的用户界面是相同的。
Therefore, the performance characteristics of this approach are determined only by the target database server.
因此,这种方法的性能特性仅由目标数据库服务器决定。
For the example in this article, the source database is on an IDS server and the target database is on a DB2 UDB server.
对于本文中的示例,源数据库在IDS服务器上,目标数据库在DB 2UDB服务器上。
If Roslyn wants to use a specific tablespace on the target database for the new tables, she specifies it in this window.
如果Roslyn为新的表在目标数据库上使用特定的表空间,她将在这个窗口中指定。
Specifying the nickname, the remote table can be queried in SQL statements on the target database like any other local table.
指定了别名,就可以在目标数据库中用sql语句查询远程表,就像查询任何本地表一样。
Approach 1 - From within the target database, the source database is accessed using DB2's mechanisms for federated databases.
方法1-在目标数据库中,使用DB2的联邦数据库机制访问源数据库。
Continually copy over or retrieve the inactive log files from the source database and roll them forward on the target database.
不断地复制或获取源数据库上的非活动日志文件,并在目标数据库上前滚它们。
The following example illustrates realizing the template, creating the tables, and loading data on four target database servers.
下面的例子演示了如何在4个目标数据库服务器上实现模板、创建表以及装载数据?
As you want to execute the following statements against the target database MYSAMPLE, you alter the CONNECT statement accordingly.
因为希望对目标数据库mysample执行下面的语句,所以要相应地修改CONNECT语句。
This section gives an overview of the steps to set up a replication subscription between your source database and a target database.
本节概述在源数据库和目标数据库之间设置复制订阅的步骤。
This Session makes use of the properties file defined earlier to determine the appropriate target database, user information, and so on.
该Session使用前面定义的属性文件确定适当的目标数据库、用户信息,等等。
In addition to backing up the target database with your normal backup software, I suggest keeping a second copy of the data in plain text.
除了用常规备份软件备份目标数据库外,我还建议再保存一份数据的纯文本副本。
For sparse lookup, a database query is generated based on each input record and the query is sent to the target database to get the result.
对于稀疏查找来说,它将根据每条输入记录来生成数据库查询,并且查询将被发送给目标数据库以获取结果。
应用推荐