friedkiwi/ibm-information-center
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbp_5.4.0.1/rbafopresum.htm

423 lines
31 KiB
HTML
Raw Permalink Normal View History

Add readme and dist folders
2024-04-02 14:02:31 +00:00
<?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="Summary of runtime considerations for processing database files" />
<meta name="abstract" content="This topic shows the parameters that control your program's use of the database file member, where these parameters can be specified." />
<meta name="description" content="This topic shows the parameters that control your program's use of the database file member, where these parameters can be specified." />
<meta name="DC.subject" content="runtime, summary, run time" />
<meta name="keywords" content="runtime, summary, run time" />
<meta name="DC.Relation" scheme="URI" content="rbafopreopn.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="rbafopresum" />
<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>Summary of runtime considerations for processing database files</title>
</head>
<body id="rbafopresum"><a name="rbafopresum"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Summary of runtime considerations for processing database files</h1>
<div><p>This topic shows the parameters that control your program's use
of the database file member, where these parameters can be specified.</p>
<div class="section"><div class="p">For parameters that can be specified in more than one place, the
system merges the values. The Override with Database File (OVRDBF) command
parameters take precedence over program parameters, and Open Database File
(OPNDBF) or Open Query File (OPNQRYF) command parameters take precedence over
create or change file parameters. <div class="note"><span class="notetitle">Note:</span> Any override parameters other than
TOFILE, MBR, LVLCHK, SEQONLY, SHARE, WAITRCD, and INHWRT are ignored by the
OPNQRYF command.</div>
</div>
</div>
<div class="section"><p>A table of database processing
options specified on control language (CL) commands is shown here.</p>
</div>
<div class="tablenoborder"><a name="rbafopresum__rbafodbpc"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbafopresum__rbafodbpc" width="100%" frame="border" border="1" rules="all"><caption>Table 1. Database processing
options specified on CL commands</caption><thead align="left"><tr><th rowspan="2" align="center" valign="middle" width="13.320463320463322%" id="d0e54">Description</th>
<th rowspan="2" align="center" valign="middle" width="14.671814671814673%" id="d0e56">Parameter</th>
<th colspan="5" align="center" valign="bottom" id="d0e58">Command</th>
</tr>
<tr><th align="center" valign="bottom" width="16.795366795366796%" id="d0e61">CRTPF, CRTLF </th>
<th align="center" valign="bottom" width="14.285714285714285%" id="d0e63">CHGPF, CHGLF</th>
<th align="center" valign="bottom" width="13.8996138996139%" id="d0e65">OPNDBF</th>
<th align="center" valign="bottom" width="13.513513513513514%" id="d0e67">OPNQRYF</th>
<th align="center" valign="bottom" width="13.513513513513514%" id="d0e69">OVRDBF</th>
</tr>
</thead>
<tbody><tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">File name</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">FILE</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X<sup>1</sup></td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Library name</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 "> </td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X<sup>2</sup></td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Member name</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">MBR</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Member processing options</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">OPTION</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Record format lock state</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">RCDFMTLCK</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Starting file position after
open</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">POSITION</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Program performs only sequential
processing</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">SEQONLY</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Ignore keyed sequence access
path</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">ACCPTH</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Time to wait for file locks</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">WAITFILE</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X</td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Time to wait for record locks</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">WAITRCD</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X</td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Prevent overrides</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">SECURE</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Number of records to be transferred
from auxiliary to main storage</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">NBRRCDS</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Share open data path with other
programs</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">SHARE</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X</td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Format selector</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">FMTSLR</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X<sup>3</sup></td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X<sup>3</sup></td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Force ratio</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">FRCRATIO</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X</td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Inhibit write</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">INHWRT</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Level check record formats</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">LVLCHK</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X</td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Expiration date checking</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">EXPCHK</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Expiration date</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">EXPDATE</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X<sup>4</sup></td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X<sup>4</sup></td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Force access path</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">FRCACCPTH</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X</td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Commitment control</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">COMMIT</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">End-of-file delay</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">EOFDLY</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 ">X</td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Duplicate key check</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">DUPKEYCHK</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 "> </td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 "> </td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Reuse deleted record space</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">REUSEDLT</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X<sup>4</sup></td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X<sup>4</sup></td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Coded character set identifier</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">CCSID</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X<sup>4</sup></td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X<sup>4</sup></td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Sort Sequence</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">SRTSEQ</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X</td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td align="center" valign="top" width="13.320463320463322%" headers="d0e54 ">Language identifier</td>
<td align="center" valign="top" width="14.671814671814673%" headers="d0e56 ">LANGID</td>
<td align="center" valign="top" width="16.795366795366796%" headers="d0e58 d0e61 ">X</td>
<td align="center" valign="top" width="14.285714285714285%" headers="d0e58 d0e63 ">X</td>
<td align="center" valign="top" width="13.8996138996139%" headers="d0e58 d0e65 "> </td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e67 ">X</td>
<td align="center" valign="top" width="13.513513513513514%" headers="d0e58 d0e69 "> </td>
</tr>
<tr><td colspan="7" align="left" valign="top" headers="d0e54 d0e56 d0e58 d0e61 d0e63 d0e65 d0e67 d0e69 "><p><sup>1</sup> File
name: The CHGPF and CHGLF commands use the file name for identification only.
You cannot change the file name.</p>
<p><sup>2</sup> Library name: The CHGPF
and CHGLF commands use the library name for identification only. You cannot
change the library name.</p>
<p><sup>3</sup> Format selector: Used on the CRTLF
and CHGLF commands only.</p>
<p><sup>4</sup> Expiration date, reuse deleted
records, and coded character set identifier: Used on the CRTPF and CHGPF commands
only.</p>
</td>
</tr>
</tbody>
</table>
</div>
<div class="section"><p>A table of database processing options specified in programs is
shown here. </p>
</div>
<div class="tablenoborder"><a name="rbafopresum__rbafojunk"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rbafopresum__rbafojunk" width="100%" frame="border" border="1" rules="rows"><caption>Table 2. Database processing options specified
in programs</caption><thead align="left"><tr><th align="center" valign="middle" width="16.624040920716112%" id="d0e530">Description</th>
<th align="center" valign="bottom" width="16.624040920716112%" id="d0e532">RPG/400<sup>®</sup> Language</th>
<th align="center" valign="bottom" width="16.624040920716112%" id="d0e536">COBOL/400<sup>®</sup> Language</th>
<th align="center" valign="bottom" width="16.624040920716112%" id="d0e540"><span class="keyword">iSeries™</span> BASIC</th>
<th align="center" valign="bottom" width="16.879795396419436%" id="d0e545"><span class="keyword">iSeries</span> PL/I</th>
<th align="center" valign="bottom" width="16.624040920716112%" id="d0e550"><span class="keyword">iSeries</span> Pascal</th>
</tr>
</thead>
<tbody><tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">File name</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Library name</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Member name</td>
<td align="left" valign="top" width="16.624040920716112%" headers="d0e532 "> </td>
<td align="left" valign="top" width="16.624040920716112%" headers="d0e536 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Program record length</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Member processing options</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Record format lock state</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 "> </td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Record formats the program will use</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="left" valign="top" width="16.879795396419436%" headers="d0e545 "> </td>
<td align="left" valign="top" width="16.624040920716112%" headers="d0e550 "> </td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Clear physical file member of records</td>
<td align="left" valign="top" width="16.624040920716112%" headers="d0e532 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Program performs only sequential processing</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 "> </td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Ignore keyed sequence access path</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Share open data path with other programs</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 "> </td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 ">X</td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Level check record formats</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 ">X</td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 "> </td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Commitment control</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e532 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e540 "> </td>
<td align="center" valign="top" width="16.879795396419436%" headers="d0e545 ">X</td>
<td align="left" valign="top" width="16.624040920716112%" headers="d0e550 "> </td>
</tr>
<tr><td align="center" valign="top" width="16.624040920716112%" headers="d0e530 ">Duplicate key check</td>
<td align="left" valign="top" width="16.624040920716112%" headers="d0e532 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e536 ">X</td>
<td align="left" valign="top" width="16.624040920716112%" headers="d0e540 "> </td>
<td align="left" valign="top" width="16.879795396419436%" headers="d0e545 "> </td>
<td align="center" valign="top" width="16.624040920716112%" headers="d0e550 "> </td>
</tr>
<tr><td colspan="6" align="left" valign="top" headers="d0e530 d0e532 d0e536 d0e540 d0e545 d0e550 "><div class="note"><span class="notetitle">Note:</span> Control
language (CL) programs can also specify many of these parameters. See <a href="#rbafopresum__rbafodbpc">Table 1</a> for more information about the database
processing options that can be specified on CL commands.</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafopreopn.htm" title="These topics describe the file processing parameters and other methods or considerations that can affect database file processing.">Database file processing: Runtime considerations</a></div>
</div>
</div>
</body>
</html>
Reference in New Issue Copy Permalink