76 lines
5.5 KiB
HTML
76 lines
5.5 KiB
HTML
|
<?xml version="1.0" encoding="UTF-8"?>
|
||
|
|
<!DOCTYPE html
|
||
|
|
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
|
||
|
|
<html lang="en-us" xml:lang="en-us">
|
||
|
|
<head>
|
||
|
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
|
||
|
|
<meta name="security" content="public" />
|
||
|
|
<meta name="Robots" content="index,follow" />
|
||
|
|
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
|
||
|
|
<meta name="DC.Type" content="task" />
|
||
|
|
<meta name="DC.Title" content="Load and unload data from non-iSeries systems" />
|
||
|
|
<meta name="abstract" content="You can use the Copy From Import File (CPYFRMIMPF) and Copy To Import File (CPYTOIMPF) commands to import (load) or export (unload) data from and to a non-iSeries system." />
|
||
|
|
<meta name="description" content="You can use the Copy From Import File (CPYFRMIMPF) and Copy To Import File (CPYTOIMPF) commands to import (load) or export (unload) data from and to a non-iSeries system." />
|
||
|
|
<meta name="DC.subject" content="source file, loading from non-, iSeries, data, Copy From Import File (CPYFRMIMPF) command, CPYFRMIMPF (Copy From Import File) command, command, CL, Copy From Import File (CPYFRMIMPF), CPYFRMIMPF (Copy From Import File), Copy To Import File (CPYTOIMPF) command, CPYTOIMPF (Copy To Import File) command, Copy To Import File (CPYTOIMPF), CPYTOIMPF (Copy To Import File)" />
|
||
|
|
<meta name="keywords" content="source file, loading from non-, iSeries, data, Copy From Import File (CPYFRMIMPF) command, CPYFRMIMPF (Copy From Import File) command, command, CL, Copy From Import File (CPYFRMIMPF), CPYFRMIMPF (Copy From Import File), Copy To Import File (CPYTOIMPF) command, CPYTOIMPF (Copy To Import File) command, Copy To Import File (CPYTOIMPF), CPYTOIMPF (Copy To Import File)" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafosrcwrk.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpyfrmimpf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../cl/cpytoimpf.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1998, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rbafosrcimex" />
|
||
|
|
<meta name="DC.Language" content="en-us" />
|
||
|
|
<!-- All rights reserved. Licensed Materials Property of IBM -->
|
||
|
|
<!-- US Government Users Restricted Rights -->
|
||
|
|
<!-- Use, duplication or disclosure restricted by -->
|
||
|
|
<!-- GSA ADP Schedule Contract with IBM Corp. -->
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ibmdita.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="./ic.css" />
|
||
|
|
<title>Load and unload data from non-iSeries systems</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafosrcimex"><a name="rbafosrcimex"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Load and unload data from non-<span class="keyword">iSeries</span> systems</h1>
|
||
|
|
<div><p>You can use the Copy From Import File (CPYFRMIMPF) and Copy To
|
||
|
|
Import File (CPYTOIMPF) commands to import (load) or export (unload) data
|
||
|
|
from and to a non-<span class="keyword">iSeries™</span> system.</p>
|
||
|
|
<div class="section"> <p>To import data from a non-<span class="keyword">iSeries</span> database
|
||
|
|
into an externally-described <span class="keyword">DB2 Universal Database™ for iSeries</span> database
|
||
|
|
file with the CPYFRMIMPF and CPYTOIMPF commands , follow these steps:</p>
|
||
|
|
</div>
|
||
|
|
<ol><li class="stepexpand"><span>Create an import file for the data that you want to copy. </span> The import file can be a database source file or an externally-described
|
||
|
|
database file that has 1 field. The field must have a data type of CHARACTER,
|
||
|
|
IGC OPEN, IGC EITHER, IGC ONLY, or UCS-2.</li>
|
||
|
|
<li class="stepexpand"><span>Send the data to the import file (or, the from file). </span> The
|
||
|
|
system performs any required ASCII to EBCDIC conversion during this process.
|
||
|
|
You can send the data in several ways: <ul><li>TCP/IP file transfer (file transfer)</li>
|
||
|
|
<li>iSeries Access
|
||
|
|
support (file transfer, ODBC)</li>
|
||
|
|
<li>Copy from Tape File (CPYFRMTAP) command</li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
<li class="stepexpand"><span>Create an externally-described <span class="keyword">DB2<sup>®</sup> UDB for iSeries</span> database
|
||
|
|
file, or a distributed data management (DDM) file, into which you want to
|
||
|
|
copy the data.</span></li>
|
||
|
|
<li class="stepexpand"><span>Use the CPYFRMIMPF command to copy the data from the import file
|
||
|
|
to your <span class="keyword">iSeries</span> database file. </span> If you have the <span class="keyword">DB2 UDB Symmetric Multiprocessing</span> product
|
||
|
|
installed on your system, the system will copy the file in parallel.</li>
|
||
|
|
</ol>
|
||
|
|
<div class="section"> <p>To export <span class="keyword">iSeries</span> database
|
||
|
|
data to another system, use the CPYTOIMPF command to copy the data from your
|
||
|
|
database file to the import file. Then send the data to the system to which
|
||
|
|
you are exporting the data.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafosrcwrk.htm" title="These topics describe how to enter and maintain data using various methods.">Work with source files</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="../cl/cpyfrmimpf.htm">Copy From Import File (CPYFRMIMPF) command</a></div>
|
||
|
|
<div><a href="../cl/cpytoimpf.htm">Copy To Import File (CPYTOIMPF) command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|