使用 DB2 进行报告
我大约 3 年前开始学习 .net。在那段时间里，我参加了一个训练营，学习 OO 和各种数据访问技术，例如 NHibernate、Subsonic、LINQ TO SQL。 不想尝试 EF，因为它还没有达到版本 3 :)
就报告而言，我听说许多 ORM 在报告方面一败涂地。我们有 AS400 或 DB2 作为我们的后端。我听说 LLBLGEN 在该产品的报告方面做得很好。但它是一个商业产品，不是免费的。有人可以向我指出一些关于 DB2 报告的好资源吗？感谢任何链接/博客文章
I started learning .net about 3 years ago. I have gone thru a boot camp during that time learning OO and various data access technologies such as NHibernate, Subsonic, LINQ TO SQL.
didn't wanna try EF cause it hasn't reached version 3 :)
As far as reporting goes, I have heard that many ORM'S fall flat on their face when it comes to reporting. We have AS400 OR DB2 as our backend. I have heard that LLBLGEN does a good job on reporting for this product. But it is a commercial product and not FREE. Can someone point me to some good resources for Reporting from DB2? thanks for any links/blog articles
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
DB2 上的报告与几乎任何其他数据库上的报告的工作方式相同 - 您可以使用 ODBC、JDBC 或对数据库的本机 DB2 调用。因此，您不需要 DB2 报告引用 - 任何数据库报告引用都应该满足您的需求。
DB2 唯一的特别之处可能是一些语法扩展，以及如何通过并行数据库服务器（如 MapReduce、Teradata 等）扩展后端。但这两者都不应该引起太多关注 - 因为它非常符合 ansi 标准，并且报告开发人员在很大程度上应该看不到可扩展性。
Crystal Reports、Brio、Cognos、Business Objects、Microstrategy、Actuate、JasperReports、Birt 等都应该可以正常工作。
ORM 对于报告来说通常很糟糕 - 因为它们是面向对象的而不是面向集合的。对于非常大的数据量、复杂的报告或大量的报告，您会尤其感到痛苦。
Reporting on DB2 will work the same as reporting on almost any other database - you can use ODBC, JDBC or native DB2 calls to the database. So, you don't need DB2 reporting references - any database reporting references should meet your needs.
The only thing special about DB2 might be a little of the syntax extensions, and how you scale up the back end through parallel database servers (like MapReduce, Teradata, etc). But neither should be of much concern - since it's extremely ansi compliant and the scalability should be largely invisible to the reporting developer.
And Crystal Reports, Brio, Cognos, Business Objects, Microstrategy, Actuate, JasperReports, Birt, etc should all work fine.
ORMs are typically terrible for reporting - since they're object rather than set oriented. You'll especially feel the pain with very large data volumes, complex reports or a large number of reports.
请不要忽视最明显的答案：Query/400！
它是本机 iSeries 软件。您在 iSeries 上配置并运行报告，但效果很好。它很简单、直接，也许有一点限制，但你可以完成大部分工作。
不要害怕绿屏或简单的界面。它确实是一个功能强大的工具，可以很好地处理 iSeries 数据库。
Please, don't overlook the most obvious answer: Query/400!
It is native iSeries software. You configure and runs the report on the iSeries but it works great. It is simple, straight forward and maybe a little bit limited but you get most of the works done.
Don't be scared of the green screen or the simple interface. It's really a powerfull tool that does handle the iSeries database very well.
角色扮演游戏我！
点亮这些指示灯！
RPG I!
Light up those indicators!
查询管理器：
您可以使用 SQL（可以接受输入参数）来构建它，然后创建一个“表单”，该表单将提供总计、级别分隔符、计数、自定义标题、标题等。
据我所知，Query/400 不接受参数。
免费手册位于：
http://publib.boulder.ibm .com/infocenter/iseries/v6r1m0/topic/rzatc/sc415212.pdf
Query Manager:
You cam use SQL (that can take input parameters) to build it, then create a "form" that will provide totals, level breaks, counts, customized headers, titles, etc.
Query/400 does not accept parameters AFAIK.
Free manual at:
http://publib.boulder.ibm.com/infocenter/iseries/v6r1m0/topic/rzatc/sc415212.pdf