73 lines
4.2 KiB
HTML
73 lines
4.2 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="Extra record in secondary file (case 4)" />
|
||
|
|
<meta name="DC.subject" content="example, extra record in secondary file" />
|
||
|
|
<meta name="keywords" content="example, extra record in secondary file" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafox2phyf.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="rbafocase4" />
|
||
|
|
<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>Extra record in secondary file (case 4)</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafocase4"><a name="rbafocase4"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Extra record in secondary file (case 4)</h1>
|
||
|
|
<div><div class="section"><p>Assume that a join logical file is specified as in <a href="rbafox2phyf.htm#rbafox2phyf">Basic concepts of joining two physical files (example 1)</a>,
|
||
|
|
and four records are contained in PF1 and five records in PF2.</p>
|
||
|
|
<p>The record
|
||
|
|
for 301 exists only in PF2.</p>
|
||
|
|
<p>The program reads the join logical file
|
||
|
|
and gets only four records. The record for 301 does not appear.</p>
|
||
|
|
|
||
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" width="100%" frame="border" border="1" rules="all"><caption>Table 1. Join logical file (JLF)</caption><thead align="left"><tr valign="bottom"><th valign="bottom" width="33.33333333333333%" id="d0e34">Employee number</th>
|
||
|
|
<th valign="bottom" width="33.33333333333333%" id="d0e36">Name</th>
|
||
|
|
<th valign="bottom" width="33.33333333333333%" id="d0e38">Salary</th>
|
||
|
|
</tr>
|
||
|
|
</thead>
|
||
|
|
<tbody><tr><td valign="top" width="33.33333333333333%" headers="d0e34 ">235</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e36 ">Anne</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e38 ">1700.00</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="33.33333333333333%" headers="d0e34 ">440</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e36 ">Doug</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e38 ">950.50</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="33.33333333333333%" headers="d0e34 ">500</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e36 ">Mark</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e38 ">2100.00</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="33.33333333333333%" headers="d0e34 ">729</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e36 ">Sue</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e38 ">1400.90</td>
|
||
|
|
</tr>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
<p>These results would be the same even if the JDFTVAL keyword were
|
||
|
|
specified, because a record must always be contained in the primary file to
|
||
|
|
receive a join record.</p>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafox2phyf.htm" title="A join logical file is a logical file that combines (in one record format) fields from two or more physical files because in the record format not all the fields need to exist in all the physical files.">Basic concepts of joining two physical files (example 1)</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|