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.rzala_5.4.0.1/rzalaclass.htm

223 lines
18 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="reference" />
<meta name="DC.Title" content="Listing of SQLSTATE class codes" />
<meta name="abstract" content="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." />
<meta name="description" content="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." />
<meta name="DC.Relation" scheme="URI" content="rzalakickoff.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="rzalaclass" />
<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>Listing of SQLSTATE class codes</title>
</head>
<body id="rzalaclass"><a name="rzalaclass"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">Listing of SQLSTATE class codes</h1>
<div><p>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.</p>
<div class="tablenoborder"><a name="rzalaclass__state_class_codes"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="rzalaclass__state_class_codes" width="100%" frame="border" border="1" rules="all"><thead align="left"><tr valign="middle"><th align="left" valign="middle" width="10.369544440904747%" id="d0e22">Class code</th>
<th align="left" valign="middle" width="46.38419878942338%" id="d0e24">Meaning</th>
<th align="left" valign="middle" width="43.246256769671874%" id="d0e26">Subcodes</th>
</tr>
</thead>
<tbody><tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">00</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Unqualified Successful Completion</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode00">Table 1</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">01</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Warning</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode01">Table 2</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">02</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">No Data</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode02">Table 3</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">07</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Dynamic SQL Error</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode07">Table 4</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">08</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Connection Exception</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode08">Table 5</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">09</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Triggered Action Exception</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode09">Table 6</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">0A</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Feature Not Supported</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode0A">Table 7</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">0E</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Schema Name List Specification</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode0E">Table 8</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">0F</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Token</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode0F">Table 9</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">0K</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Resignal When Handler Not Active</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode0K">Table 10</a></td>
</tr>
<tr><td valign="middle" width="10.369544440904747%" headers="d0e22 ">0W</td>
<td valign="middle" width="46.38419878942338%" headers="d0e24 ">Prohibited Statement Encountered During
Trigger</td>
<td valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode0W">Table 11</a></td>
</tr>
<tr><td valign="middle" width="10.369544440904747%" headers="d0e22 ">0Z</td>
<td valign="middle" width="46.38419878942338%" headers="d0e24 ">Diagnostics Exception</td>
<td valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode0Z">Table 12</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">20</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Case Not Found for Case Statement</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode20">Table 13</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">21</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Cardinality Violation</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode21">Table 14</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">22</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Data Exception</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode22">Table 15</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">23</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Constraint Violation</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode23">Table 16</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">24</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Cursor State</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode24">Table 17</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">25</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Transaction State</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode25">Table 18</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">26</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid SQL Statement Identifier</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode26">Table 19</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">27</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Triggered Data Change Violation</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode27">Table 20</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">28</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Authorization Specification</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode28">Table 21</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">2D</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Transaction Termination</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode2D">Table 22</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">2E</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Connection Name</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode2E">Table 23</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">2F</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">SQL Function Exception</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode2F">Table 24</a></td>
</tr>
<tr><td valign="middle" width="10.369544440904747%" headers="d0e22 "><img src="./delta.gif" alt="Start of change" />33<img src="./deltaend.gif" alt="End of change" /></td>
<td valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid SQL Descriptor Name</td>
<td valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode33">Table 25</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">34</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Cursor Name</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode34">Table 26</a></td>
</tr>
<tr><td valign="middle" width="10.369544440904747%" headers="d0e22 ">35 </td>
<td valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Condition Number</td>
<td valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode35">Table 27</a></td>
</tr>
<tr><td valign="middle" width="10.369544440904747%" headers="d0e22 ">36</td>
<td valign="middle" width="46.38419878942338%" headers="d0e24 ">Cursor Sensitivity Exception</td>
<td valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode36">Table 28</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">38</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">External Function Exception</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode38">Table 29</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">39</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">External Function Call Exception</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode39">Table 30</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">3B</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid SQL Descriptor Name</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode3B">Table 31</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">3C</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Ambiguous Cursor Name</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode3C">Table 32</a></td>
</tr>
<tr><td valign="middle" width="10.369544440904747%" headers="d0e22 ">3F</td>
<td valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Schema (Collection) Name</td>
<td valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode3F">Table 33</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">42</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Syntax Error or Access Rule Violation</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode42">Table 34</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">44</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">WITH CHECK OPTION Violation</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode44">Table 35</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">46</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Java™<span>TM</span> Errors</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode46">Table 36</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">51</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Application State</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode51">Table 37</a></td>
</tr>
<tr><td valign="middle" width="10.369544440904747%" headers="d0e22 ">53</td>
<td valign="middle" width="46.38419878942338%" headers="d0e24 ">Invalid Operand or Inconsistent Specification</td>
<td valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode53">Table 38</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">54</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">SQL or Product Limit Exceeded</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode54">Table 39</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">55</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Object Not in Prerequisite State</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode55">Table 40</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">56</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Miscellaneous SQL or Product Error</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode56">Table 41</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">57</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">Resource Not Available or Operator Intervention</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode57">Table 42</a></td>
</tr>
<tr valign="middle"><td align="left" valign="middle" width="10.369544440904747%" headers="d0e22 ">58</td>
<td align="left" valign="middle" width="46.38419878942338%" headers="d0e24 ">System Error</td>
<td align="left" valign="middle" width="43.246256769671874%" headers="d0e26 "><a href="rzalaccl.htm#cc__classcode58">Table 43</a></td>
</tr>
</tbody>
</table>
</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>
</body>
</html>
Reference in New Issue Copy Permalink