115 lines
8.6 KiB
HTML
115 lines
8.6 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="SQL programming" />
|
||
|
|
<meta name="abstract" content="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." />
|
||
|
|
<meta name="description" content="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." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafywhatsnew.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyprintthis.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyintro.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafysqltech.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafydml.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyussisql.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyprotect.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyroutines.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyusoocap.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafydynamic.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafydrda.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafyreference.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rbafysamptblx.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../rzajp/rzajpkickoff.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="../db2/rbafzmst02.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="rbafykickoff" />
|
||
|
|
<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>SQL programming</title>
|
||
|
|
</head>
|
||
|
|
<body id="rbafykickoff"><a name="rbafykickoff"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">SQL programming</h1>
|
||
|
|
<div><p>These topics describe the <span class="keyword">iSeries™</span> server
|
||
|
|
implementation of the Structured Query Language (SQL) using <span class="keyword">DB2<sup>®</sup> UDB for iSeries</span> and
|
||
|
|
the <span class="keyword">DB2 UDB Query Manager and SQL Development Kit</span> Version 5 licensed
|
||
|
|
program.</p>
|
||
|
|
<p>The examples of SQL statements shown in this topic collection are based
|
||
|
|
on the sample tables and assume the following: </p>
|
||
|
|
<ul><li>They are shown in the interactive SQL environment or they are written
|
||
|
|
in ILE C or in <span class="keyword">COBOL</span>.
|
||
|
|
EXEC SQL and END-EXEC are used to delimit an SQL statement in a <span class="keyword">COBOL</span> program. </li>
|
||
|
|
<li>Each SQL example is shown on several lines, with each clause of the statement
|
||
|
|
on a separate line.</li>
|
||
|
|
<li>SQL keywords are highlighted.</li>
|
||
|
|
<li>Table names provided in the sample tables use the schema CORPDATA. Table
|
||
|
|
names that are not found in the Sample Tables should use schemas you create.</li>
|
||
|
|
<li>Calculated columns are enclosed in parentheses, (), and brackets, [].</li>
|
||
|
|
<li>The SQL naming convention is used.</li>
|
||
|
|
<li>The APOST and APOSTSQL precompiler options are assumed although they are
|
||
|
|
not the default options in <span class="keyword">COBOL</span>.
|
||
|
|
Character string literals within SQL and host language statements are delimited
|
||
|
|
by single-quotation marks (').</li>
|
||
|
|
<li>A sort sequence of *HEX is used, unless otherwise noted.</li>
|
||
|
|
</ul>
|
||
|
|
<p>Whenever the examples vary from these assumptions, it is stated.</p>
|
||
|
|
<p>Because this topic collection is for the application programmer,
|
||
|
|
most of the examples are shown as if they were written in an application program.
|
||
|
|
However, many examples can be slightly changed and run interactively by using
|
||
|
|
interactive SQL. The syntax of an SQL statement, when using interactive SQL,
|
||
|
|
differs slightly from the format of the same statement when it is embedded
|
||
|
|
in a program.</p>
|
||
|
|
<div class="note"><span class="notetitle">Note:</span> By using the code examples, you agree to the terms of the <a href="codedisclaimer.htm">Code license and disclaimer information</a>.</div>
|
||
|
|
</div>
|
||
|
|
<div>
|
||
|
|
<ul class="ullinks">
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafywhatsnew.htm">What's new for V5R4</a></strong><br />
|
||
|
|
This topic highlights the changes made to this topic collection for V5R4.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyprintthis.htm">Printable PDF</a></strong><br />
|
||
|
|
Use this to view and print a PDF of this information.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyintro.htm">Introduction to DB2 UDB for iSeries Structured Query Language</a></strong><br />
|
||
|
|
<span>These topics describe the <span class="keyword">iSeries</span> server implementation of the
|
||
|
|
Structured Query Language (SQL) using <span class="keyword">DB2 UDB for iSeries</span> and
|
||
|
|
the <span class="keyword">DB2 UDB Query Manager and SQL Development Kit</span> licensed program.</span></li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafysqltech.htm">Data definition language (DDL)</a></strong><br />
|
||
|
|
Data definition language (DDL) describes the portion of SQL that allows you to create, alter, and destroy database objects. These database objects include schemas, tables, views, sequences, catalogs, indexes, and aliases.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafydml.htm">Data manipulation language</a></strong><br />
|
||
|
|
Data manipulation language (DML) describes the portion of SQL that allows you to manipulate or control your data.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyussisql.htm">Sort sequences and normalization in SQL</a></strong><br />
|
||
|
|
A sort sequence defines how characters in a character set relate to each other when they are compared or ordered. Normalization allows you to compare strings that contain combining characters.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyprotect.htm">Data protection</a></strong><br />
|
||
|
|
This topic describes the security plan for protecting SQL data from unauthorized users and the methods for ensuring data integrity.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyroutines.htm">Routines</a></strong><br />
|
||
|
|
Routines are pieces of code or programs that you can call to perform operations.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyusoocap.htm">Process special data types</a></strong><br />
|
||
|
|
Most data types, such as INTEGER and CHARACTER, do not have any special processing characteristics. However, there are a few data types that require special functions or locators in order to use them.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafydynamic.htm">Use SQL in different environments</a></strong><br />
|
||
|
|
You can use SQL in many different environments. Some of them are discussed here.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafydrda.htm">Distributed relational database function and SQL</a></strong><br />
|
||
|
|
A <dfn class="term">distributed relational database</dfn> consists of a set
|
||
|
|
of SQL objects that are spread across interconnected computer systems.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rbafyreference.htm">Reference information</a></strong><br />
|
||
|
|
Reference information for SQL programming includes sample tables and CL commands.</li>
|
||
|
|
</ul>
|
||
|
|
<div class="relref"><strong>Related reference</strong><br />
|
||
|
|
<div><a href="rbafysamptblx.htm" title="This topic contains the sample tables referred to and used in this topic and the SQL Reference topic collection.">DB2 UDB for iSeries sample tables</a></div>
|
||
|
|
</div>
|
||
|
|
<div class="relinfo"><strong>Related information</strong><br />
|
||
|
|
<div><a href="../rzajp/rzajpkickoff.htm">Embedded SQL programming</a></div>
|
||
|
|
<div><a href="../db2/rbafzmst02.htm">SQL reference</a></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|