59 lines
4.2 KiB
HTML
59 lines
4.2 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="Use SQL in different environments" />
|
|
<meta name="abstract" content="You can use SQL in many different environments. Some of them are discussed here." />
|
|
<meta name="description" content="You can use SQL in many different environments. Some of them are discussed here." />
|
|
<meta name="DC.Relation" scheme="URI" content="rbafykickoff.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbafycurs.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbafydynmic.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbafydynamicsqlclient.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyintract.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyrunstat.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="rbafydynamic" />
|
|
<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>Use SQL in different environments</title>
|
|
</head>
|
|
<body id="rbafydynamic"><a name="rbafydynamic"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">Use SQL in different environments</h1>
|
|
<div><p>You can use SQL in many different environments. Some of them are
|
|
discussed here.</p>
|
|
</div>
|
|
<div>
|
|
<ul class="ullinks">
|
|
<li class="ulchildlink"><strong><a href="rbafycurs.htm">Use a cursor</a></strong><br />
|
|
When SQL runs a select statement, the resulting rows comprise the result table. A cursor provides a way to access a result table.</li>
|
|
<li class="ulchildlink"><strong><a href="rbafydynmic.htm">Dynamic SQL applications</a></strong><br />
|
|
Dynamic SQL allows an application to define and run SQL statements at program run time. An application that provides for dynamic SQL accepts as input (or builds) an SQL statement in the form of a character string. The application does not need to know what type of SQL statement it will run.</li>
|
|
<li class="ulchildlink"><strong><a href="rbafydynamicsqlclient.htm">Use of dynamic SQL through client interfaces</a></strong><br />
|
|
You can access <span class="keyword">DB2<sup>®</sup> UDB for iSeries™</span> data
|
|
through client interfaces on the server.</li>
|
|
<li class="ulchildlink"><strong><a href="rbafyintract.htm">Use interactive SQL</a></strong><br />
|
|
Interactive SQL allows the programmer or database administrator to quickly and easily define, update, delete, or look at data for testing, problem analysis, and database maintenance.</li>
|
|
<li class="ulchildlink"><strong><a href="rbafyrunstat.htm">Use the SQL statement processor</a></strong><br />
|
|
The SQL statement processor allows SQL statements to be run from a source member. The statements in the source member can be run repeatedly, or changed, without compiling the source. This makes the setup of a database environment easier.</li>
|
|
</ul>
|
|
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rbafykickoff.htm" title="These topics describe the iSeries server implementation of the Structured Query Language (SQL) using DB2 UDB for iSeries and the DB2 UDB Query Manager and SQL Development Kit Version 5 licensed program.">SQL programming</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |