Re: SQL0444 work around?

["Mike Bardin" <mike@xxxxxxxxx>]

On Thu, 18 Jul 2013 12:50:31 -0400 (EDT)
 fbocch2595@xxxxxxx wrote:
> Hi Folks, when running stored procedures I'm getting the SQL0444 msg 
> and I was wondering if anyone had a way to avoid having to qualify 
> the library?  
>
> SQL0444 - External program &A in &B not found (DB2 UDB for AS/400 
> SQL):   The SQL0444 is generated on an execute or execute direct when 
> the database server is unable to locate the program. Remember that 
> SQL does not perform a library list search. The stored procedure name 
> (the procedure name parameter that is used on the CREATE PROCEDURE 
> statement) must be in the default collection.
>
> Thanks, Frank 
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) 
> mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
Hi I had the same problem.
The stored procedure was registered correctly, and the correct 
external program was in the correct library. But the program was 
restored from V5R3M0 to 6.1, and was not converted. The problem was 
solved by running conversion.