There is a tool on : 
 
http://www-922.ibm.com/db2xtool
or
http://www.easy400.net/easy400p/downloads.html#d16
 
that converts any DB2 file to among other formats, HTML. It allows you to specify
the number of columns of the header ( 0 - 3 ), border, CSS, and where you want to
store it as a web page ( xxxxx.HTML ) in the IFS.
Maybe this can help you.
Antoon
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of itpweb1
Sent: vrijdag 23 december 2005 16:45
To: [email protected]
Subject: [Easy400Group] utility that accepts an valid SQL statement and produces a report


Has anyone built a utility that accepts an valid SQL statement and
produces a report (spool file, web page, or ifs file) with the SQL
results as a table?  This would be great for sales and financial "drill
downs' without having to write a unique program or subroutine for each
variation (eg: sales by region by month, sales by agent by quarter,
profit by customer by month)

As RPG is a compiled, heavily typed language with poor access to meta-
data, this would be harder to accomplish than on Java or perl, but I
think that CGIDEV2 and IBM APIs would give us all the tools required.

Has anyone tried?

marty





SPONSORED LINKS
How to format a computer hard drive Cobol programmer Iseries 400
How to format a computer


YAHOO! GROUPS LINKS




Reply via email to