69 lines
5.1 KiB
HTML
69 lines
5.1 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 messages and codes" />
|
||
|
|
<meta name="abstract" content="Use this topic to find descriptions of codes and messages returned when using SQL with DB2 Universal Database for iSeries (DB2 UDB for iSeries). This topic contains listings of SQLCODEs, SQLSTATEs, class codes, and SQL messages." />
|
||
|
|
<meta name="description" content="Use this topic to find descriptions of codes and messages returned when using SQL with DB2 Universal Database for iSeries (DB2 UDB for iSeries). This topic contains listings of SQLCODEs, SQLSTATEs, class codes, and SQL messages." />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzalawhatnew.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzalaprintthis.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzalaco.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzalaclass.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzalaccl.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzalamess.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzalaml.htm" />
|
||
|
|
<meta name="DC.Relation" scheme="URI" content="rzalafinder.htm" />
|
||
|
|
<meta name="copyright" content="(C) Copyright IBM Corporation 2001, 2006" />
|
||
|
|
<meta name="DC.Rights.Owner" content="(C) Copyright IBM Corporation 2001, 2006" />
|
||
|
|
<meta name="DC.Format" content="XHTML" />
|
||
|
|
<meta name="DC.Identifier" content="rzalakickoff.dita" />
|
||
|
|
<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 messages and codes</title>
|
||
|
|
</head>
|
||
|
|
<body id="rzalakickoff.dita"><a name="rzalakickoff.dita"><!-- --></a>
|
||
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
||
|
|
<h1 class="topictitle1">SQL messages and codes</h1>
|
||
|
|
<div><p>Use this topic to find descriptions of codes and messages returned
|
||
|
|
when using SQL with DB2 Universal Database™ for iSeries™ (DB2<sup>®</sup> UDB
|
||
|
|
for iSeries).
|
||
|
|
This topic contains listings of SQLCODEs, SQLSTATEs, class codes, and SQL
|
||
|
|
messages.</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="rzalawhatnew.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="rzalaprintthis.htm">Printable PDF</a></strong><br />
|
||
|
|
Use this to view and print a PDF of this information.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzalaco.htm">SQLCODE and SQLSTATE concepts</a></strong><br />
|
||
|
|
This reference provides a list of SQLCODEs and their associated SQLSTATEs. In this reference, you can find instructions for finding a SQLCODE in the message file along with the text for these messages.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzalaclass.htm">Listing of SQLSTATE class codes</a></strong><br />
|
||
|
|
The table below provides a list of general SQLSTATE classes. Each class links to a list of the more specific SQLSTATE codes that comprise that class.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzalaccl.htm">Listing of SQLSTATE values</a></strong><br />
|
||
|
|
The tables in this topic provide descriptions of SQLSTATE codes
|
||
|
|
that can be returned to applications by DB2 UDB for iSeries. The tables include SQLSTATE
|
||
|
|
values, their meanings, and their corresponding SQLCODE values. </li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzalamess.htm">SQL message concepts</a></strong><br />
|
||
|
|
SQL messages are displayed when a DB2 Universal Database for iSeries returns
|
||
|
|
an error or warning code to the application that uses it.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzalaml.htm">Listing of SQL messages</a></strong><br />
|
||
|
|
These tables list SQL messages. Use these tables to find message text, cause text, recovery text, and corresponding SQLCODEs and SQLSTATEs.</li>
|
||
|
|
<li class="ulchildlink"><strong><a href="rzalafinder.htm">SQL message finder</a></strong><br />
|
||
|
|
Use the SQL message finder to quickly find specific SQL codes and messages. This tool allows you to search for an SQLCODE, message ID, SQLSTATE, or SQLSTATE class code.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|