71 lines
5.4 KiB
HTML
71 lines
5.4 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="copyright" content="(C) Copyright IBM Corporation 2005" />
|
||
|
|
<meta name="DC.rights.owner" content="(C) Copyright IBM Corporation 2005" />
|
||
|
|
<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="concept" />
|
||
|
|
<meta name="DC.Title" content="Use the Copy To Import File (CPYTOIMPF) command to copy between different servers" />
|
||
|
|
<meta name="abstract" content="The Copy To Import File (CPYTOIMPF) command copies the data from the from-file (typically a database file) to an import file." />
|
||
|
|
<meta name="description" content="The Copy To Import File (CPYTOIMPF) command copies the data from the from-file (typically a database file) to an import file." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal3copyserver.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal3notes.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal3restcpy.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal3cpy.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal3datfile.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal3hand.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbal3notes.htm" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rbal3usingcpyto" />
|
||
|
|
<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>Use the Copy To Import File (CPYTOIMPF) command to copy between different
|
||
|
|
servers</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbal3usingcpyto"><a name="rbal3usingcpyto"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Use the Copy To Import File (CPYTOIMPF) command to copy between different
|
||
|
|
servers</h1>
|
||
|
|
<div><p>The <strong>Copy To Import File (CPYTOIMPF) command</strong> copies the data
|
||
|
|
from the from-file (typically a database file) to an import file.</p>
|
||
|
|
<p>You can then move the import file (or file to be exported) to your platform
|
||
|
|
by any method you choose, such as TCP/IP file transfer (text transfer), CA/400
|
||
|
|
support (file transfer, ODBC), or <a href="../cl/cpytotap.htm">CPYTOTAP (copy to tape file)</a> command. Your server then
|
||
|
|
handles the data from the import file in one of two ways.</p>
|
||
|
|
<p>You can also specify a stream file, and the <a href="../cl/cpytoimpf.htm">CPYTOIMPF</a> command
|
||
|
|
will copy the data to the stream file.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal3notes.htm">Notes on the CPYTOIMPF command</a></strong><br />
|
||
|
|
The Copy to Import File (CPYTOIMPF) command reads data from a user from-file and copies it into an import file. The number of jobs used for copy is one. The data of the import file can be formatted by delimiters or it can be in a fixed format.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal3restcpy.htm">Restrictions for the CPYTOIMPF command</a></strong><br />
|
||
|
|
There are certain restrictions apply to the CPYTOIMPF command.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal3cpy.htm">Notes on the delimited import file (CPYTOIMPF command)</a></strong><br />
|
||
|
|
This topic contains information about using the CPYTOIMPF command with delimited import files.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbal3datfile.htm">Copy data to the import file in a fixed format (CPYTOIMPF command)</a></strong><br />
|
||
|
|
When you copy data to the import file in a fixed format (DATFMT(*FIXED)), each field of the file is copied. A null indicator on the command NULLS(*YES) places either a 'Y' or 'N' following the field data in the to-file indicating if the field is null or not.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal3copyserver.htm" title="You can use the CPYFRMIMPF and CPYTOIMPF commands discussed in this topic to import (load) or export (unload) data to and from iSeries.">Copy between different servers</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relconcepts"><strong>Related concepts</strong><br />
|
||
|
|
<div><a href="rbal3hand.htm" title="The Copy From Import File (CPYFRMIMPF) reads data from an import file and copies the data to a to-file. The data of the import file can be formatted by delimiters or in a fixed format.">Handle data from the import file</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="rbal3notes.htm" title="The Copy to Import File (CPYTOIMPF) command reads data from a user from-file and copies it into an import file. The number of jobs used for copy is one. The data of the import file can be formatted by delimiters or it can be in a fixed format.">Notes on the CPYTOIMPF command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|