Re: Executing a program through an ODBC/JDBC connection?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

That has nothing to do with the fact that there's no store procedure
registered and everything to do with the (lack of) library list configured
for ODBC/JDBC.

You'd see the same issue if you called the program with a defined stored
procedure.

Charles

On Fri, Sep 27, 2024 at 9:25 AM James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> The customer developer in this project found a "gotcha" in using an SQL
> CALL with a qualified name and no stored procedure registration.
>
> It seems that if the program you're calling is accessing anything by
> library list, it will likely fail to find it, so anything being called
> by the program needs to be qualified.
>
> Still, that's not a very big "gotcha," and it showed up rather quickly.
>
> --
> JHHL
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.