[外文翻譯]使用 DB2 的LOAD FROM CURSOR 特性快速輕松地轉(zhuǎn)移數(shù)據(jù)/Fast and easy data movement using DB2's LOAD FROM CURSOR feature
內(nèi)包含中文翻譯和英文原文，內(nèi)容完善，建議下載閱覽。

①中文頁(yè)數(shù)16

中文字?jǐn)?shù)5924

②英文頁(yè)數(shù)25

英文字?jǐn)?shù)4335

③ 摘要
在數(shù)據(jù)量很大的情況下，使用 EXPORT 實(shí)用程序生成數(shù)據(jù)交換文件常常要花費(fèi)很長(zhǎng)時(shí)間。另外，在把數(shù)據(jù)移入和移出數(shù)據(jù)庫(kù)時(shí)，必須考慮不同的數(shù)據(jù)庫(kù)編碼頁(yè)和操作系統(tǒng)。

可以使用 LOAD 實(shí)用程序的 FROM CURSOR 選項(xiàng)避免這些問(wèn)題。當(dāng)指定 FROM CURSOR 選項(xiàng)時(shí)，LOAD 實(shí)用程序直接把一個(gè) SQL 查詢的結(jié)果集作為數(shù)據(jù)裝載操作的來(lái)源，這樣就不需要生成臨時(shí)數(shù)據(jù)交換文件。因此，LOAD FROM CURSOR 是在不同的表空間或數(shù)據(jù)庫(kù)之間快速輕松地轉(zhuǎn)移數(shù)據(jù)的方法。可以在命令行上執(zhí)行 LOAD FROM CURSOR，也可以通過(guò)使用 DB2 的 ADMIN_CMD 存儲(chǔ)過(guò)程在應(yīng)用程序或存儲(chǔ)過(guò)程中執(zhí)行它。本文介紹 LOAD FROM CURSOR 特性并提供兩個(gè)接口 Command Line Processor (CLP) 和 ADMIN_CMD 存儲(chǔ)過(guò)程的使用示例。

Generating the data exchange file using the EXPORT utility is often a lengthy process in the case of large amounts of data. Besides, different database codepages and operating systems have to be considered when moving data in and out of a database.
Such problems can be avoided by using the LOAD utility's FROM CURSOR option. When specifying the FROM CURSOR option, the LOAD utility directly references the result set of a SQL query as the source of a data load operation, thus bypassing the need to produce a temporary data exchange file. This way, a LOAD FROM CURSOR is a fast and easy possibility to move data between different tablespaces or different databases. LOAD FROM CURSOR operations can be executed on the command line as well as from within an application or a stored procedure by utilizing DB2's ADMIN_CMD stored procedure. This article introduces the LOAD FROM CURSOR feature and provides usage samples for both interfaces, the DB2 Command Line Processor (CLP) and ADMIN_CMD stored procedure.


④關(guān)鍵字 數(shù)據(jù)/ feature

⑤參考文獻(xiàn)
參閱本文在 developerWorks 全球網(wǎng)站上的 英文原文。
文獻(xiàn)《Moving data using the CURSOR file type》
訪問(wèn) DB2 9.5 Information Center for Linux, UNIX, and Windows，獲取完整的 HTML 格式的 DB2 9.5 LUW 在線文檔。
在 DB2 9 for Linux UNIX and Windows Support Site 上搜索 APAR、下載補(bǔ)丁包、獲取 PDF 格式的 DB2 LUW 文檔等等。

• Read Moving data using the CURSOR file type to get more in-depth information about the topics covered in this article:

• Visit the DB2 9.5 Information Center for Linux, UNIX, and Windows to get the complete DB2 9.5 LUW documentation online in HTML format.

• The DB2 9 for Linux UNIX and Windows Support Site lets you search for APARs, download fixpacks, get DB2 LUW documentation in PDF format, and so on.

• Check out the Best practices for DB2 for Linux, UNIX, and Windows papers. These papers are designed to provide practical guidance for the most common DB2 9 product configurations. By applying these recommendations, you may improve the value of your DB2