11
Fri, Oct
6 New Articles

QMF for Windows for AS/400, Version 7.1

SQL
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

In June, IBM announced Query Management Facility (QMF) for Windows for AS/400, Version 7.1, an advanced Business Intelligence (BI) tool for enterprise data sharing by DB2 Universal Database for AS/400 (DB2 UDB for AS/400) users, both expert and novice. QMF for Windows has a wealth of powerful new features, including Java-based SQL queries from a Web browser, and was made generally available on September 29, 2000—just in time for use on IBM’s new high-performance IBM server iSeries and AS/400e servers.

The new servers have been designed to handle core business applications, as well as applications associated with front-end Internet-based solutions, like customer relationship management (CRM), supply chain management (SCM), server-side Java, Domino, BI, and B2B.

QMF for Windows—with its Java-based SQL query from a Web browser, its robust data distribution and integration capabilities, and its advanced administrative controls—now serves a wide range of operational and data-warehousing applications and can also be used in conjunction with many e-business applications, serving IBM’s embedded AS/400 base of small to midsize customers, as well as new ones.

 

New and Better Query

 

Long-time AS/400 users who have built libraries of query objects using Query Manager for AS/400 or Query/400 will find that migration to QMF for Windows is easy. (You can download migration tools that support those traditional IBM AS/400 query products from the IBM Query Management Facility Web site at www.ibm.com/qmf.) And new users of iSeries 400 and AS/400 hardware and QMF for Windows software will be impressed with the combined power of hardware and software.

The IBM AS/400e and iSeries Model 840 server is powered by the world's first production microchips made of silicon-on-insulator (SOI) transistors and copper wiring. The addition of SOI alone can increase performance up to 20 to 30 percent beyond the use of copper by protecting the millions of transistors on a chip with a blanket of insulation, reducing harmful electrical leakage that wastes power. The AS/400e and iSeries Model 840 is 3.6 times faster than the previous generation of AS/400 servers.


This powerful combination of iSeries 400 and AS/400e hardware and QMF for Windows software opens up many new possibilities for business applications. Whether running on new iSeries 400 or older AS/400 hardware, QMF for Windows gives its users, application developers, and database administrators a quick start to enterprise reporting.

QMF for Windows has also been designed to deliver the most frequently required business-reporting capabilities at a competitive advantage, using the minimum number of tools. This multipurpose, scalable enterprise query environment allows business reporting, object sharing (queries, form templates and procedures) and reports, server resource protection, robust application development, and native connectivity to DB2 UDB for AS/400.

In today’s security-conscious world, QMF for Windows can be deployed widely, including via the Internet, to access multiple DB2 UDB for AS/400 databases with the connect-and-protect confidence so necessary for today’s BI.

 

Expanded Research Power

 

QMF for Windows allows browser-based SQL querying with Java servlets, which expands the breadth of customers’ research capabilities, giving them access to databases via the Internet, not just to databases on their own LANs.

Customers can create, locate, and run SQL queries, and publish the results to a server in HTML format. Browser-based querying allows customers to view query results in their browsers and download those results into spreadsheets or to other desktop tools. This new feature supports Java-enabled browsers, and no plug-ins are required.

QMF for Windows now also offers a dynamic display for creating meaningful reports. Users can summarize and aggregate data, and drag-and-drop or right-click to group by summary fields, creating reports that convey complex information at a glance. With QMF for Windows, users can highlight trends, make comparisons, and generate multiple views of answers to key business questions that are so important for enterprisewide BI.

Users can choose from a list of functions, such as sum, average, percentage of total, standard deviation, maximum, minimum, last, first, count, and more. Plus, enhanced sorting allows users to sort their query results on more than one noncontiguous column.

To enhance the look of reports, this latest version of QMF for Windows allows users to add repeating colors and various font formats.

QMF for Windows supports centralized report sharing and navigation by letting customers sort and group objects by type and by owner and providing faster location and retrieval of relevant objects. It also lets users change the object icon styles to suit their own desktop style.

 

Organize Data on the Desktop

 

QMF for Windows offers a new Report Center as an install option. With this new Report Center, users can create their own tree structure on their desktop, from which they can launch centrally shared queries and then send the resulting data to the desktop tools of their choice. Reports and formatted spreadsheets with mission-critical information can be created and instantly shared on an enterprisewide basis. Users can also publish these reports on the Web and quickly create automated Web warehouses of enterprise data.

With QMF for Windows, users can now organize, locate, launch, and even program the objects they care about most. Options are available for filtering objects by object owner and object name. Users can group and selectively display tables, QMF queries, procedures, forms, public favorites, and IBM DB2 Forms objects. (IBM DB2 Forms is an IBM drag-and-drop tool that quickly creates front-ends to DB2 UDB databases for functions such as order entry, table editing, and data lookup. DB2 Forms also accesses DB2 UDB for AS/400 databases. You can download an evaluation version from the IBM DB2 Forms Resource Center at www.software.ibm.com/db2forms.)


Users can gather data from the DB2 UDB for AS/400 databases of their choice and then automatically upload that data to a Web server, browser, or printer or into a program such as Lotus 1-2-3, Microsoft Access, Microsoft Excel, Text Viewer, Microsoft Word, or Lotus Word Pro.

Users can create Favorites folders using drag-and-drop, and these folders can be made public at the server for others throughout the enterprise to view and use.

 

Refreshing Standard Reports

 

Report Center seamlessly integrates with Windows scheduling features, which makes it easy to create and refresh reports at specified intervals. These regularly updated reports can then be used to create Web data warehouses so that decision-makers throughout an enterprise can always have access to the most current BI. Report Center lets users schedule individual jobs to run and rerun at set intervals—either by hour and minute, day of the week, or day of the month. Jobs can be run either once, a specified number of times, or on a regular basis.

In addition to distribution to Web data warehouses, jobs can be scheduled to perform a variety of tasks, such as distributing query results to any number of recipients via email. Virtually any task a user can perform manually using QMF for Windows can be automated with QMF for Windows through its job scheduling and QMF procedures.

 

Support for Large Objects

 

QMF for Windows now offers support for binary large objects (BLOBs), text LOBs, double-byte text LOBs, spreadsheets, documents, sound, video, and images. The LOB is displayed as a text-based placeholder, such as , which indicates that the cell contains a text LOB that is stored in a file in the local file system. The indicates that a cell contains only the locator that is returned by the server.

An individual LOB value can be retrieved upon request. Four LOB options are offered for retrieving LOB data from the server: disable LOB data completely, disable LOB data, retrieve LOB data on demand, and retrieve LOB data automatically.

Enjoy fast, accurate, and efficient manipulation of LOBs by always associating a particular LOB with its appropriate Windows application operation. Automatically combine a LOB value with the predefined set of operations that can most efficiently manipulate it. For instance, QMF for Windows would launch a playback or rendering application for a LOB that was a complex graphic or video, or it would launch an editing application with a LOB that was a lengthy word document, such as an e-book.

A new property page has been added to the QMF for Windows Resource Limits Group, to allow you to specify the current user for LOB options.

Host Variables and Stored Procedure Parameters dialogs have been enhanced to allow LOB data types both as input and output variables. The Grid View has been enhanced to accept LOB columns in a result set. A new menu item has been added for retrieving all LOB data, if the option to retrieve LOB data on demand has been enabled.

The Table Editor dialog box allows LOB columns; users can enter a LOB value by typing in a file name, or they can browse for a file in Windows Explorer, then drag and drop it into the LOB column.

With all this flexibility in creating, refreshing, and manipulating LOBs, new possibilities are opened, such as building and maintaining Web data warehouses that include data as well as documents and other unstructured information.

 

Increased Application Enabling with QMF Procedures

 

QMF procedures with REXX are now supported in QMF for Windows. A “dockable” command bar accepts QMF command line commands, so Version 7.1 is ready for immediate use by host QMF users.


For more information on these and other new features of QMF for Windows for AS/400, Version 7.1, such as new API commands, governing administrative enhancements, and DB2 Warehouse Manager for AS/400 integration, visit the IBM QMF site at www.ibm.com/qmf.

QMF for Windows is architecturally coupled with DB2 across platforms with Distributed Relational Database Architecture (DRDA), the enterprise data-sharing standard. It offers server-based pricing, unlimited users per server, and centralized installation.

 

REFERENCES AND RELATED MATERIALS

 

• IBM DB2 Forms Web site: www.software.ibm.com/db2forms
• IBM Query Management Facility Web site: www.ibm.com/qmf


BLOG COMMENTS POWERED BY DISQUS

LATEST COMMENTS

Support MC Press Online

$

Book Reviews

Resource Center

  • SB Profound WC 5536 Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application. You can find Part 1 here. In Part 2 of our free Node.js Webinar Series, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Brian will briefly discuss the different tools available, and demonstrate his preferred setup for Node development on IBM i or any platform. Attend this webinar to learn:

  • SB Profound WP 5539More than ever, there is a demand for IT to deliver innovation. Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects. The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

  • SB HelpSystems ROBOT Generic IBM announced the E1080 servers using the latest Power10 processor in September 2021. The most powerful processor from IBM to date, Power10 is designed to handle the demands of doing business in today’s high-tech atmosphere, including running cloud applications, supporting big data, and managing AI workloads. But what does Power10 mean for your data center? In this recorded webinar, IBMers Dan Sundt and Dylan Boday join IBM Power Champion Tom Huntington for a discussion on why Power10 technology is the right strategic investment if you run IBM i, AIX, or Linux. In this action-packed hour, Tom will share trends from the IBM i and AIX user communities while Dan and Dylan dive into the tech specs for key hardware, including:

  • Magic MarkTRY the one package that solves all your document design and printing challenges on all your platforms. Produce bar code labels, electronic forms, ad hoc reports, and RFID tags – without programming! MarkMagic is the only document design and print solution that combines report writing, WYSIWYG label and forms design, and conditional printing in one integrated product. Make sure your data survives when catastrophe hits. Request your trial now!  Request Now.

  • SB HelpSystems ROBOT GenericForms of ransomware has been around for over 30 years, and with more and more organizations suffering attacks each year, it continues to endure. What has made ransomware such a durable threat and what is the best way to combat it? In order to prevent ransomware, organizations must first understand how it works.

  • SB HelpSystems ROBOT GenericIT security is a top priority for businesses around the world, but most IBM i pros don’t know where to begin—and most cybersecurity experts don’t know IBM i. In this session, Robin Tatam explores the business impact of lax IBM i security, the top vulnerabilities putting IBM i at risk, and the steps you can take to protect your organization. If you’re looking to avoid unexpected downtime or corrupted data, you don’t want to miss this session.

  • SB HelpSystems ROBOT GenericCan you trust all of your users all of the time? A typical end user receives 16 malicious emails each month, but only 17 percent of these phishing campaigns are reported to IT. Once an attack is underway, most organizations won’t discover the breach until six months later. A staggering amount of damage can occur in that time. Despite these risks, 93 percent of organizations are leaving their IBM i systems vulnerable to cybercrime. In this on-demand webinar, IBM i security experts Robin Tatam and Sandi Moore will reveal:

  • FORTRA Disaster protection is vital to every business. Yet, it often consists of patched together procedures that are prone to error. From automatic backups to data encryption to media management, Robot automates the routine (yet often complex) tasks of iSeries backup and recovery, saving you time and money and making the process safer and more reliable. Automate your backups with the Robot Backup and Recovery Solution. Key features include:

  • FORTRAManaging messages on your IBM i can be more than a full-time job if you have to do it manually. Messages need a response and resources must be monitored—often over multiple systems and across platforms. How can you be sure you won’t miss important system events? Automate your message center with the Robot Message Management Solution. Key features include:

  • FORTRAThe thought of printing, distributing, and storing iSeries reports manually may reduce you to tears. Paper and labor costs associated with report generation can spiral out of control. Mountains of paper threaten to swamp your files. Robot automates report bursting, distribution, bundling, and archiving, and offers secure, selective online report viewing. Manage your reports with the Robot Report Management Solution. Key features include:

  • FORTRAFor over 30 years, Robot has been a leader in systems management for IBM i. With batch job creation and scheduling at its core, the Robot Job Scheduling Solution reduces the opportunity for human error and helps you maintain service levels, automating even the biggest, most complex runbooks. Manage your job schedule with the Robot Job Scheduling Solution. Key features include:

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • LANSAWhen it comes to creating your business applications, there are hundreds of coding platforms and programming languages to choose from. These options range from very complex traditional programming languages to Low-Code platforms where sometimes no traditional coding experience is needed. Download our whitepaper, The Power of Writing Code in a Low-Code Solution, and:

  • LANSASupply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals. In this webinar, we discuss how:

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • Profound Logic Have you been wondering about Node.js? Our free Node.js Webinar Series takes you from total beginner to creating a fully-functional IBM i Node.js business application.

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: