IBM i Series

IBM Licensed Programs: Database Accessories 539
IBM Licensed Programs: Database Accessories
• Command line parameters, which allow you to more easily automate start-up
procedures and integration with other applications, such as Visual Warehouse.
• Enhanced object tracking, which allows you to view a detailed run history for all QMF
objects to locate unused objects, determine frequently accessed data sources
(tables/columns), and spot potential problem areas.
• Web publishing, which allows you to convert a standard QMF form to an HTML format.
• Specialized form variables for HTML publishing, which lets you build advanced Web
features into your QMF report, such as hyperlink, e-mail link, and embedding images
in reports. Includes report preview feature.
• Global Variables for use in QMF for Windows procedures, forms, queries, and session
variables.
• QMF Form calculations (requires 32-bit QMF for Windows and IBM Object REXX).
• The most commonly used attributes of form components, now grouped together on a
new form dialog for ease of use.
• Custom edit codes can be added to QMF (requires 32-bit QMF for Windows and IBM
Object REXX). A sample user edit code routine is supplied that formats U.S. social
security numbers, telephone numbers, and ZIP codes.
• Euro currency symbol.
• Control formatting of date and time values in your QMF reports.
• Multiple formatted reports displayed on your desktop at the same time, while
performing other application functions.
• Control over the tables and QMF objects that are displayed when users view lists.
• Import/Export data, using the IXF format, that allows you to use your QMF query
results to create new (or append to existing) DB2 tables.
Benefits
A summary of benefits to users, application developers, database administrators, and the
enterprise follows.
User benefits
• Run queries directly to DB2 from Windows applications
• Integrate QMF objects (queries, forms, and procedures) and commands into Windows
applications
• Run ad hoc queries or stored queries
• Save new queries to a local drive, network drive, or as shared QMF queries
• Select existing QMF for Windows objects from drop-down lists