I supposed this would work if I did a OPNQRYF on my file(s) first. --- In [email protected], "Antoon van Os" <[EMAIL PROTECTED]> wrote: > > 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] > 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 > > > > > > -------------------------------------------------------------------- -------- > -- > YAHOO! GROUPS LINKS > > a.. Visit your group "Easy400Group" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service. > > > -------------------------------------------------------------------- -------- > -- >
------------------------ Yahoo! Groups Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/9QUssC/lzNLAA/TtwFAA/wbFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Easy400Group/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
