89 lines
5.2 KiB
HTML
89 lines
5.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="Record missing in secondary file: JDFTVAL keyword specified (case 2B)" />
|
||
|
|
<meta name="DC.subject" content="example, record missing in secondary file, JDFTVAL keyword specified" />
|
||
|
|
<meta name="keywords" content="example, record missing in secondary file, JDFTVAL keyword specified" />
|
||
|
|
<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="rbafocas2b" />
|
||
|
|
<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>Record missing in secondary file: JDFTVAL keyword specified (case 2B)</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafocas2b"><a name="rbafocas2b"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Record missing in secondary file: JDFTVAL keyword specified (case 2B)</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>,
|
||
|
|
except that the JDFTVAL keyword is specified, as shown in the following DDS:</p>
|
||
|
|
</div>
|
||
|
|
<div class="example"> <pre><strong>JLF</strong>
|
||
|
|
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
|
||
|
|
A JDFTVAL
|
||
|
|
A R JOINREC JFILE(PF1 PF2)
|
||
|
|
A J JOIN(PF1 PF2)
|
||
|
|
A JFLD(NBR NBR)
|
||
|
|
A NBR JREF(PF1)
|
||
|
|
A NAME
|
||
|
|
A SALARY
|
||
|
|
A K NBR
|
||
|
|
A</pre>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>The program reads the join logical file and gets the following
|
||
|
|
records.</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="d0e41">Employee number</th>
|
||
|
|
<th valign="bottom" width="33.33333333333333%" id="d0e43">Name</th>
|
||
|
|
<th valign="bottom" width="33.33333333333333%" id="d0e45">Salary</th>
|
||
|
|
</tr>
|
||
|
|
</thead>
|
||
|
|
<tbody><tr><td valign="top" width="33.33333333333333%" headers="d0e41 ">235</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e43 ">Anne</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e45 ">1700.00</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="33.33333333333333%" headers="d0e41 ">440</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e43 ">Doug</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e45 ">950.50</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="33.33333333333333%" headers="d0e41 ">500</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e43 ">Mark</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e45 ">0000.00</td>
|
||
|
|
</tr>
|
||
|
|
<tr><td valign="top" width="33.33333333333333%" headers="d0e41 ">729</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e43 ">Sue</td>
|
||
|
|
<td valign="top" width="33.33333333333333%" headers="d0e45 ">1400.90</td>
|
||
|
|
</tr>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
</div>
|
||
|
|
<p>With JDFTVAL specified, the system returns a record for 500, even
|
||
|
|
though the record is missing in PF2. Without that record, some field values
|
||
|
|
can be missing in the join record. In this case, the <em>Salary</em> field is
|
||
|
|
missing. With JDFTVAL specified, missing character fields normally use blanks;
|
||
|
|
missing numeric fields use zeros. Therefore, in this case, the value for the
|
||
|
|
missing record in the join record is 0. However, if the DFT keyword is specified
|
||
|
|
for the field in the physical file, the default value specified on the DFT
|
||
|
|
keyword is used.</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>
|