[WEB400] SQL to XML with RPG utility

["alex martinez" <alex@xxxxxxxxxxx>]

Hello


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

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