Thanks Shannon.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Shannon ODonnell
Sent: Thursday, January 24, 2008 2:43 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: [WDSCI-L] Return record set from a web service
Moved this reply from WDSC to RPG400 - Per David's request:
You create a MDS in your SQLRPGLE program and you load your record set
into that.
Your parameter list that you return to your web service has in it the
MDS as
well as a 10i 0 field that you use in two ways.
First, when calling the rpg program from the Web service, you pass into
that field the number of elements you want to return in the MDS. If
that value is unknown (as it would be for the very first time you called
it from the web service (assuming you will ultimately have more records
to pull than is possible to store in the MDS at a single time) then on
the first call to the program, you pass in the maximum # of elements in
the MDS.
Second, when the rpg program returns the data back to the web service,
you pass the number of actual elements in the MDS, in that 10i 0 field.
In your web service, you have to specify that the counter field for the
data structure in the web service is the 10i 0 field.
Obviously it's a bit more complex than that, but that's the general
flow.
We use this method all the time to return any number of records to our
web services from SQLRPGLE programs.
Your SQLRPG code would look something like this in the D-specs:
D OUTCASRECORD DS Qualified
D 1000
D XCNAME 40a
D XCDIVISION 40a
D etc...
D IoDSCount S 10i 0
C *ENTRY PLIST
C PARM Input1
C PARM Input2
C PARM COUNTER
C PARM OUTCASRECORD
Your Web Service PCML would look something like this:
(the name of the sqlrpgle program in this example is WSGETCC)
<pcml version="4.0">
<struct count="WSGETCC.IODSCOUNT" name="OUTCASRECORD"
usage="inherit">
<data length="40" name="XCNAME" type="char" usage="inherit"/>
<data length="40" name="XCDIVISION" type="char"
usage="inherit"/> Etc...
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Rick.Chevalier@xxxxxxxxxxxxxxx
Sent: Thursday, January 24, 2008 2:06 PM
To: wdsci-l@xxxxxxxxxxxx
Subject: Re: [WDSCI-L] Return record set from a web service
How would you handle telling the caller the number of records returned?
How does the caller know how large to make the receiving variable?
Would you create a structure and give it a maximum size?
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Shannon ODonnell
Sent: Thursday, January 24, 2008 1:51 PM
To: 'Websphere Development Studio Client for iSeries'
Subject: Re: [WDSCI-L] Return record set from a web service
You can return a record set in a data structure in your SQLRPGLE program
to the web service.
-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx]
On Behalf Of Chanh_Le@xxxxxxxxxxxxxxx
Sent: Thursday, January 24, 2008 1:47 PM
To: Websphere Development Studio Client for iSeries
Subject: [WDSCI-L] Return record set from a web service
Can we return a record set from a web service from "EXEC SQL Set Result
Sets" in a SQLRPGLE?
Or we have place record set into a long OUTPUT parameter?
Thanks,
CL
======================================================================
Confidentiality Notice: The information contained in and transmitted
with this communication is strictly confidential, is intended only for
the use of the intended recipient, and is the property of Countrywide
Financial Corporation or its affiliates and subsidiaries. If you are
not the intended recipient, you are hereby notified that any use of the
information contained in or transmitted with the communication or
dissemination, distribution, or copying of this communication is
strictly prohibited by law. If you have received this communication in
error, please immediately return this communication to the sender and
delete the original message and any copy of it in your possession.
======================================================================
--
This is the Websphere Development Studio Client for iSeries (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the Websphere Development Studio Client for iSeries (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
Privileged and Confidential. This e-mail, and any attachments there to,
is intended only for use by the addressee(s) named herein and may
contain privileged or confidential information. If you have received
this e-mail in error, please notify me immediately by a return e-mail
and delete this e-mail. You are hereby notified that any dissemination,
distribution or copying of this e-mail and/or any attachments thereto,
is strictly prohibited.
--
This is the Websphere Development Studio Client for iSeries (WDSCI-L)
mailing list To post a message email: WDSCI-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/wdsci-l.
--
This is the RPG programming on the AS400 / 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.
midrange.com
