ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzakb_5.4.0.1/rzakbmsttdrefac.htm

84 lines
5.0 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="reference" />
<meta name="DC.Title" content="REFACCPTH (Reference Access Path Definition) keyword—logical files only" />
<meta name="abstract" content="Use this file-level keyword to specify that the access path information for this logical file is to be copied from another physical or logical file." />
<meta name="description" content="Use this file-level keyword to specify that the access path information for this logical file is to be copied from another physical or logical file." />
<meta name="DC.subject" content="REFACCPTH (Reference Access Path Definition) keyword, Reference Access Path Definition (REFACCPTH) keyword" />
<meta name="keywords" content="REFACCPTH (Reference Access Path Definition) keyword, Reference Access Path Definition (REFACCPTH) keyword" />
<meta name="DC.Relation" scheme="URI" content="rzakbmstlfkeyw.htm" />
<meta name="copyright" content="(C) Copyright IBM Corporation 2001, 2006" />
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2001, 2006" />
<meta name="DC.Format" content="XHTML" />
<meta name="DC.Identifier" content="tdrefac" />
<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>Physical and Logical Files, REFACCPTH</title>
</head>
<body id="tdrefac"><a name="tdrefac"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1"> REFACCPTH (Reference Access Path Definition) keyword—logical files
only</h1>
<div><p>Use this file-level keyword to specify that the access path information
for this logical file is to be copied from another physical or logical file.</p>
<div class="section"><p>The access path information includes key information, select and
omit information, alternative collating sequence information, dynamic select
information, and key sequencing information (specified in the FCFO, FIFO,
LIFO, and UNIQUE keywords).</p>
<div class="p">The format of the keyword is: <pre>REFACCPTH([library-name/]database-file-name)</pre>
</div>
<p>The
name of the file defining the access path is the parameter value for the keyword.</p>
<p>The
file containing the REFACCPTH keyword cannot contain key, select, or omit
fields.</p>
<p>The record format(s) in the file you are defining can contain
fewer or more fields than the record format(s) in the physical file on which
this logical file is based.</p>
<p>If the file specified on the REFACCPTH keyword
is a simple or multiple format logical file, it and the file containing the
REFACCPTH keyword must have the same physical files specified in the same
order on the PFILE keyword.</p>
<div class="p">The REFACCPTH keyword
is not allowed in join logical files. You can specify a join logical file
as the parameter value on the REFACCPTH keyword only if all the following
situations are true: <ul><li>The file you are creating is a simple logical file.</li>
<li>The physical file specified on the PFILE keyword is the first file specified
on the JFILE keyword in the join logical file.</li>
<li>The join logical file has key fields specified and does not have select
and omit fields specified.</li>
</ul>
</div>
<p>You cannot specify a distributed data management
(DDM) file on this keyword.</p>
<p>You cannot specify the REFACCPTH keyword
with the DYNSLT, ALTSEQ, FCFO, FIFO, LIFO, or UNIQUE keywords.</p>
</div>
<div class="example"><h4 class="sectiontitle">Example</h4><p>The following example shows how to specify
the REFACCPTH keyword.</p>
<pre>|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
00030A* ORDER HEADER LOGICAL FILE (ORDHDR11)
00040A REFACCPTH(DSTLIB/ORDHDRL)
00050A R ORDHDR PFILE(ORDHDRP)
A</pre>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzakbmstlfkeyw.htm" title="This topic lists valid keyword entries for describing physical and logical files. They are typed in positions 45 through 80 (functions).">Keyword entries for physical and logical files (positions 45 through 80)</a></div>
</div>
</div>
</body>
</html>