Re: JTOpen jdbc driver question about calling stored procedures.

[Michael Schutte <mschutte369@xxxxxxxxx>]

Yes it works from I series nav

Sent from my iPhone

On Dec 12, 2012, at 9:33 PM, Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:

> Can you call the procedure from iSeries Nav?  That might help figure out 
> where the problem lies.
>
> Also look at SET CURRENT PATH and SET CURRENT SCHEMA in the SQL 
> reference manual and see what they say about unqualified references.
>
> You might want to take a look at this article which tries to explain 
> some of the nuances of *SYS vs *SQL naming:
>
> http://www.mcpressonline.com/tips-&-techniques/database/techtip-do-you-understand-the-db2-for-i-environment-settings.html
>
> Sam
>
> On 12/12/2012 9:09 PM, Michael Schutte wrote:
> > Yes he is calling the stored proc. which is calling the cl program. It's an external SQL procedure.
> >
> > He is getting the message describe in the previous email when the external name on the create procedure is not hard coded to the library it's in. When it's hard coded it works.
> >
> > I don't want it hard coded is there a solution?  Or is what I found on IBM site true.
> >
> > The procedure is getnextworkingorder. This is suppose to call cl ebi001c
> -- 
> 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.