Re: SQL0444 work around?

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.