IBM DB2 Web Query integrates with Microsoft SQL Server.
Written by Robert Andrews
DB2 Web Query is a great tool for reporting and graphing data on IBM i. It has built-in capabilities that allow DB2 Web Query to access data on any IBM i Power System. This starts to bring the power of a federated database into IBM i. A federated database system is one in which a single system accesses data that resides on multiple database systems. In the past, data was often replicated from one system to another to allow this type of access. However, this leads to issues with data being out of date, out of sync, and out of control. To help extend federated database capabilities, DB2 Web Query introduced the Microsoft SQL Server adapter.
TZN/400 V6.1.I (TimeZoNe/400 Simulation Utility) is a time zone tool that allows you to override the time based on the differential between the user's time zone and the system time zone through the year 3,000. It includes support for automatic rules-driven daylight-saving time (DST) around the world. It does this without costly LPAR support.The DDS/RPG/COBOL/ILE/Query/SQL called routines for TIME will now look to your users' time-zone offset. It takes the effort out of rewriting 9,000 modules and avoids expensive LPAR support.