Hi I need to create a fex report from multiple DB2 stored procedures.some display columns from one SP and some from second SP. How do i do that. could you pl give example with CAR file.Developer studio/Report painter. Thanks for the help, ramThis message has been edited. Last edited by: Kerry,
WebFOCUS 762 Windows To be decided(All formats)
July 01, 2010, 04:33 PM
Darin Lee
Can't give you an example from CAR file because there are no stored procedures for CAR file. What you need to do is generate a Master File for each stored procedure (as described in the documentation) which basically describes the output of the stored procedure. Then you can JOIN or MATCH output from those two master files and create your report.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
July 01, 2010, 04:34 PM
Darin Lee
Might be just as easy to create a view in the native DBMS with all the fields you need and then createe an MFD for that view.
Regards,
Darin
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat