× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



That's great, but I can't hold this project up until management decides when
we make the jump from V5R4 to V7R1.

I wish we would do it soon.


I remember hearing rumors a while back that IBM was supposedly adding QR
support to the AFP? Did it materialize?


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Nicholas T Lawrence
Sent: Tuesday, July 09, 2013 4:26 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: http_url_post_xml and REST



In response to these comments:

I've looked around for an example to follow that will post the XML
from
the IFS and include some basic information on the actual POST.

and

the remaining XML file might be a bit much for most RPG fields at 32k.


DB2 for i 7.1 has a GET_BLOB_FROM_FILE function, and also a GET_XML_FILE
function that will return a locator that can refer to up to 2GB of data.
DB2 for i 7.1 also supports file reference host variables that you can use
embedded SQL & RPG.

In a recent fix pack, SQL functions were added to SYSTOOLS that can be used
to make HTTP requests as part of an SQL statement, such as the POST that you
describe.

These ideas can be combined fairly easily.

This white paper talks about the HTTP functions:
https://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/stg_ast_sys_
wp_access_web_service_db2_i_udf
The paper talks about REST, header fields and SSL, it may help fill in the
blanks even you do not use these functions.

And this paper has examples of GET_XML_FILE and XML file reference variables
in C and RPG:
https://www-304.ibm.com/partnerworld/wps/servlet/download/DownloadServlet?id
=K
$63TzTFkZwiPCA
$cnt&attachmentName=Replacing_xml_extender.pdf&token=MTM3MzQwMDQzNjA3Nw==&lo
cale=en_ALL_ZZ


(See also Dawn May's i Can blog:
http://ibmsystemsmag.blogs.com/i_can/xml/ )


These functions tend to be designed for use with the relational database,
rather than non-DB2 PHP, HTTP or RPG operations - but I know file reference
variables have been used in RPG before for non-DB2 reasons, if only to make
it easier to work with larger values.

Nick Lawrence
DB2 for IBM i


Success is not final, failure is not fatal: it is the courage to continue
that counts.
- Winston Churchill
--
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.