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
