Hello, I haven't done it yet but to me i think it is possible with embedded sql.
1. Do the sql statement you want and give it a cursor. 2. The SQLDA data area will contain the field the are produced with your statement. 3. Loop through the cursor 3B. Loop through the sqlda fields to format your fields. Some manuals that could be of assistance: rzajpmst.pdf , rbafymst.pdf , rbafzmst.pdf (just type these name in google) --- In [email protected], Scott Klement <[EMAIL PROTECTED]> wrote: > > > Isn't that what STRSQL does? Or ODBC with MS-Office? Or SEQUEL from ASC? > I'm not sure how CGIDEV2 would help you with this, though. > > --- > Scott Klement http://www.scottklement.com > > > On Fri, 23 Dec 2005, itpweb1 wrote: > > > > > 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 Sponsor --------------------~--> Most low income homes are not online. Make a difference this holiday season! http://us.click.yahoo.com/5UeCyC/BWHMAA/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/
