I'm developing a ILE-RPG utility (named SQLAXML) to build dinamic a XML file
from any "Select SQL stament" and at this point we need some advice to
improve it.

At this moment there is no manual (only a readme file spanish to install),
but its really easy to use:
download from http://ajut400.com/ajut400/sqlaxml.zip and unzip, put with ftp
sqlaxml.savf file (binary transfer) to as400 server and run RSTLIB SQLAXML
to restore.

To view result with MSExplorer using iSeries Apache server use this

AliasMatch /xml/(.*)\.xml /QSYS.LIB/SQLAXML.LIB/XMLDATA.FILE/$1.mbr

If anyone must be interested try it at
http://ajut400.com/ajut400/descargas.html (Spanish www)

Know limitations and future improvements.

1. At this moment SQLAXML only generates 5 first rows of SQLSELECT Parm.

2. Parm XMLOUTPUT file must be XMLDATA from SQLAXML library or CRTDUPOBJ of
this file. If you use other PF-SRC file, SQLAXML fails with CPF4131 error.

3. At this time: TimeStamp, LOB, datalink field are not supported.

4. SELECTSQL Parm max length its 2000 chars. A future improvement its to use
a file source that contains more complex SQL select staments to run.

5. Other improvements: Create a SQLAXML CGI version to provide GET/POST
methods from a html request like http://server/sqlaxml?selectsql='select
a.partno, a.partpri, b.inventory, b.partship from adtslab/product a left
outer join adtslab/proddtl b on a.partno = b.partno where b.inventory > 0'

Thanks in advanced,

Alex Martinez

As an Amazon Associate we earn from qualifying purchases.

This thread ...

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

This mailing list archive is Copyright 1997-2022 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.