SQL0444 work around? -- MIDRANGE-L

Subject: SQL0444 work around?
From: fbocch2595@xxxxxxx
Date: Thu, 18 Jul 2013 12:50:31 -0400 (EDT)
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

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

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

AW: SQL0444 work around? , Birgitta Hauser
Re: SQL0444 work around? , Mike Bardin
Re: SQL0444 work around? , rob

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.