Re: SQL Stored Procedure

[Charles Wilt <charles.wilt@xxxxxxxxx>]

The OP wants to call an SP on a (Microsoft) SQL Server...

You can do it via a JDBC connection...

Look in the archives for more info.

Charles

On Tue, May 10, 2011 at 12:16 PM, Mike Wills <mike@xxxxxxxxxxxx> wrote:
> You can call it just like you do with any SQL statement, IIRC
>
> call lib/storedproc (parm1, parm2)
>
> --
> Mike Wills
> http://mikewills.me
>
>
>
> On Tue, May 10, 2011 at 10:59 AM, Billy Waters
> <bwaters@xxxxxxxxxxxxxxxxxx> wrote:
> > RPG will work..
> >
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Wills
> > Sent: Tuesday, May 10, 2011 11:37 AM
> > To: Midrange Systems Technical Discussion
> > Subject: Re: SQL Stored Procedure
> >
> > > From RPG or from STRSQL? You can from RPG, you need to use iSeries
> > Access or RDP otherwise. (From the guy that asked this a few months
> > ago).
> >
> > --
> > Mike Wills
> > http://mikewills.me
> >
> >
> >
> > On Tue, May 10, 2011 at 10:25 AM, Billy Waters
> > <bwaters@xxxxxxxxxxxxxxxxxx> wrote:
> > > Is it possible to call a SQL Server stored Procedure from AS400?
> > >
> > > Thanks..
> > > --
> > > 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.
> > --
> > 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.
> >
> > --
> > 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.
> --
> 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.