ibm-information-center/dist/eclipse/plugins/i5OS.ic.dbp_5.4.0.1/rbafoopnex.htm

70 lines
5.4 KiB
HTML
Raw Permalink Normal View History

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="concept" />
<meta name="DC.Title" content="Usage notes for Open Query File (OPNQRYF) command" />
<meta name="abstract" content="These usage notes pertain to the examples in the topics that describe how to specify the parameters for the major functions of the Open Query File (OPNQRYF) command and how to use the OPNQRYF command with your high-level language program." />
<meta name="description" content="These usage notes pertain to the examples in the topics that describe how to specify the parameters for the major functions of the Open Query File (OPNQRYF) command and how to use the OPNQRYF command with your high-level language program." />
<meta name="DC.Relation" scheme="URI" content="rbafoopnqf.htm" />
<meta name="DC.Relation" scheme="URI" content="rbafoopncl.htm" />
<meta name="DC.Relation" scheme="URI" content="rbafozlt.htm" />
<meta name="DC.Relation" scheme="URI" content="rbafodynrs.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="rbafoopnex" />
<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>Usage notes for Open Query File (OPNQRYF) command </title>
</head>
<body id="rbafoopnex"><a name="rbafoopnex"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Usage notes for Open Query File (OPNQRYF) command </h1>
<div><p>These usage notes pertain to the examples in the topics that describe
how to specify the parameters for the major functions of the Open Query File
(OPNQRYF) command and how to use the OPNQRYF command with your high-level
language program.</p>
<div class="p"><div class="note"><span class="notetitle">Notes:</span> <ol><li>If you run the OPNQRYF command from a command entry line with the OPNSCOPE(*ACTGRPDFN)
or TYPE(*NORMAL) parameter option, error messages that occur after the OPNQRYF
command successfully runs will not close the file. Such messages
would have closed the file prior to Version 2 Release 3 when TYPE(*NORMAL)
was used. The system automatically runs the Reclaim Resources (RCLRSC) command
if an error message occurs, except for message CPF0001, which is sent when
the system detects an error in the command. However, the RCLRSC command only
closes files opened from the default activation group at a higher level in
the call stack than the level at which the RCLRSC command was run.</li>
<li>After running a program that uses the OPNQRYF command for sequential processing,
the file position is normally at the end of the file. If you want to run the
same program or a different program with the same files, you must position
the file or close the file and open it with the same OPNQRYF command. You
can position the file with the Position Database File (POSDBF) command. In
some cases, a high-level language program statement can be used.</li>
</ol>
</div>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafoopnqf.htm" title="The Open Query File (OPNQRYF) command is a control language (CL) command that allows you to perform many data processing functions on database files. These topics discuss how to create a query using the OPNQRYF command, how to specify parameters for its major functions, and how to use it with your high-level language program.">Use Open Query File (OPNQRYF) command</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="rbafozlt.htm" title="In the Open Query File (OPNQRYF) command, a zero-length literal is denoted as a quoted string with nothing, not even a blank, between the quotation marks (&#34;&#34;). Zero-length literal support changes the results of a comparison when used as the compare argument of the contains (*CT) function.">The zero-length literal and the contains (*CT) function</a></div>
<div><a href="rbafodynrs.htm" title="Dynamic record selection allows you to request a subset of the records in a file without using data description specifications (DDS).">Select records without using DDS</a></div>
</div>
<div class="reltasks"><strong>Related tasks</strong><br />
<div><a href="rbafoopncl.htm" title="The Open Query File (OPNQRYF) command has these basic rules that can prevent coding errors.">CL program coding with the Open Query File (OPNQRYF) command</a></div>
</div>
</div>
</body>
</html>