ibm-information-center/dist/eclipse/plugins/i5OS.ic.dm_5.4.0.1/rbal3cpyffuncs.htm

519 lines
41 KiB
HTML
Raw Permalink Normal View History

2024-04-02 14:02:31 +00:00
<?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="Copy files: supported functions" />
<meta name="abstract" content="iSeries provides many copy functions for database files and copy functions for device files. Each function has associated parameters and files types." />
<meta name="description" content="iSeries provides many copy functions for database files and copy functions for device files. Each function has associated parameters and files types." />
<meta name="DC.Relation" scheme="URI" content="rbal3copyfileover.htm" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="rbal3cpyffuncs" />
<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>Copy files: supported functions</title>
</head>
<body id="rbal3cpyffuncs"><a name="rbal3cpyffuncs"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Copy files: supported functions</h1>
<div><p><span class="keyword">iSeries™</span> provides
many copy functions for database files and copy functions for device files.
Each function has associated parameters and files types.</p>
<p>The following tables, (<a href="#rbal3cpyffuncs__rbal3dbfs">Table 1</a> and <a href="#rbal3cpyffuncs__rbal3dfs">Table 2</a>), provide a summary of the specific
copy functions (using the copy commands) you can use for copying records by
the types of files being copied from and to. The functions with their associated
parameters are listed down the left side, and the file types (and if each
can be a from-file and a to-file) are shown across the top. An X indicates
that the associated parameter is valid for the type and use of file under
which it occurs.</p>
<div class="tablenoborder"><a name="rbal3cpyffuncs__rbal3dbfs"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbal3cpyffuncs__rbal3dbfs" width="100%" frame="hsides" border="1" rules="all"><caption>Table 1. Summary of Copy
Functions for database files</caption><thead align="left"><tr><th rowspan="3" align="left" valign="bottom" width="25.37037037037037%" id="d0e32">Copy function</th>
<th rowspan="3" align="left" valign="bottom" width="17.59259259259259%" id="d0e34">Parameter</th>
<th colspan="4" align="center" valign="top" id="d0e36">Database files<sup>1</sup></th>
</tr>
<tr><th colspan="2" align="center" valign="top" id="d0e41">Physical</th>
<th colspan="2" align="center" valign="top" id="d0e43">Logical</th>
</tr>
<tr><th align="center" valign="top" width="14.814814814814813%" id="d0e46">From</th>
<th align="center" valign="top" width="15.925925925925927%" id="d0e48">To</th>
<th align="center" valign="top" width="14.629629629629628%" id="d0e50">From</th>
<th align="center" valign="top" width="11.666666666666666%" id="d0e52">To</th>
</tr>
</thead>
<tbody><tr><td rowspan="2" align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Select files</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">FROMFILE<sup>2</sup></td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">TOFILE</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">&nbsp;</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">&nbsp;</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td rowspan="2" align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Select members</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">FROMMBR</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">TOMBR</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">&nbsp;</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">&nbsp;</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Add to, replace, or update existing records</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">MBROPT</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">&nbsp;</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">&nbsp;</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Create the to-file</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">CRTFILE<sup>3</sup></td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Print copied, excluded, and error records</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">PRINT<sup>4</sup></td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Select by record format</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">RCDFMT</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">&nbsp;</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td rowspan="2" align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Select by relative record number</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">FROMRCD</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X<sup>5</sup></td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">TORCD</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X<sup>5</sup></td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td rowspan="2" align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Select by key field value</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">FROMKEY</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">TOKEY</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Specify number of records to copy</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">NBRRCDS</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Select by character content</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">INCCHAR</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Select by field value</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">INCREL</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">&nbsp;</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Process different database record formats</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">FMTOPT</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Update sequence number and date</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">SRCOPT</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Specify start value and increment</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">SRCSEQ</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Print character and hex format</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">OUTFMT<sup>4</sup></td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Maximum recoverable errors allowed</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">ERRLVL</td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">X</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="25.37037037037037%" headers="d0e32 ">Disregard or include deleted records</td>
<td align="left" valign="top" width="17.59259259259259%" headers="d0e34 ">COMPRESS<sup>6</sup></td>
<td align="center" valign="top" width="14.814814814814813%" headers="d0e36 d0e41 d0e46 ">X</td>
<td align="center" valign="top" width="15.925925925925927%" headers="d0e36 d0e41 d0e48 ">X</td>
<td align="center" valign="top" width="14.629629629629628%" headers="d0e36 d0e43 d0e50 ">&nbsp;</td>
<td align="center" valign="top" width="11.666666666666666%" headers="d0e36 d0e43 d0e52 ">&nbsp;</td>
</tr>
<tr><td colspan="6" align="left" valign="top" headers="d0e32 d0e34 d0e36 d0e41 d0e43 d0e46 d0e48 d0e50 d0e52 "> <div class="note"><span class="notetitle">Note:</span> <dl><dt class="dlterm"><sup>1</sup></dt>
<dd>DDM files will appear to act like database files, with exceptions noted
in the <a href="../ddm/rbae5kickoff.htm">Distributed
Data Management</a> book.</dd>
<dt class="dlterm"><sup>2</sup></dt>
<dd>On the <a href="../cl/cpyfrmqryf.htm">CPYFRMQRYF</a> command,
the FROMOPNID parameter is used to identify an open identifier for the open
query file to be copied from. The FROMFILE parameter is used in all other
copy commands.</dd>
<dt class="dlterm"><sup>3</sup></dt>
<dd>If the to-file does not exist before the copy operation and the from-file
is a physical or logical file, the copy operation will create a physical file
as the to-file if you specified CRTFILE(*YES) on the copy commands.</dd>
<dt class="dlterm"><sup>4</sup></dt>
<dd>You can specify a program-described printer file so that the copy will
produce a list with no special formatting or page headings, or you can specify
TOFILE(*PRINT) to produce a formatted list. You can specify PRINT(*COPIED)
to produce a formatted list of the copied records, you can specify PRINT(*EXCLD)
to produce a formatted list of the records excluded by the INCCHAR or INCREL
parameters, and you can specify PRINT(*ERROR) to produce a formatted list
of records causing ERRLVL errors. When you request a list by specifying the
TOFILE(*PRINT) parameter, the OUTFMT parameter specifies whether the data
is printed in character or in both character and hexadecimal form.</dd>
<dt class="dlterm"><sup>5</sup></dt>
<dd>You can specify the FROMRCD and TORCD parameter values for a logical file
if it has an arrival sequence access path.</dd>
<dt class="dlterm"><sup>6</sup></dt>
<dd>You cannot specify COMPRESS(*NO) if: <ul><li>The to-file member or a logical file member based on the to-file member
has a keyed access path with any of the following attributes: <ul><li>Unique keys (UNIQUE keyword specified in the DDS)</li>
<li>Floating-point key field or logical numeric key field and not MAINT(*REBLD)</li>
<li>Select/omit specifications in the DDS (without the DYNSLT keyword specified)
and not MAINT(*REBLD)</li>
</ul>
</li>
<li>Field-level mapping or source/data conversion is required (FMTOPT parameter).</li>
<li>An EOFDLY wait time is specified for the from-file on an Override Database
File (OVRDBF) command.</li>
</ul>
<div class="note"><span class="notetitle">Note:</span> To copy deleted records, the from-file must be processed in arrival
sequence.</div>
</dd>
</dl>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="tablenoborder"><a name="rbal3cpyffuncs__rbal3dfs"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbal3cpyffuncs__rbal3dfs" width="100%" frame="border" border="1" rules="all"><caption>Table 2. Summary of Copy functions
for device files</caption><thead align="left"><tr><th rowspan="3" align="left" valign="bottom" width="22.195121951219512%" id="d0e376">Copy function</th>
<th rowspan="3" align="left" valign="bottom" width="14.634146341463413%" id="d0e378">Parameter</th>
<th colspan="8" align="center" valign="top" id="d0e380">Device Files</th>
</tr>
<tr><th colspan="2" align="left" valign="bottom" id="d0e383">Inline data</th>
<th colspan="2" align="left" valign="bottom" id="d0e385">Diskette</th>
<th colspan="2" align="left" valign="bottom" id="d0e387">Tape</th>
<th colspan="2" align="left" valign="bottom" id="d0e389">Printer</th>
</tr>
<tr><th align="left" valign="top" width="5.853658536585367%" id="d0e392">From</th>
<th align="left" valign="top" width="6.341463414634147%" id="d0e394">To</th>
<th align="left" valign="top" width="8.048780487804878%" id="d0e396">From</th>
<th align="left" valign="top" width="7.560975609756097%" id="d0e398">To</th>
<th align="left" valign="top" width="8.048780487804878%" id="d0e400">From</th>
<th align="left" valign="top" width="8.536585365853659%" id="d0e402">To</th>
<th align="left" valign="top" width="8.780487804878048%" id="d0e404">From</th>
<th align="left" valign="top" width="10%" id="d0e406">To</th>
</tr>
</thead>
<tbody><tr><td rowspan="2" align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Select files</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">FROMFILE</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">X</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">X</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">TOFILE</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">X</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">X</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">X</td>
</tr>
<tr><td rowspan="2" align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Select members</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">FROMMBR</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">X</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">TOMBR</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">X</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">X</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Add to or replace existing records</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">MBROPT</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Create the to-file</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">CRTFILE</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Print copied or excluded records</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">PRINT<sup>2</sup></td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">X</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">X</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">X</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">X</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">X</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Select by record format</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">RCDFMT</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td rowspan="2" align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Select by relative record number</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">FROMRCD</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">X</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">X</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">TORCD</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">X</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">X</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td rowspan="2" align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Select by key field value</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">FROMKEY</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">TOKEY</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Specify number of records to copy</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">NBRRCDS</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">X</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">X</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Select by character content</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">INCCHAR</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">X</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">X</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Select by field value</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">INCREL</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Process different database record formats</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">FMTOPT</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Update sequence number or date</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">SRCOPT</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Specify start value and increment</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">SRCSEQ</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Print character or hex format</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">OUTFMT<sup>2</sup></td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">X</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">X</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">X</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">X</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">X</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Maximum recoverable errors allowed</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">ERRLVL</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">X</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td align="left" valign="top" width="22.195121951219512%" headers="d0e376 ">Disregard or include deleted records</td>
<td align="left" valign="top" width="14.634146341463413%" headers="d0e378 ">COMPRESS</td>
<td align="left" valign="top" width="5.853658536585367%" headers="d0e380 d0e383 d0e392 ">&nbsp;</td>
<td align="left" valign="top" width="6.341463414634147%" headers="d0e380 d0e383 d0e394 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e385 d0e396 ">&nbsp;</td>
<td align="left" valign="top" width="7.560975609756097%" headers="d0e380 d0e385 d0e398 ">&nbsp;</td>
<td align="left" valign="top" width="8.048780487804878%" headers="d0e380 d0e387 d0e400 ">&nbsp;</td>
<td align="left" valign="top" width="8.536585365853659%" headers="d0e380 d0e387 d0e402 ">&nbsp;</td>
<td align="left" valign="top" width="8.780487804878048%" headers="d0e380 d0e389 d0e404 ">&nbsp;</td>
<td align="left" valign="top" width="10%" headers="d0e380 d0e389 d0e406 ">&nbsp;</td>
</tr>
<tr><td colspan="10" align="left" valign="top" headers="d0e376 d0e378 d0e380 d0e383 d0e385 d0e387 d0e389 d0e392 d0e394 d0e396 d0e398 d0e400 d0e402 d0e404 d0e406 "> <div class="note"><span class="notetitle">Notes:</span> <dl><dt class="dlterm"><sup>1</sup></dt>
<dd>You can specify a program-described printer file so that the copy will
produce a list with no special formatting or page headings, or you can specify
TOFILE(*PRINT) to produce a formatted list. You can specify PRINT(*COPIED)
to produce a formatted list of the copied records, you can specify PRINT(*EXCLD)
to produce a formatted list of the records excluded by the INCCHAR or INCREL
parameter, and you can specify PRINT(*ERROR) to produce a formatted list of
records causing ERRLVL errors. When you request a list by specifying the TOFILE(*PRINT)
parameter, the OUTFMT parameter specifies whether the data is printed in character
or in both character and hexadecimal form.</dd>
</dl>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbal3copyfileover.htm" title="You can use the copy function to move data between device files, between database files (including distributed DB2 Multisystem files), or between device and database files.">Copy files: overview</a></div>
</div>
</div>
</body>
</html>