56 lines
3.8 KiB
HTML
56 lines
3.8 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 message concepts" />
|
|
<meta name="abstract" content="SQL messages are displayed when a DB2 Universal Database for iSeries returns an error or warning code to the application that uses it." />
|
|
<meta name="description" content="SQL messages are displayed when a DB2 Universal Database for iSeries returns an error or warning code to the application that uses it." />
|
|
<meta name="DC.Relation" scheme="URI" content="rzalakickoff.htm" />
|
|
<meta name="DC.Relation" scheme="URI" content="rzalaml.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="sqlmessconcept" />
|
|
<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 message concepts</title>
|
|
</head>
|
|
<body id="sqlmessconcept"><a name="sqlmessconcept"><!-- --></a>
|
|
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
|
|
<h1 class="topictitle1">SQL message concepts</h1>
|
|
<div><p>SQL messages are displayed when a DB2 Universal Database™ for iSeries™ returns
|
|
an error or warning code to the application that uses it.</p>
|
|
<p>To find a specific message, SQLCODE, or SQLSTATE, try the <a href="rzalafinder.htm">SQL message finder</a>.</p>
|
|
<p><strong>Use Display Message Description (DSPMSGD) to display a message description</strong></p>
|
|
<p>Detailed descriptions of all DB2<sup>®</sup> UDB for iSeries messages, including SQLCODEs,
|
|
are available in message file QSQLMSG. You can display and print them from
|
|
the Display Message Description display. The CL command to display the message
|
|
description is DSPMSGD. This command shows you both the first level and the
|
|
second level text for the message. The first level is a short, single sentence
|
|
version of the message. The second level generally describes the reason in
|
|
more detail and provides suggested solutions.</p>
|
|
<div class="p">To show the message that corresponds to SQLCODE 0204, type the following
|
|
command:<pre>DSPMSGD RANGE(SQL0204) MSGF(QSYS/QSQLMSG)</pre>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzalakickoff.htm" title="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.">SQL messages and codes</a></div>
|
|
</div>
|
|
<div class="relref"><strong>Related reference</strong><br />
|
|
<div><a href="rzalaml.htm" title="These tables list SQL messages. Use these tables to find message text, cause text, recovery text, and corresponding SQLCODEs and SQLSTATEs.">Listing of SQL messages</a></div>
|
|
</div>
|
|
</div>
|
|
</body>
|
|
</html> |