Using QMF

QMF for Windows benefits

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

For the user

• Build new queries easily with the standard prompted query builder
• Automate DB2 query from Windows applications
• Integrate with Lotus 1-2-3, Microsoft^(R) Excel^(R), Lotus^(R) Approach^(R), Microsoft^(R) Access^(R), Delphi, or many other OLE 2.0 applications
• Create and share QMF forms
• Edit DB2 data directly in the Table Editor
• Use the QMF for Windows GUI or a favorite application interface
• Edit table rows from a query result, or a row at a time
• Query multiple servers simultaneously
• Get outstanding DB2 performance and reliability

For the developer

• Bring industrial strength to ordinary desktop applications
• Integrate DB2, QMF objects, and commands with Windows 3.x, Windows 9x, or Windows NT OLE 2.0 automation controller application
• Easily build Windows applications that:
  • Retrieve QMF queries from servers
  • Launch QMF commands
  • Integrate existing QMF forms
• Create new or select existing QMF forms from your Windows desktop
• Use the table editor to create test data
• Convert heavily used queries to static SQL for better performance
• Shield users from the complexity of connecting to databases
• Control QMF for Windows in the background with its own API

For the database administrator

• Static SQL from Windows
• Protect DB2 from runaway queries and novice users
• Build governing into Windows applications
• Use existing DB2 security
• Centralize control over server resources
• Adjust governing limits by the following:
  • Time of day
  • Day of week
  • User groups
  • Server
• Set governing thresholds to do the following:
  • Warn users
  • Cancel queries and threads
• Limit by:
  • Rows fetched
  • Idle query timeouts
  • Server response timeouts
  • Idle connection timeouts
• Allow or disallow 14 different SQL verbs
• Turn on/off table editor and other features by group

For the enterprise

• TCP/IP support for DB2 V5, including DB2 Universal Database
• Large scale retrieval with outstanding performance--from Windows
• Full 16-bit and 32-bit support
• Query local or remote databases
• Maintain full DB2 security and authorizations
• Fully exploit DB2 system integrity
• Maximize return on server investment, minimize waste
• Eliminate TSO, CMS, and CICS HOST logon
• Make enterprise database resources available, yet more protected
• Gain from the ease of use of desktop languages and availability of skills
• Develop business solutions rapidly and flexibly
• Minimize complexity