Yes...you can. We are at 7.1-TR7.
We routinely pass XML from .net to IBMi database operations as a CLOB. Because we log all of the XML passed, the CLOB is most efficient, but we had been using a 32,000 byte character field.
Our app's transactions had typically originated on the .net server, but more and more frequently we've found the need to construct the XML on our i to pass as a parm (CLOB). There is even a new data-type to serve XML variables.
We used to use the XML-Toolkit, but found the method clumsy to execute and encountered poor performance. At first, we'd opted to use RPG's string manipulation abilities to construct the XML. More recently, we've begun using the XML tools within SQL. Much more efficient and less error prone to maintain as the picky need for proper apostrophe use is gone.
Steve Needles
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Mildenberger
Sent: Monday, May 12, 2014 3:59 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RE: XML Toolkit - create an XML file to be passed as a parameter
Can't you just pass it as a large character parm between the two programs?
Scott
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rpuglia@xxxxxxxxxxxxxxxxx
Sent: Monday, May 12, 2014 2:19 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Cc: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RE: XML Toolkit - create an XML file to be passed as a parameter
The XML itself.
Regards,
Rich Puglia
Sr. Project Manager
Holt Logistics Corp.
Phone#:(856) 742-3045
Fax#..:(856) 742-3291
email:RPuglia@xxxxxxxxxxxxxxxxx
From: "Needles,Stephen J" <SNEEDLES@xxxxxxxxxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>,
Date: 05/12/2014 04:12 PM
Subject: RE: XML Toolkit - create an XML file to be passed as a
parameter
When you say " pass the data as a parameter to another program ", what exactly does that mean?
What data does the parm have in it? The name of the file? The XML itself?
Steve Needles
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rpuglia@xxxxxxxxxxxxxxxxx
Sent: Monday, May 12, 2014 1:51 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: XML Toolkit - create an XML file to be passed as a parameter
I have used the XML Toolkit many times to generate XML files stored in the IFS. I now have to generate an XML file and pass the data as a parameter to another program. Does anyone know how this can be done? I thought it would be an easy task (maybe it is) but I have been struggling now for several days
--
This is the RPG programming on the IBM i (AS/400 and 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.
________________________________
This communication, including attachments, is confidential, may be subject to legal privileges, and is intended for the sole use of the addressee. Any use, duplication, disclosure or dissemination of this communication, other than by the addressee, is prohibited. If you have received this communication in error, please notify the sender immediately and delete or destroy this communication and all copies.
TRVDiscDefault::1201
midrange.com
