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

This is not new...

AFAIK, when SQL was added, so was the ability to call any *PGM object
without explicitly defining a Stored Procedure.

I know I played around with it back on v3r6 or v3r7.

The advantage to defining a Stored Procedure interface for the *PGM, is
that you have a much easier time handling parameters in addition to a much
greater functionality for those parms.

Charles



On Thu, Sep 26, 2024 at 4:45 PM James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

On 9/26/24 2:39 PM, Javier Sanchez wrote:

If that program is registered as a stored procedure, it may be called as
such from an ODBC/JDBC connection.

HMMMM....

I just conducted an experiment.

Based on something I'd just read at

https://www.ibm.com/docs/en/i/7.4?topic=csp-using-embedded-call-statement-where-no-procedure-definition-exists

I didn't bother registering a stored procedure. I simply created a
completely headless program (a CL one-liner, consisting of a single
SNDMSG), and called it from a STRSQL session, with "CALL TEST26SP2024.
It worked.

Then I brought up Squirrel SQL on my desktop system, and tried calling
it from there.

CALL MERCURY/TEST26SP2024 gave me an error message; it didn't like the
qualified name.

CALL TEST26SP2024 didn't work either, because it looked for it in a
nonexistent library named after my user profile.

But CALL MERCURY.TEST26SP2024 worked.

Yes sir, you have to redefine the stored procedure too, because the
original attributes of it will remain with the old program. In my
experience, if I don't do that, it will call the one that was put in the
QRPLOBJ library.

As soon as I saw this, I went and made a change to the message and
recompiled my CL program, to see what would happen calling an
unregistered program. Then I repeated the call in Squirrel.

I got the recompiled program. So it would seem I can avoid the pitfall
simply by avoiding the registration.

--
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.