81 lines
5.1 KiB
HTML
81 lines
5.1 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 physical file with a new record format" />
|
|
<meta name="abstract" content="The REF keyword is important in this example. This file has one record format. The names of all fields in the record format are specified. This example uses fields in a reference file (REF keyword) and uses a keyed-sequence access path." />
|
|
<meta name="description" content="The REF keyword is important in this example. This file has one record format. The names of all fields in the record format are specified. This example uses fields in a reference file (REF keyword) and uses a keyed-sequence access path." />
|
|
<meta name="DC.subject" content="examples of DDS, physical file with new record format, REF keyword" />
|
|
<meta name="keywords" content="examples of DDS, physical file with new record format, REF 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="physfileexamp" />
|
|
<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 physical file with a new record format</title>
|
|
</head>
|
|
<body id="physfileexamp"><a name="physfileexamp"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Example: A physical file with a new record format</h1>
|
|
<div><p>The REF keyword is important in this example. This file has one
|
|
record format. The names of all fields in the record format are specified.
|
|
This example uses fields in a reference file (REF keyword) and uses a keyed-sequence
|
|
access path.</p>
|
|
<p>The following physical file (called CUSMSTP for customer master physical
|
|
file) describes the fields physically present in the database.</p>
|
|
<div class="fignone" id="physfileexamp__o2"><a name="physfileexamp__o2"><!-- --></a><span class="figcap">Figure 1. DDS for a physical file</span><pre>|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
|
|
00010A*
|
|
00020A* SAMPLE PHYSICAL FILE(CUSMSTP)
|
|
00030A*
|
|
00040A <strong>(1)</strong> REF(MLGREFP)
|
|
00050A <strong>(2)</strong> R CUSMST TEXT('Customer Master Record')
|
|
00060A ACTNUM R <strong>(3)</strong>
|
|
00070A NAME R <strong>(3)</strong>
|
|
00080A ADDR R <strong>(3)</strong>
|
|
00090A CITY R <strong>(3)</strong>
|
|
00100A STATE R <strong>(3)</strong>
|
|
00110A ZIP R <strong>(3)</strong>
|
|
00120A <strong>(4)</strong> SEARCH 10 0
|
|
00130A <strong>(4)</strong> CRDLMT 8 2
|
|
00140A <strong>(5)</strong> K ACTNUM
|
|
A</pre>
|
|
</div>
|
|
<p><strong>Legend:</strong></p>
|
|
<dl><dt class="dlterm">(1)</dt>
|
|
<dd>At the file level, the REF keyword refers the <span class="keyword">i5/OS™</span> operating system to the physical
|
|
file MLGREFP, which is a field reference file for this database.</dd>
|
|
<dt class="dlterm">(2)</dt>
|
|
<dd>At the record level, R in position 17 specifies that CUSMST is the record
|
|
format name of the record in this file. (There can only be one record format
|
|
in a physical file.)</dd>
|
|
<dt class="dlterm">(3)</dt>
|
|
<dd>At the field level, Rs in position 29 specify that the attributes of fields
|
|
of the same name in the REF file are to be used as attributes of these fields.</dd>
|
|
<dt class="dlterm">(4)</dt>
|
|
<dd>The fields SEARCH and CRDLMT are not defined in MLGREFP; therefore, their
|
|
field attributes are specified here.</dd>
|
|
<dt class="dlterm">(5)</dt>
|
|
<dd>At the key field level, K in position 17 specifies that ACTNUM is the
|
|
key field for the file.</dd>
|
|
</dl>
|
|
</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> |