friedkiwi/ibm-information-center
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbp_5.4.0.1/rbafoj3mpf.htm

194 lines
9.5 KiB
HTML
Raw Permalink Normal View History

Add readme and dist folders
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="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="Join three or more physical files (example 7)" />
<meta name="abstract" content="You can use a join logical file to join as many as 32 physical files. These files must be specified on the JFILE keyword. The first file specified on the JFILE keyword is the primary file; the other files are all secondary files." />
<meta name="description" content="You can use a join logical file to join as many as 32 physical files. These files must be specified on the JFILE keyword. The first file specified on the JFILE keyword is the primary file; the other files are all secondary files." />
<meta name="DC.subject" content="joining, three or more physical files, example, physical file, three or more, example, example, three or more physical files" />
<meta name="keywords" content="joining, three or more physical files, example, physical file, three or more, example, example, three or more physical files" />
<meta name="DC.Relation" scheme="URI" content="rbafojnlof.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="rbafoj3mpf" />
<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>Join three or more physical files (example 7)</title>
</head>
<body id="rbafoj3mpf"><a name="rbafoj3mpf"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Join three or more physical files (example 7)</h1>
<div><p>You can use a join logical file to join as many as 32 physical
files. These files must be specified on the JFILE keyword. The first file
specified on the JFILE keyword is the primary file; the other files are all
secondary files.</p>
<div class="section"><p>The physical files must be joined in pairs, with each pair described
by a join specification. Each join specification must have one or more join
fields identified.</p>
</div>
<div class="section"><p>The following chart shows the fields in the files and one field
common to all the physical files in the logical file:</p>
</div>
<div class="section"><br /><img src="rbafo529.gif" alt="Examples of records" /><br /></div>
<div class="section"><p>The join logical file (JLF2) contains <em>Name</em>, <em>Address</em>, <em>Telephone</em>,
and <em>Salary</em>. Physical file 1 (PF1) has <em>Name</em> and <em>Address</em>,
physical file 2 (PF2) has <em>Name</em> and <em>Telephone</em>, and physical file
3 (PF3) has <em>Name</em> and <em>Salary.</em> In this example, the <em>Name</em> field
is common to all the physical files (PF1, PF2, and PF3), and serves as the
join field.</p>
</div>
<div class="section"><p>The following example shows the data description specifications
(DDS) for the physical and logical files:</p>
</div>
<div class="example"> <pre><strong>JLF</strong>
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
A R JOINREC JFILE(PF1 PF2 P3)
A J JOIN(PF1 PF2)
A JFLD(NAME NAME)
A J JOIN(PF2 PF3)
A JFLD(NAME NAME)
A NAME JREF(PF1)
A ADDR
A TELEPHONE
A SALARY
A K NAME
A
<strong>PF1</strong>
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
A R REC1
A NAME 10
A ADDR 20
A K NAME
A
<strong>PF2</strong>
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
A R REC2
A NAME 10
A TELEPHONE 7
A K NAME
A
<strong>PF3</strong>
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
A R REC3
A NAME 10
A SALARY 9 2
A K NAME
A</pre>
</div>
<div class="section"><p>Assume that the physical files have the following records.</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><caption>Table 1. Physical file 1 (PF1)</caption><thead align="left"><tr valign="bottom"><th valign="bottom" id="d0e105">Name</th>
<th valign="bottom" id="d0e107">Address</th>
</tr>
</thead>
<tbody><tr><td valign="top" headers="d0e105 ">Anne</td>
<td valign="top" headers="d0e107 ">120 1st St.</td>
</tr>
<tr><td valign="top" headers="d0e105 ">Doug</td>
<td valign="top" headers="d0e107 ">40 Pillsbury</td>
</tr>
<tr><td valign="top" headers="d0e105 ">Mark</td>
<td valign="top" headers="d0e107 ">2 Lakeside Dr.</td>
</tr>
<tr><td valign="top" headers="d0e105 ">Tom</td>
<td valign="top" headers="d0e107 ">335 Elm St.</td>
</tr>
</tbody>
</table>
</div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><caption>Table 2. Physical file 2 (PF2)</caption><thead align="left"><tr valign="bottom"><th valign="bottom" id="d0e138">Name</th>
<th valign="bottom" id="d0e140">Telephone</th>
</tr>
</thead>
<tbody><tr><td valign="top" headers="d0e138 ">Anne</td>
<td valign="top" headers="d0e140 ">555–1111</td>
</tr>
<tr><td valign="top" headers="d0e138 ">Doug</td>
<td valign="top" headers="d0e140 ">555–5555</td>
</tr>
<tr><td valign="top" headers="d0e138 ">Mark</td>
<td valign="top" headers="d0e140 ">555–0000</td>
</tr>
<tr><td valign="top" headers="d0e138 ">Sue</td>
<td valign="top" headers="d0e140 ">555–3210 </td>
</tr>
</tbody>
</table>
</div>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><caption>Table 3. Physical file 3 (PF3)</caption><thead align="left"><tr valign="bottom"><th valign="bottom" id="d0e171">Name</th>
<th valign="bottom" id="d0e173">Salary</th>
</tr>
</thead>
<tbody><tr><td valign="top" headers="d0e171 ">Anne</td>
<td valign="top" headers="d0e173 ">1700.00</td>
</tr>
<tr><td valign="top" headers="d0e171 ">Doug</td>
<td valign="top" headers="d0e173 ">950.00</td>
</tr>
<tr><td valign="top" headers="d0e171 ">Mark</td>
<td valign="top" headers="d0e173 ">2100.00 </td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="section"><p>The program reads the following logical file records.</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><caption>Table 4. Join logical file (JLF)</caption><thead align="left"><tr valign="bottom"><th valign="bottom" width="25%" id="d0e204">Name</th>
<th valign="bottom" width="25%" id="d0e206">Address</th>
<th valign="bottom" width="25%" id="d0e208">Telephone</th>
<th valign="bottom" width="25%" id="d0e210">Salary</th>
</tr>
</thead>
<tbody><tr><td valign="top" width="25%" headers="d0e204 ">Anne</td>
<td valign="top" width="25%" headers="d0e206 ">120 1st St.</td>
<td valign="top" width="25%" headers="d0e208 ">555–1111</td>
<td valign="top" width="25%" headers="d0e210 ">1700.00</td>
</tr>
<tr><td valign="top" width="25%" headers="d0e204 ">Doug</td>
<td valign="top" width="25%" headers="d0e206 ">40 Pillsbury</td>
<td valign="top" width="25%" headers="d0e208 ">555–5555</td>
<td valign="top" width="25%" headers="d0e210 ">950.00</td>
</tr>
<tr><td valign="top" width="25%" headers="d0e204 ">Mark</td>
<td valign="top" width="25%" headers="d0e206 ">2 Lakeside Dr..</td>
<td valign="top" width="25%" headers="d0e208 ">555–0000</td>
<td valign="top" width="25%" headers="d0e210 ">2100.00</td>
</tr>
<tr><td valign="top" width="25%" headers="d0e204 ">Doug</td>
<td valign="top" width="25%" headers="d0e206 ">40 Pillsbury</td>
<td valign="top" width="25%" headers="d0e208 ">555–5555</td>
<td valign="top" width="25%" headers="d0e210 ">&nbsp;</td>
</tr>
</tbody>
</table>
</div>
<p>No record is returned for Tom because a record is not found for
him in PF2 and PF3 and the JDFTVAL keyword is not specified. No record is
returned for Sue because the primary file has no record for Sue.</p>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafojnlof.htm" title="These topics provide examples to illustrate how to set up a join logical file. Performance, integrity, and a summary of rules for join logical files are also included.">Set up a join logical file</a></div>
</div>
</div>
</body>
</html>
Reference in New Issue Copy Permalink