friedkiwi/ibm-information-center
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
master
ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzaii_5.4.0.1/rzaiiodbc23.htm

139 lines
7.1 KiB
HTML
Raw Permalink Normal View History

Add readme and dist folders
2024-04-02 14:02:31 +00:00
<?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="iSeries Access ODBC error messages" />
<meta name="abstract" content="When an error occurs, the iSeries Access ODBC driver returns the SQLSTATE (an ODBC error code) and an error message. The driver obtains this information both from errors that are detected by the driver and from errors that are returned by the DBMS." />
<meta name="description" content="When an error occurs, the iSeries Access ODBC driver returns the SQLSTATE (an ODBC error code) and an error message. The driver obtains this information both from errors that are detected by the driver and from errors that are returned by the DBMS." />
<meta name="DC.Relation" scheme="URI" content="rzaiiodbc22.htm" />
<meta name="DC.Relation" scheme="URI" content="../rzaik/rzaikrccaexpress.htm" />
<meta name="DC.Relation" scheme="URI" content="rzaiiodbc34.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="rzaiiodbc23" />
<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>iSeries Access
ODBC error messages</title>
</head>
<body id="rzaiiodbc23"><a name="rzaiiodbc23"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">iSeries Access
ODBC error messages</h1>
<div><p>When an error occurs, the iSeries™ Access ODBC driver returns the
SQLSTATE (an ODBC error code) and an error message. The driver obtains this
information both from errors that are detected by the driver and from errors
that are returned by the DBMS.</p>
<p>For errors that occur in the data source, the iSeries Access ODBC Driver maps the returned
native error to the appropriate SQLSTATE. When both the iSeries Access
ODBC driver and the Microsoft<sup>®</sup> Driver Manager detect an
error, they generate the appropriate SQLSTATE. The iSeries Access ODBC driver returns an
error message based on the message returned by the DBMS.</p>
<p>For errors that occur in the iSeries Access ODBC driver or the Microsoft Driver
Manager, the iSeries Access
ODBC driver returns an error message based on the text associated with the
SQLSTATE.</p>
<div class="section"><h4 class="sectiontitle">Error message format</h4><p>Error messages have the following
format:</p>
<pre>[vendor][ODBC-component][data-source]
error-message</pre>
<p>The prefixes in brackets ([]) identify the source
of the error. The following table shows the values of these prefixes returned
by the iSeries Access
ODBC driver.</p>
<p>When the error occurs in the data source, the [vendor]
and [ODBC-component] prefixes identify the vendor and name of the ODBC component
that received the error from the data source.</p>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" frame="border" border="1" rules="all"><thead align="left"><tr><th valign="top" width="25%" id="d0e65">Error source</th>
<th valign="top" width="75%" id="d0e67">Value</th>
</tr>
</thead>
<tbody><tr><td valign="top" width="25%" headers="d0e65 ">Driver Manager</td>
<td valign="top" width="75%" headers="d0e67 "> <pre>[Microsoft]
[ODBC driver Manager]
[N/A]</pre>
</td>
</tr>
<tr><td valign="top" width="25%" headers="d0e65 ">iSeries Access
ODBC driver</td>
<td valign="top" width="75%" headers="d0e67 "> <pre>[IBM<sup>(R)</sup>]
[iSeries Access ODBC driver]
N/A</pre>
</td>
</tr>
<tr><td valign="top" width="25%" headers="d0e65 ">NLS messages</td>
<td valign="top" width="75%" headers="d0e67 "> <pre>[IBM]
[iSeries Access ODBC driver]
Column #:
NLS error message number
NLS error message text</pre>
</td>
</tr>
<tr><td valign="top" width="25%" headers="d0e65 ">Communication layer</td>
<td valign="top" width="75%" headers="d0e67 "> <pre>[IBM]
[iSeries Access ODBC driver]</pre>
<p><samp class="codeph">Communications link failure.Comm
RC=xxxx - (message text) Where xxxx is the error number in decimal, not hexadecimal,
format. Message text describing the nature of your error appears with the
error number.</samp></p>
<div class="note"><span class="notetitle">Note:</span> For more information about error message ids,
see iSeries Access
return codes or the iSeries Access for Windows<sup>®</sup> online User's Guide.</div>
</td>
</tr>
<tr><td valign="top" width="25%" headers="d0e65 ">DB2<sup>®</sup> UDB
for iSeries</td>
<td valign="top" width="75%" headers="d0e67 "> <pre>[IBM]
[iSeries Access ODBC driver]
[DB2 UDB]
Server error message</pre>
</td>
</tr>
</tbody>
</table>
</div>
</div>
<div class="section"><h4 class="sectiontitle">Viewing DB2 UDB for iSeries error message text:</h4>
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" frame="border" border="1" rules="all"><tbody><tr><td valign="top" width="28.57142857142857%">For errors that begin with:</td>
<td valign="top" width="71.42857142857143%">Use this CL command</td>
</tr>
<tr><td valign="top" width="28.57142857142857%">SQL</td>
<td valign="top" width="71.42857142857143%">DSPMSGD RANGE(SQLxxxx) MSGF(QSQLMSG)</td>
</tr>
<tr><td valign="top" width="28.57142857142857%">IWS or PWS</td>
<td valign="top" width="71.42857142857143%">DSPMSGD RANGE(ZZZxxxx) MSGF(QIWS/QIWSMSG) where ZZZ is IWS or PWS</td>
</tr>
</tbody>
</table>
</div>
<p>Refer to Common ODBC errors for help with other ODBC error messages.</p>
<p>You
can search and view NLS or communication error messages in the Service, Error
and Trace message help topic in the iSeries Access for Windows online
User's Guide.</p>
</div>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzaiiodbc22.htm" title="Helps you solve a few of the more commonly encountered difficulties with iSeries Access for Windows and ODBC. It also identifies several tools that can help you remove performance bottlenecks. You should review this information before contacting technical support.">Troubleshoot ODBC</a></div>
</div>
<div class="relconcepts"><strong>Related concepts</strong><br />
<div><a href="../rzaik/rzaikrccaexpress.htm">iSeries Access return codes</a></div>
<div><a href="rzaiiodbc34.htm" title="Find and resolve ODBC errors.">Common ODBC errors</a></div>
</div>
</div>
</body>
</html>
Reference in New Issue Copy Permalink