QMF for Windows benefits

QMF for Windows provides benefits for the user, the developer, the database administrator, and the enterprise.

For users

• Point-and-click your way to robust business reports
• Publish reports to the Internet
• Automate tasks with QMF procedures
• Integrate data with Windows applications, such as spreadsheets and analysis tools
• Launch QMF for Windows from within Lotus 1-2-3 and Microsoft Excel
• Query multiple database servers simultaneously
• Export data easily to desktop databases
• Create DB2 tables using query results
• Create new or edit DB2 data directly in the Table Editor
• Share reports, queries, and forms among all the QMF enduser platforms: Windows, OS/390 or z/OS, MVS, VM, or VSE

For administrators

• Maintain comprehensive governing control over database resource consumption and user actions
• Limit runaway queries, database updates, access to specific database servers, rows fetched, and more
• Schedule governing limits by user group and time of day / day of week
• Maintain existing DB2 security and authorizations
• Connect users to multiple DB2 database platforms without database gateways, middleware, or ODBC drivers
• Access heterogeneous data through IBM's DataJoiner
• Extend advanced database techniques like static SQL and uncommitted read to Windows
• Reduce TSO, CMS, and CICS host logons
• Use the QMF for Windows API to leverage desktop development tools (such as application macros, Visual Basic, Powerbuilder, and more)
• Build robust custom applications quickly - place QMF capabilities, commands, and host QMF objects in the hands of Windows-based users
• Add additional users any time through server-based licensing

For the enterprise

• Extend QMF investment to new user environments quickly
• Establish an enterprise-wide standard for operational reporting with a multi-platform product family
• Provide controlled, enterprise-wide access to DB2 S/390 and DB2 UDB workstation platforms (and many other enterprise databases when using IBM's DataJoiner)
• Distribute mission-critical DB2 capabilities to desktops throughout the enterprise - Leverage high-performance DRDA architecture that supports:
• Maintain centralized administration and control
  • Local or remote 16- and 32-bit Windows clients
  • Large-scale report publishing to web servers
  • TCP/IP or SNA environments for DB2 S/390 and DB2 UDB workstation database platforms