86 lines
7.8 KiB
HTML
86 lines
7.8 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="Select records without using DDS" />
|
||
|
|
<meta name="abstract" content="Dynamic record selection allows you to request a subset of the records in a file without using data description specifications (DDS)." />
|
||
|
|
<meta name="description" content="Dynamic record selection allows you to request a subset of the records in a file without using data description specifications (DDS)." />
|
||
|
|
<meta name="DC.subject" content="selecting, record, without using DDS, example, example, selecting records, without using DDS" />
|
||
|
|
<meta name="keywords" content="selecting, record, without using DDS, example, example, selecting records, without using DDS" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafoopnqf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafodynsrsex.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafoksapwodds.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafokfdf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafodynjf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafomrsjf.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafoukp.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafofdefd.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafodbz.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafogrp.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafoftop.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafosropn.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafoopnex.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="rbafodynrs" />
|
||
|
|
<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>Select records without using DDS</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafodynrs"><a name="rbafodynrs"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Select records without using DDS</h1>
|
||
|
|
<div><p>Dynamic record selection allows you to request a subset of the
|
||
|
|
records in a file without using data description specifications (DDS).</p>
|
||
|
|
<p>For example, you can select records that have a specific value or range
|
||
|
|
of values (for example, all customer numbers between 1000 and 1050). The Open
|
||
|
|
Query File (OPNQRYF) command allows you to combine these and other selection
|
||
|
|
functions to produce powerful record selection capabilities.</p>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafodynsrsex.htm">Select records using the Open Query File (OPNQRYF) command</a></strong><br />
|
||
|
|
These topics provide examples of selecting records using the Open Query File (OPNQRYF) command.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafoksapwodds.htm">Specify a keyed sequence access path without using DDS</a></strong><br />
|
||
|
|
The dynamic access path function allows you to specify a keyed access path for the data to be processed. If an access path that can be shared already exists, the system can share it. If a new access path is required, it is built before any records are passed to the program.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafokfdf.htm">Specify key fields from different files</a></strong><br />
|
||
|
|
A dynamic keyed sequence access path over a join logical file allows you to specify a processing sequence in which the keys can be in different physical files (DDS restricts the keys to the primary file).</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafodynjf.htm">Dynamically join database files without DDS</a></strong><br />
|
||
|
|
The dynamic join function allows you to join files without having to first specify data description specifications (DDS) and create a join logical file.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafomrsjf.htm">Handle missing records in secondary join files</a></strong><br />
|
||
|
|
The system allows you to control whether to allow defaults for missing records in secondary files (similar to the JDFTVAL DDS keyword for a join logical file). You can also specify that only records with defaults be processed. This allows you to select only those records in which there is a missing record in the secondary file.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafoukp.htm">Unique-key processing</a></strong><br />
|
||
|
|
Unique-key processing allows you to process only the first record of a group. The group is defined by one or more records with the same set of key values. Processing the first record implies that the records you receive will have unique keys.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafofdefd.htm">Define fields derived from existing field definitions</a></strong><br />
|
||
|
|
Listed here are the operations allowed by defining fields derived from existing field definitions.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafodbz.htm">Handle the divide-by-zero errors</a></strong><br />
|
||
|
|
Dividing by zero is considered an error by the Open Query File (OPNQRYF) command. This topic discusses how to handle the divide-by-zero error in case that you want a zero answer.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafogrp.htm">Summarize data from database file records (grouping)</a></strong><br />
|
||
|
|
The group processing function allows you to summarize data from existing database records.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafoftop.htm">Final total-only processing</a></strong><br />
|
||
|
|
Final-total-only processing is a special form of grouping in which you do not specify grouping fields. The output is only one record. All of the special built-in functions for grouping can be specified. You can also specify the selection of records that make up the final total.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafosropn.htm">Control how the system runs the Open Query File (OPNQRYF) command</a></strong><br />
|
||
|
|
The optimization function allows you to specify how you are going to use the results of the query.</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<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="rbafoopnex.htm" title="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.">Usage notes for Open Query File (OPNQRYF) command</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|