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是在不同的表空间或数据库之间快速轻松地转移数据的方法。
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操作的情况下，这种语法才是有效的，在命令行上是无效的。
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表的联邦访问。
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，也可以把表从一个数据库转移到另一个数据库。
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。
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特性在一个数据库中以及不同的数据库之间快速轻松地复制数据。
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特性在一个数据库中以及不同的数据库之间快速轻松地复制数据。
应用推荐