Re: Sending SQL/Record Sets/Cursors To The iSeries -- MIDRANGE-L

Just trying to find out where the limitation lies.

You have a program that has a result set, that you want a remote iSeries 
to process.

I know that most people on the iseries tend to look at it serving up 
result sets to clients.  I 'think' that the RPG SQL precompiler only 
supports serving up result sets, not processing them.  I 'think' that you 
have to use the SQL-CLI interface to process result sets from a RPG 
program.
A bulk of the users of the SQL-CLI interface fall into two camps:
1)  Those who 'could not afford' the 57xx-ST1 toolkit to create imbedded 
SQL
2)  Those who tired of all the limitations that older versions of the 
precompiler put into their RPG designs.
The remaining are those who were interested in portability, got into the 
technical details, and what not.
But I digress...

I think, that only with a slightly Herculean effort, you should be able to 
call a RPG program written with CLI's to then process that result set. 
(Not that I know what I am talking about.) 
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/cli/rzadpmst02.htm

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Smith, Dave" <DSmith@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
07/15/2004 10:28 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
Sending SQL/Record Sets/Cursors To The iSeries






Good Morning:

Currently, we have programs written on our iSeries that are executed via
SQL procedures(
 
 CREATE PROCEDURE XXLIB.X220( 
   IN SSR DECIMAL(3, 0), 
   IN DISTRIBUTOR DECIMAL(7, 0), 
   IN STATE CHAR(1), 
   IN EXPDATE DATE, 
   OUT MSGID CHAR(7) , 
   OUT MSG CHAR(150) ) 
   LANGUAGE RPGLE 
   SPECIFIC XXLIB.X220 
   NOT DETERMINISTIC 
   READS SQL DATA 
   CALLED ON NULL INPUT 
   EXTERNAL NAME 'XXLIB/XX220' 
   PARAMETER STYLE GENERAL 
)  from web applications written in C#. 

The SQLRPGLE programs pass back parameters and sometimes record set(s)
(cursors):


C     *ENTRY        PLIST 
C                   PARM                    pSSR 
C                   PARM                    pDIST 
C                   PARM                    pSTATE 
C                   PARM                    pExpDate 
C                   PARM                    pMSGID 
C                   PARM                    pMSG 

C/EXEC SQL SET RESULT SETS CURSOR C2 
C/END-EXEC 

We now want a solution that we can pass a record set (cursor) to the
iSeries via C# and SQL so that I can update/write this data to my
DB2/UDB file.  We currently pass single records via parameters and
update our database but repeated calls for say a thousand records would
simply not be efficient.

I would prefer a SQL solution to keep it consistent with what we are
doing going the other way.   I am hoping it's as easy as receiving the
record set as a parameter and doing an insert into my PF.  Hey...a guy
can hope can't he?

I am open to other solutions but am leaning towards a SQL solution at
this time.
 
We are at version V5R2. 

All responses are welcome and appreciated.   Thanks.

David J. Smith
IT Contractor
dsmith@xxxxxxxxx
517.546.5400 Ext: 1513 


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