ibm-information-center/dist/eclipse/plugins/i5OS.ic.rzaii_5.4.0.1/rzaiiodbc49.htm

47 lines
3.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="SQL0444 - External program &amp;A in &amp;B not found (DB2 UDB for iSeries SQL)" />
<meta name="abstract" content="The SQL0444 is generated on an execute or execute direct when the database server is able to locate the procedure declaration but is unable to locate the program object." />
<meta name="description" content="The SQL0444 is generated on an execute or execute direct when the database server is able to locate the procedure declaration but is unable to locate the program object." />
<meta name="DC.Relation" scheme="URI" content="rzaiiodbc47.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="rzaiiodbc49" />
<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>SQL0444 - External program &amp;A in &amp;B not found (DB2 UDB for iSeries SQL)</title>
</head>
<body id="rzaiiodbc49"><a name="rzaiiodbc49"><!-- --></a>
<!-- Java sync-link --><script language="Javascript" src="../rzahg/synch.js" type="text/javascript"></script>
<h1 class="topictitle1">SQL0444 - External program &amp;A in &amp;B not found (DB2<sup>®</sup> UDB for iSeries™ SQL)</h1>
<div><p>The SQL0444 is generated on an execute or execute direct when the
database server is able to locate the procedure declaration but is unable
to locate the program object.</p>
<p> The external program must be in the location specified in the system catalog
tables. Note that this location is defined by the naming convention and default
collection in affect when the procedure is defined (using CREATE PROCEDURE)
and not when the procedure is called. To check the location defined for the
external program name of a stored procedure run a query over QSYS2.SYSPROCS
and note the value for the "EXTERNAL_NAME" name field.</p>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rzaiiodbc47.htm" title="Common stored procedure errors returned to applications">Stored procedure errors</a></div>
</div>
</div>
</body>
</html>