49 lines
2.9 KiB
HTML
49 lines
2.9 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="Subqueries" />
|
|
<meta name="abstract" content="Subqueries can be selected on any display that has a WHERE or HAVING clause." />
|
|
<meta name="description" content="Subqueries can be selected on any display that has a WHERE or HAVING clause." />
|
|
<meta name="DC.subject" content="subquery, prompting, interactive SQL, prompting subquery" />
|
|
<meta name="keywords" content="subquery, prompting, interactive SQL, prompting subquery" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyprompting.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="rbafyprompt3" />
|
|
<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>Subqueries</title>
|
|
</head>
|
|
<body id="rbafyprompt3"><a name="rbafyprompt3"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Subqueries</h1>
|
|
<div><p>Subqueries can be selected on any display that has a WHERE or HAVING
|
|
clause.</p>
|
|
<div class="section"><p>To see the subquery display, press F9=Specify subquery when the
|
|
cursor is on a WHERE or HAVING input line. A display appears that allows you
|
|
to type in subselect information. If the cursor is within the parentheses
|
|
of the subquery when F9 is pressed, the subquery information is filled in
|
|
on the next display. If the cursor is outside the parentheses of the subquery,
|
|
the next display is blank.</p>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafyprompting.htm" title="The prompt function helps you supply the necessary information for the syntax of the statement you want to use. The prompt function can be used in any of these statement processing modes: *RUN, *VLD, and *SYN.">Prompting</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |