Try this link:
http://www.redbooks.ibm.com/abstracts/sg246440.html
BTW. The "?" are just place holders to let you know how many parameters
are expected.
Regards,
Pat Landrum
Senior Programmer/Analyst
Hanover County School Board
200 Berkley Street - Ashland, VA. 23005
Phone: 804-365-4658 Email: plandrum@xxxxxxx
Notice: This message or any accompanying documents may contain
confidential or privileged information of Hanover County Public Schools.
If you are not the intended recipient, disclosure, copying or
distribution is strictly prohibited by state and federal law. If you
received this message in error, please notify the sender as soon as
possible.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Carl Galgano
Sent: Wednesday, July 15, 2009 7:21 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Calling a Stored iSeries stored procedure from MS SQL
I guess I don't understand. How do you retrieve the value of the ?.
Wouldn't you pass it something like:
CALL LIBNAME.PROGNAME (var1,var2,var3,var4,var5,var6)
Does anyone have a sample of code? I am calling the SP just fine from
an
RGPSQL program. I just don't know enough about the programming
environment
in MS SQL to even ask my question correctly.
Thanks to all who have responded thus far.
cjg
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Salter, James
Sent: Tuesday, July 14, 2009 1:43 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Calling a Stored iSeries stored procedure from MS SQL
I must have missed the original question, but using Reporting Services
(a
part of Visual Studio) the following would be an example:
CALL LIBNAME.PROGNAME (?,?,?,?,?,?)
In this example, 6 parameters that are defined within RS & passed to the
SP.
Within the stored procedures, the parameters can be INPUT, OUTPUT, or
INPUT
& OUTPUT.
Thanks.
James Salter
Systems Programmer
American Cast Iron Pipe Company
phone (205) 325-3033
fax (205) 307-3833
from: "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx>
subject: RE: Calling a Stored iSeries stored procedure from MS SQL
Studio
Can you elaborate on how she's calling this proc. I assume (I know. :-)
that
"SQL Studio" is actually either SSMS (SQL Server Management Studio
-- the admin tool for SQL Server) or Visual Studio (the programming IDE)
but
in either case, you don't just "call" an iSeries sproc. Are you using a
linked server in SQL Server?
-Walden
--
Walden H Leverich III
Tech Software
(516) 627-3800 x3051
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com
Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
_________Confidentiality Notice_______________________ This e-mail and
any
files transmitted with it is confidential and is intended solely for the
use
of the individual(s) or entity(ies) to whom this e-mail is addressed.
If
you are not the intended recipient or the person responsible for
delivering
the e-mail to the intended recipient, be advised that you have received
this
e-mail in error, and that any use, disclosure, dissemination,
forwarding,
printing, retention or copying of this e-mail is strictly prohibited.
If
you have received this e-mail in error, please immediately return this
e-mail to the sender and delete the e-mail from your system.
Thank you.
--
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.
Checked by AVG - www.avg.com
Version: 8.5.387 / Virus Database: 270.13.14/2238 - Release Date:
07/14/09
18:03:00
midrange.com
