<div>
Were the binds run for each of the different client versions against the UDB?<br />
<br />

</div>


Were the binds run for each of the different client versions against the UDB?



<div>
<div class="content wysiwyg-content">
Our DBAs recently upgraded our AIX based DB2 database to version 8.2. &nbsp;Due to business limitations, we are accessing the system using V6 clients. &nbsp;All stored procedures built prior to the ugrade function perfectly under this arrangement, but new procedures built using either the V7 client or the V8.2 client fail to run producing the following error message:<br />
<br />
Error: SQL0444N &nbsp;Routine &quot;*nQualSum&quot; (specific name &quot;SQL050217160054980&quot;) is implemented with code in library or path &quot;...nQualSum&quot;, function &quot;DBAWD001.SP0600AdminQualS<wbr />um&quot; which cannot be accessed. &nbsp;Reason code: &quot;4&quot;. &nbsp;SQLSTATE=42724<br />
&nbsp;(State:42724, Native Code: FFFFFE44)<br />
<br />
If we build and run the SP using only V8.2 clients the work, but if we build on V8.2 the will not run for V7 and V6, and if we build using V7 client they will not run on any of the clients. &nbsp;If cannot upgrade the clients to V8.2, does anybody have a solution for this?
</div>
</div>


Our DBAs recently upgraded our AIX based DB2 database to version 8.2.  Due to business limitations, we are accessing the system using V6 clients.  All stored procedures built prior to the ugrade function perfectly under this arrangement, but new procedures built using either the V7 client or the V8.2 client fail to run producing the following error message:

Error: SQL0444N  Routine "*nQualSum" (specific name "SQL050217160054980") is implemented with code in library or path "...nQualSum", function "DBAWD001.SP0600AdminQualSum" which cannot be accessed.  Reason code: "4".  SQLSTATE=42724
 (State:42724, Native Code: FFFFFE44)

If we build and run the SP using only V8.2 clients the work, but if we build on V8.2 the will not run for V7 and V6, and if we build using V7 client they will not run on any of the clients.  If cannot upgrade the clients to V8.2, does anybody have a solution for this?

DB2 Stored Procedures

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.