69 lines
4.5 KiB
HTML
69 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="Step 4: Retrieve a row using a cursor" />
|
||
|
|
<meta name="abstract" content="To move the contents of a selected row into your program's host variables, use the FETCH statement. The SELECT statement within the DECLARE CURSOR statement identifies rows that contain the column values your program wants. However, SQL does not retrieve any data for your application program until the FETCH statement is issued." />
|
||
|
|
<meta name="description" content="To move the contents of a selected row into your program's host variables, use the FETCH statement. The SELECT statement within the DECLARE CURSOR statement identifies rows that contain the column values your program wants. However, SQL does not retrieve any data for your application program until the FETCH statement is issued." />
|
||
|
|
<meta name="DC.subject" content="cursor, retrieving a row, example, examples" />
|
||
|
|
<meta name="keywords" content="cursor, retrieving a row, example, examples" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafycursorexamp.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="rbafycurs4" />
|
||
|
|
<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>Step 4: Retrieve a row using a cursor</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafycurs4"><a name="rbafycurs4"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">Step 4: Retrieve a row using a cursor</h1>
|
||
|
|
<div><p>To move the contents of a selected row into your program's host
|
||
|
|
variables, use the FETCH statement. The SELECT statement within the DECLARE
|
||
|
|
CURSOR statement identifies rows that contain the column values your program
|
||
|
|
wants. However, SQL does not retrieve any data for your application program
|
||
|
|
until the FETCH statement is issued.</p>
|
||
|
|
<div class="section"><p>When your program issues the FETCH statement, SQL uses the current
|
||
|
|
cursor position as a starting point to locate the requested row in the result
|
||
|
|
table. This changes that row to the <strong>current row</strong>. If an INTO clause
|
||
|
|
was specified, SQL moves the current row's contents into your program's host
|
||
|
|
variables. This sequence is repeated each time the FETCH statement is issued.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>SQL maintains the position of the current row (that is, the cursor
|
||
|
|
points to the current row) until the next FETCH statement for the cursor is
|
||
|
|
issued. The UPDATE statement does not change the position of the current row
|
||
|
|
within the result table, although the DELETE statement does.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>The serial cursor FETCH statement looks like this: </p>
|
||
|
|
<pre>EXEC SQL
|
||
|
|
<strong>FETCH</strong> cursor-name
|
||
|
|
<strong>INTO</strong> :host variable-1[, :host variable-2] …
|
||
|
|
END-EXEC.</pre>
|
||
|
|
</div>
|
||
|
|
<div class="section"><p>The scrollable cursor FETCH statement looks like this: </p>
|
||
|
|
<pre>EXEC SQL
|
||
|
|
<strong>FETCH RELATIVE</strong> integer
|
||
|
|
<strong>FROM</strong> cursor-name
|
||
|
|
<strong>INTO</strong> :host variable-1[, :host variable-2] …
|
||
|
|
END-EXEC.</pre>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<div class="familylinks">
|
||
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafycursorexamp.htm" title="Suppose your program examines data about people in department D11. The following examples show the SQL statements you would include in a program to define and use a serial and a scrollable cursor.">Examples: Use a cursor</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|