Re: Calling an SQL stored procedure from RPGLE free-format

[Michael Schutte <mschutte369@xxxxxxxxx>]

Yes.


EXEC SQL  CALL PROCNAME(:PARM1, :PARM2, :PARM3);




On Mon, Mar 25, 2013 at 2:49 PM, William Howie <
William.Howie@xxxxxxxxxxxxxxxx> wrote:

> Hello all,
>
> I think I have what should be an easy question............I would like to
> call an SQL stored procedure from within a free-format RPGLE program.  Is
> that possible?  Hopefully I'm not oversimplifying the question.    Please
> advise, with examples if possible.   Thanks!
>
> Bill Howie
> Software Developer
> AmTrust North America
> 5800 Lombardo Center
> Cleveland, Ohio 44131
> 216.328.6292
>
> ________________________________
> Confidentiality Notice: This email message is intended only for the
> individual or entity to which it is addressed. This email may contain
> information that is proprietary or privileged, confidential and exempt from
> disclosure under applicable law. If you are not the intended recipient, you
> are hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you received this email by
> accident, please notify the sender immediately and destroy this email and
> all copies of it.
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.