74 lines
4.6 KiB
HTML
74 lines
4.6 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="concept" />
|
||
|
<meta name="DC.Title" content="Example: A logical file specifying multiple formats and new keys" />
|
||
|
<meta name="abstract" content="The PFILE keyword is important in this example. The example uses new field specifications and provides two record formats. Each record format provides a different view of the associated physical file and uses a key different from the associated physical file." />
|
||
|
<meta name="description" content="The PFILE keyword is important in this example. The example uses new field specifications and provides two record formats. Each record format provides a different view of the associated physical file and uses a key different from the associated physical file." />
|
||
|
<meta name="DC.subject" content="examples of DDS, logical file with multiple formats and new keys, PFILE keyword" />
|
||
|
<meta name="keywords" content="examples of DDS, logical file with multiple formats and new keys, PFILE keyword" />
|
||
|
<meta name="DC.Relation" scheme="URI" content="rbafpmstexamp.htm" />
|
||
|
<meta name="copyright" content="(C) Copyright IBM Corporation 1999, 2006" />
|
||
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 1999, 2006" />
|
||
|
<meta name="DC.Format" content="XHTML" />
|
||
|
<meta name="DC.Identifier" content="logfileexamp" />
|
||
|
<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>Example: A logical file specifying multiple formats and new keys</title>
|
||
|
</head>
|
||
|
<body id="logfileexamp"><a name="logfileexamp"><!-- --></a>
|
||
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
<h1 class="topictitle1">Example: A logical file specifying multiple formats and new keys</h1>
|
||
|
<div><p>The PFILE keyword is important in this example. The example uses
|
||
|
new field specifications and provides two record formats. Each record format
|
||
|
provides a different view of the associated physical file and uses a key different
|
||
|
from the associated physical file.</p>
|
||
|
<div class="fignone" id="logfileexamp__o4"><a name="logfileexamp__o4"><!-- --></a><span class="figcap">Figure 1. DDS for a logical file specifying new keys</span><pre>|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
|
||
|
00010A*
|
||
|
00020A* SAMPLE LOGICAL FILE
|
||
|
00030A
|
||
|
00040A R CUSMST1 <strong>(1)</strong>PFILE(CUSMSTP)
|
||
|
00050A ACTNUM
|
||
|
00060A NAME
|
||
|
00070A STATE
|
||
|
00080A LASTNAME I <strong>(3)</strong>SST(NAME 8 10)
|
||
|
00090A <strong>(2)</strong> K ACTNUM
|
||
|
00100A*
|
||
|
00110A R CUSMST2 <strong>(1)</strong>PFILE(CUSMSTP)
|
||
|
00120A ACTNUM
|
||
|
00130A NAME
|
||
|
00140A ZIP
|
||
|
00150A K *NONE
|
||
|
00160A <strong>(2)</strong> K NAME
|
||
|
A</pre>
|
||
|
</div>
|
||
|
<div class="p"><strong>Legend: </strong> <dl><dt class="dlterm">(1)</dt>
|
||
|
<dd>The two record formats (CUSMST1 and CUSMST2) in this logical file are
|
||
|
based on the same physical file (CUSMSTP).</dd>
|
||
|
<dt class="dlterm">(2)</dt>
|
||
|
<dd>Record format CUSMST1 has a key different from record format CUSMST2,
|
||
|
providing the application program with a different sequence of the same records.</dd>
|
||
|
<dt class="dlterm">(3)</dt>
|
||
|
<dd>The LASTNAME field is a substring of the field NAME. The usage I in position
|
||
|
38 must be specified because this is not a join logical file.</dd>
|
||
|
</dl>
|
||
|
</div>
|
||
|
</div>
|
||
|
<div>
|
||
|
<div class="familylinks">
|
||
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafpmstexamp.htm" title="This topic provides examples of data description specifications (DDS) for each type of file discussed in this topic. If you choose, you can use the examples in this topic with appropriate high-level language programs.">Examples: DDS for each file type</a></div>
|
||
|
</div>
|
||
|
</div>
|
||
|
</body>
|
||
|
</html>
|