Approach 2 - the remote access feature of the LOAD FROM CURSOR command is used.
方法2-使用LOAD FROM CURSOR命令的远程访问特性。
This way, a LOAD FROM CURSOR is a fast and easy possibility to move data between different tablespaces or different databases.
因此，LOAD FROM CURSOR是在不同的表空间或数据库之间快速轻松地转移数据的方法。
The RENAME command is used to create the shadow table, the data is reloaded into the EMPLOYEE table using the load FROM CURSOR command.
RENAME命令用于创建影子表，而数据是通过LOAD FROM CURSOR命令重新装载到employee表中的。
This syntax is only valid when the LOAD FROM CURSOR operation is embedded in an ADMIN_CMD call, but it is not valid on the command line.
只有在ADMIN_CMD调用中嵌入LOAD FROM CURSOR操作的情况下，这种语法才是有效的，在命令行上是无效的。
That means: Using LOAD from CURSOR, a table can be copied from one database into another database, too. This can be accomplished in two ways.
这意味着：通过使用LOAD FROM CURSOR，也可以把表从一个数据库转移到另一个数据库。
The last step to prepare the LOAD FROM CURSOR operation is to configure the federated access to table SALES in the source database SAMPLE.
准备LOAD FROM CURSOR操作的最后一步是配置对源数据库sample中sales表的联邦访问。
Now that federated access to the table in the source database is configured, the LOAD FROM CURSOR operation works exactly the same as already shown.
配置了对源数据库表的联邦访问之后，就可以像前面一样执行LOAD FROM CURSOR操作。
The article also explains the specialties when LOAD FROM CURSOR operations are executed within application code using the ADMIN_CMD stored procedure.
还解释了通过 ADMIN_CMD存储过程在应用程序代码中执行LOAD FROM CURSOR操作时的特殊问题。
As already mentioned, the LOAD FROM CURSOR operation combined with the federated access requires more effort in terms of configuration than the approach that is presented next.
正如前面提到的，与方法2相比，结合使用LOAD FROM CURSOR操作和联邦访问需要做的配置工作比较多。
Now when performing the LOAD FROM CURSOR operation within the stored procedure, DB2 tries to establish the remote connection to database SAMPLE with the authorization ID of the local user.
在存储过程中执行LOAD FROM CURSOR操作时，DB2尝试用本地用户的授权ID连接远程数据库SAMPLE。
To override the data preservation, select Shadow table, reload using load FROM CURSOR as the Unload provider in the Specify data Unload and reload Information wizard, as shown in Figure 14.
要覆盖数据保留设置，可在SpecifyDataUnloadandreloadInformation向导中选择Shadowtable, reloadusingload FROM CURSOR作为Unload提供程序，如图14所示。
With the help of sample scenarios, the article demonstrates how DB2's LOAD FROM CURSOR feature can be used to copy data fast and simple within a database and also between different databases.
本文通过示例场景演示了如何使用DB2的LOAD FROM CURSOR特性在一个数据库中以及不同的数据库之间快速轻松地复制数据。
Two new capabilities in V8 load are especially interesting in terms of being alternatives to insert: load from a cursor, and load from call level interface (CLI) applications.
在V8load 中有两个新功能，它们对于 load成为insert的替代方案有着特别的功效，这两个功能是：从游标装载和从调用层接口（CLI）应用程序装载。
The data is copied by using either INSERT FROM CURSOR, which is the default, or LOAD if the correct option is set.
数据可以通过使用INSERTFROM CURS OR(默认设置)复制，也可以通过LOAD复制(如果设置了正确的选项的话)。
Such problems can be avoided by using the LOAD utility's FROM CURSOR option.
可以使用LOAD实用程序的FROM CURSOR选项避免这些问题。
Several factors contribute to making the LOAD option faster than INSERT FROM CURSOR option.
一些因素可以使LOAD选项比INSERTFROM CURSOR选项更快速。
This example moves the same CUSTOMER_INFO table, but it USES the LOAD option instead of the INSERT FROM CURSOR option, which is the default.
该示例移动同一个customer_info表，但是使用了LOAD选项，而不是INSERTFROM CURSOR选项，后者是默认配置。
This example moves the same CUSTOMER_INFO table, but it USES the LOAD option instead of the INSERT FROM CURSOR option, which is the default.
该示例移动同一个customer_info表，但是使用了LOAD选项，而不是INSERTFROM CURSOR选项，后者是默认配置。
应用推荐