71 lines
4.5 KiB
HTML
71 lines
4.5 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="FCFO (First-Changed First-Out) keyword for physical and logical files" />
|
||
|
|
<meta name="abstract" content="Use this file-level keyword to specify that if records with duplicate key values are retrieved from the same physical or logical file member, the record with the key value that was changed first is the first record retrieved. This is a first-changed first-out (FCFO) order." />
|
||
|
|
<meta name="description" content="Use this file-level keyword to specify that if records with duplicate key values are retrieved from the same physical or logical file member, the record with the key value that was changed first is the first record retrieved. This is a first-changed first-out (FCFO) order." />
|
||
|
|
<meta name="DC.subject" content="FCFO (First-Changed First-Out) keyword, First-Changed First-Out (FCFO) keyword" />
|
||
|
|
<meta name="keywords" content="FCFO (First-Changed First-Out) keyword, First-Changed First-Out (FCFO) keyword" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzakbmstlfkeyw.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2001, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2001, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="tdfcfo" />
|
||
|
|
<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>Physical and Logical Files, FCFO</title>
|
||
|
|
</head>
|
||
|
|
<body id="tdfcfo"><a name="tdfcfo"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">FCFO (First-Changed First-Out) keyword for physical and logical files</h1>
|
||
|
|
<div><p>Use this file-level keyword to specify that if records with duplicate
|
||
|
|
key values are retrieved from the same physical or logical file member, the
|
||
|
|
record with the key value that was changed first is the first record retrieved.
|
||
|
|
This is a first-changed first-out (FCFO) order.</p>
|
||
|
|
<div class="section"><p>This keyword has no parameters.</p>
|
||
|
|
<p>FCFO is not allowed with
|
||
|
|
an FIFO, LIFO, UNIQUE, or REFACCPTH keyword.</p>
|
||
|
|
<p>If you do not specify FCFO,
|
||
|
|
LIFO, FIFO, or UNIQUE, records with duplicate key values are retrieved in
|
||
|
|
first-in first-out (FIFO), last-in first-out (LIFO), or first-changed first-out
|
||
|
|
(FCFO) order, but the order in which they are retrieved is not guaranteed.</p>
|
||
|
|
<p>With
|
||
|
|
the FCFO keyword, the records are ordered by the time the record
|
||
|
|
key value is changed. With the FIFO and LIFO keywords, the records are ordered
|
||
|
|
by the relative record number.</p>
|
||
|
|
<p>At least one key field must be specified
|
||
|
|
in the file containing the FCFO keyword. The FCFO keyword is not valid when
|
||
|
|
you specify FILETYPE(*SRC) on the Create Physical File (CRTPF) or Create Logical
|
||
|
|
File (CRTLF) command.</p>
|
||
|
|
</div>
|
||
|
|
<div class="example"><h4 class="sectiontitle">Example</h4><p>The following example shows how to specify
|
||
|
|
the FCFO keyword for a physical file.</p>
|
||
|
|
<pre>|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
|
||
|
|
00010A FCFO
|
||
|
|
00020A R CUSREC TEXT('CUSTOMER RECORD')
|
||
|
|
00030A CUSNAMEF 10A
|
||
|
|
00040A CUSNAMEM 1A
|
||
|
|
00050A CUSNAMEL 10A
|
||
|
|
00060A K CUSNAMEL
|
||
|
|
A</pre>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzakbmstlfkeyw.htm" title="This topic lists valid keyword entries for describing physical and logical files. They are typed in positions 45 through 80 (functions).">Keyword entries for physical and logical files (positions 45 through 80)</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|