Technology Focus: Basic Database Query Tools Still Have a Place at the Table

Business Intelligence
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

With the scope and features of business intelligence applications hitting new stratospheric heights of splendiferousness, are simple query tool products being left behind? Apparently not just yet.


Sometimes you just don't want all the glitz. While one of the messages our whole culture seems to be delivering is one of "biggest is best," there are still situations when simple solutions are all that's needed. One of the best illustrations of that idea may be database query tools.


Even though many of these data-retrieval utilities are now embedded in applications that offer levels of complexity ranging from report generation and distribution tools to business predictive-analytics suites, sometimes all you really need right now is a factoid or two to get on with the task at hand. Not that all those other bells and whistles aren't frequently useful, of course, but sometimes it's also good to focus on the basics.

Some Query Tool Vendors Agree

When posed the question of whether or not query tools are fading in importance compared to more feature-rich business intelligence (BI) apps, literally two out of three query tool vendors consulted agree.


Bill Langston, director of product marketing at New Generation Software, is one who agrees query tools still have their place. "In the larger companies you see BI capabilities [in demand], but in the typical small-to-medium companies that are the heart of the i market, query tools are still the primary tool," he reports. "There's a lot of buzz about [IBM's] Watson and such, but it hasn't trickled down to the smaller companies. The vast majority of users just want to query data and pull it into a spreadsheet."


Tom Huntington, vice president of technical services at Help/Systems, echoes Langston. "We just had a record year with SEQUEL [Help/Systems' query tool]. We're finding that many companies that have bought into large-scale BI products are [having] issues with security, latency, and complexity that have kept their end users from really using these products. It's amazing how many companies still use IBM-based green-screen query because [their] large-scale BI product is too complicated."

At Least One Doesn't

Marcel Sarrasin, product manager at ExcelSystems Software Development, which handles product support for BCD International's Clover Query and other products, is more equivocal. "There's a place for both [product types]. The pure query tool is fading for non-technical end users. Programmers will use SQL to pull a quick fact or total, especially if it's a query they don't plan to run over and over. But the end user that used [to rely on] Query/400 [increasingly wants] to get results over the Web in a graphical interface or put them into a spreadsheet. Having all the function in a BI tool reduces the need for something ad hoc, even though it may require more technical knowledge on the part of the end user."

Do Query Tools Have a Future?

When asked if query tools still have a future as a product type in a market where they must complete with full-featured BI, all three vendor representatives agreed that they do, although they differed on what role query tools will take.


"I think the markets are going to be more and more spread out, from tools that do one thing up to business analytics apps and so forth. There will be more and more players with wider and wider capabilities," predicts Langston.


"We see a very good future for SEQUEL, since it is easy to use and helps customers with their immediate needs of getting data from IBM i securely and in formats that are easily adaptable to today's market," Huntington notes.


"Query tools will be more for programmers [looking] for quick answers," Sarrasin forecasts. "We'll see some use of them for mass updates or deletes of records or one-time uses on test files for a specific statistic or sum."


If query tools have a future, then what changes might we see in them over the next couple of years?


"We see customers wanting more and more consolidation of data from other platforms with IBM i," Huntington relates. "The other areas of concern are easy access for end users through dashboards, and security."


"We see interest in people moving apps and data to hosted systems," Langston points out. "Understanding how to leverage reporting and BI in that environment will be important."


"If [the product type] is going to remain a query tool, it will morph into low-level BI," Sarrasin foresees. "Otherwise, people will [at least] be creating Web interfaces over them."

Vendor Advice on Buying a Query Tool

What advice would these vendors offer to a prospective customer looking for a query tool product?


"Be clear on who the real end users are going to be," advises Sarrasin. "[Consider] how the users will access the tool. Does it have a Web interface, easy access, and is there a way to manage queries? People getting real-time info is what people need to drive business decisions."


"Test-drive the product and [have] not only a developer looking at it but also have your end users and the managers involved," Huntington recommends.


"Look for things that let you eventually take on more capability as you need it, and look for products that can help you use existing capabilities," Langston suggests. "Leverage in-house people skills."

Query Tools and the i Market

Below is a profile of all the basic query tool products that are available for the IBM i market. All of them share certain characteristics. They all run natively on the i (although descriptions note if they don't run under the i/OS). All are either query tools first and foremost or else they have a query tool embedded in them. All extract information at least from DB2 databases on i servers, and most can also extract information (or have add-on products that help them) from databases on other platforms as well. Nearly all have added features that let users export data in a variety of formats, display data in a variety of ways, and plug the data into report writers and, often, other applications. If you're looking for a query tool to help you keep track of important data, the most important differentiator will be the ways in which the data a tool can retrieve for you can be used in ways that best fit the way your enterprise does business.


Please note that the brief summaries used here in no way cover all the features each software product provides. You should consult the links provided for each product and contact the associated vendors for a more complete idea of what each query product has to offer.


And as always when looking for products or services, be sure to check the MC Press Online Buyer's Guide.


Database Query Tools for IBM i

BCD International


Monarch for EZ-Pickin's

Clover is a Web-based tool that lets users design and run queries and reports via a browser. The product also includes query templates and SQL wizards that let even nontechnical users edit database records and generate reports, executive dashboards, and MS Excel spreadsheets.


Monarch for EZ-Pickin's is a query tool for mining existing reports, thereby letting users view and distribute data from reports generated on virtually any platform. The utility lets users build such aids to understanding as charts, graphs, summary reports, and customized tables.




Cyberquery is an ad hoc production query and reporting system that runs under AIX, other forms of UNIX, and Windows. It can interact with virtually any database system, including non-relational ones, making it particularly useful in mixed-platform environments. An optional accelerator add-on helps increase query performance.


Dharma Systems


Dharma/SQL offers a fully functional SQL interface to a wide range of database protocols, including SQL-92, ODBC 3.5, .NET 3.5, JDK 1.6, and JDBC 4. The product interfaces with the Dharma Integrator, an application integration hub that lets users tie data queries to a wide range of application programs.


IBM Corporation

DB2 Web Query for IBM i

DB2 Web Query for IBM i lets end users generate queries, reports, and dashboard-style outputs from IBM i database information via a browser. Based on Information Builders' WebFOCUS product line, DB2 Web Query is a replacement for IBM's traditional Query/400 product and offers database adapters, report-authoring features, and a developer workbench for creating complex or reusable query programs.


Information Builders

WebFOCUS InfoAssist

WebFOCUS InfoAssist is a subordinate product of Information Builders' WebFOCUS business intelligence suite. InfoAssist provides database query and ad hoc reporting assistance for end users, enabling creation of anything from simple queries to complex reports, dashboards, and charts with a variety of possible output formats.




InTuator is a database query product that lets users extract information from IBM i databases and applications. Its features include multidimensional data drilling, chart analysis, the ability to link across application areas, the ability to export results to MS Office applications, and a portable mode that lets users perform data analysis even when not connected to the host server.


Linoma Software


Surveyor/400 is both a query tool for end users and a database maintenance tool for developers. Its query functions include the ability to query, display, and edit database records with a graphical file editor, as well as the ability to enter, run, and test SQL statements. Other features include the ability to download data to MS Excel, organize files into user groups, and access databases on multiple machines with a few mouse clicks.


New Generation Software


NGS-IQ is a business intelligence suite that includes query capabilities as well as a wide range of report and other output options for gathered data. The suite's query and reporting component, IQ Server, includes a runtime Web interface, hyperlinks in output reports, simplified file joins, wildcard file searches, and email and other report-distribution options. A separately licensed IQ Connexion module gives users access to databases on platforms other than IBM i servers.


ProData Computer Services


RDB Connect


DBU functions as a query tool for end users while also providing numerous database editing and maintenance features for developers and database administrators. Its query functions enable complex SQL searches, data exports to comma-delimited and XML files, and numerous on-screen formatting options for displaying data results.


RDB Connect provides access to off-platform databases for all IBM i high-level languages. It enables execution of any SQL query by IBM i applications on non-i databases, import and export of data to and from IBM i servers, and synchronization of data across platforms.


SQL/Pro breaks SQL statements down into English-like commands that even non-technical users can understand, enabling them to query, print, and alter data at will. SQL/Pro supports queries of up to 32,750 characters, generates error messages for poorly constructed queries, and offers F4 prompting to help novices build queries.


Sequel Software, a Help/Systems company


SEQUEL is a query tool and report generator that offers a Windows-based GUI for end users, a drag-and-drop interface for building queries, optionally predefined JOIN criteria and other features that let even novices build meaningful queries, data distribution via email and Web using a variety of MS Office and other file formats, and extensive built-in reporting options.


Symtrax Corporation


StarQuery Web

StarQuery is a suite of data-access and manipulation tools that includes the ability to query several databases simultaneously, lets end users add fields and conditions needed to report specifications, and enables use of ad-hoc or standard queries.


StarQuery Web provides the same query and reporting features in a version that is accessible via browser.

John Ghrist

John Ghrist has been a journalist, programmer, and systems manager in the computer industry since 1982. He has covered the market for IBM i servers and their predecessor platforms for more than a quarter century and has attended more than 25 COMMON conferences. A former editor-in-chief with Defense Computing and a senior editor with SystemiNEWS, John has written and edited hundreds of articles and blogs for more than a dozen print and electronic publications. You can reach him at



Support MC Press Online





  • White Paper: Node.js for Enterprise IBM i Modernization

    SB Profound WP 5539

    If your business is thinking about modernizing your legacy IBM i (also known as AS/400 or iSeries) applications, you will want to read this white paper first!

    Download this paper and learn how Node.js can ensure that you:
    - Modernize on-time and budget - no more lengthy, costly, disruptive app rewrites!
    - Retain your IBM i systems of record
    - Find and hire new development talent
    - Integrate new Node.js applications with your existing RPG, Java, .Net, and PHP apps
    - Extend your IBM i capabilties to include Watson API, Cloud, and Internet of Things

    Read Node.js for Enterprise IBM i Modernization Now!


  • Profound Logic Solution Guide

    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 companyare not aligned with the current IT environment.

    Get your copy of this important guide today!


  • 2022 IBM i Marketplace Survey Results

    Fortra2022 marks the eighth edition of the IBM i Marketplace Survey Results. Each year, Fortra captures data on how businesses use the IBM i platform and the IT and cybersecurity initiatives it supports.

    Over the years, this survey has become a true industry benchmark, revealing to readers the trends that are shaping and driving the market and providing insight into what the future may bring for this technology.

  • Brunswick bowls a perfect 300 with LANSA!

    FortraBrunswick is the leader in bowling products, services, and industry expertise for the development and renovation of new and existing bowling centers and mixed-use recreation facilities across the entertainment industry. However, the lifeblood of Brunswick’s capital equipment business was running on a 15-year-old software application written in Visual Basic 6 (VB6) with a SQL Server back-end. The application was at the end of its life and needed to be replaced.
    With the help of Visual LANSA, they found an easy-to-use, long-term platform that enabled their team to collaborate, innovate, and integrate with existing systems and databases within a single platform.
    Read the case study to learn how they achieved success and increased the speed of development by 30% with Visual LANSA.


  • Progressive Web Apps: Create a Universal Experience Across All Devices

    LANSAProgressive Web Apps allow you to reach anyone, anywhere, and on any device with a single unified codebase. This means that your applications—regardless of browser, device, or platform—instantly become more reliable and consistent. They are the present and future of application development, and more and more businesses are catching on.
    Download this whitepaper and learn:

    • How PWAs support fast application development and streamline DevOps
    • How to give your business a competitive edge using PWAs
    • What makes progressive web apps so versatile, both online and offline



  • The Power of Coding in a Low-Code Solution

    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:

    • Discover the benefits of Low-code's quick application creation
    • Understand the differences in model-based and language-based Low-Code platforms
    • Explore the strengths of LANSA's Low-Code Solution to Low-Code’s biggest drawbacks



  • Why Migrate When You Can Modernize?

    LANSABusiness 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.
    In this white paper, you’ll learn how to think of these issues as opportunities rather than problems. We’ll explore motivations to migrate or modernize, their risks and considerations you should be aware of before embarking on a (migration or modernization) project.
    Lastly, we’ll discuss how modernizing IBM i applications with optimized business workflows, integration with other technologies and new mobile and web user interfaces will enable IT – and the business – to experience time-added value and much more.


  • UPDATED: Developer Kit: Making a Business Case for Modernization and Beyond

    Profound Logic Software, Inc.Having trouble getting management approval for modernization projects? The problem may be you're not speaking enough "business" to them.

    This Developer Kit provides you study-backed data and a ready-to-use business case template to help get your very next development project approved!

  • What to Do When Your AS/400 Talent Retires

    FortraIT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators is small.

    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:

    • Why IBM i skills depletion is a top concern
    • How leading organizations are coping
    • Where automation will make the biggest impact


  • Node.js on IBM i Webinar Series Pt. 2: Setting Up Your Development Tools

    Profound Logic Software, Inc.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. In Part 2, Brian May teaches you the different tooling options available for writing code, debugging, and using Git for version control. Attend this webinar to learn:

    • Different tools to develop Node.js applications on IBM i
    • Debugging Node.js
    • The basics of Git and tools to help those new to it
    • Using as a pre-built development environment



  • Expert Tips for IBM i Security: Beyond the Basics

    SB PowerTech WC GenericIn this session, IBM i security expert Robin Tatam provides a quick recap of IBM i security basics and guides you through some advanced cybersecurity techniques that can help you take data protection to the next level. Robin will cover:

    • Reducing the risk posed by special authorities
    • Establishing object-level security
    • Overseeing user actions and data access

    Don't miss this chance to take your knowledge of IBM i security beyond the basics.



  • 5 IBM i Security Quick Wins

    SB PowerTech WC GenericIn today’s threat landscape, upper management is laser-focused on cybersecurity. You need to make progress in securing your systems—and make it fast.
    There’s no shortage of actions you could take, but what tactics will actually deliver the results you need? And how can you find a security strategy that fits your budget and time constraints?
    Join top IBM i security expert Robin Tatam as he outlines the five fastest and most impactful changes you can make to strengthen IBM i security this year.
    Your system didn’t become unsecure overnight and you won’t be able to turn it around overnight either. But quick wins are possible with IBM i security, and Robin Tatam will show you how to achieve them.

  • Security Bulletin: Malware Infection Discovered on IBM i Server!

    SB PowerTech WC GenericMalicious programs can bring entire businesses to their knees—and IBM i shops are not immune. It’s critical to grasp the true impact malware can have on IBM i and the network that connects to it. Attend this webinar to gain a thorough understanding of the relationships between:

    • Viruses, native objects, and the integrated file system (IFS)
    • Power Systems and Windows-based viruses and malware
    • PC-based anti-virus scanning versus native IBM i scanning

    There are a number of ways you can minimize your exposure to viruses. IBM i security expert Sandi Moore explains the facts, including how to ensure you're fully protected and compliant with regulations such as PCI.



  • Encryption on IBM i Simplified

    SB PowerTech WC GenericDB2 Field Procedures (FieldProcs) were introduced in IBM i 7.1 and have greatly simplified encryption, often without requiring any application changes. Now you can quickly encrypt sensitive data on the IBM i including PII, PCI, PHI data in your physical files and tables.
    Watch this webinar to learn how you can quickly implement encryption on the IBM i. During the webinar, security expert Robin Tatam will show you how to:

    • Use Field Procedures to automate encryption and decryption
    • Restrict and mask field level access by user or group
    • Meet compliance requirements with effective key management and audit trails


  • Lessons Learned from IBM i Cyber Attacks

    SB PowerTech WC GenericDespite the many options IBM has provided to protect your systems and data, many organizations still struggle to apply appropriate security controls.
    In this webinar, you'll get insight into how the criminals accessed these systems, the fallout from these attacks, and how the incidents could have been avoided by following security best practices.

    • Learn which security gaps cyber criminals love most
    • Find out how other IBM i organizations have fallen victim
    • Get the details on policies and processes you can implement to protect your organization, even when staff works from home

    You will learn the steps you can take to avoid the mistakes made in these examples, as well as other inadequate and misconfigured settings that put businesses at risk.



  • The Power of Coding in a Low-Code Solution

    SB PowerTech WC GenericWhen 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:

    • Discover the benefits of Low-code's quick application creation
    • Understand the differences in model-based and language-based Low-Code platforms
    • Explore the strengths of LANSA's Low-Code Solution to Low-Code’s biggest drawbacks



  • Node Webinar Series Pt. 1: The World of Node.js on IBM i

    SB Profound WC GenericHave 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.
    Part 1 will teach you what Node.js is, why it's a great option for IBM i shops, and how to take advantage of the ecosystem surrounding Node.
    In addition to background information, our Director of Product Development Scott Klement will demonstrate applications that take advantage of the Node Package Manager (npm).
    Watch Now.

  • The Biggest Mistakes in IBM i Security

    SB Profound WC Generic The Biggest Mistakes in IBM i Security
    Here’s the harsh reality: cybersecurity pros have to get their jobs right every single day, while an attacker only has to succeed once to do incredible damage.
    Whether that’s thousands of exposed records, millions of dollars in fines and legal fees, or diminished share value, it’s easy to judge organizations that fall victim. IBM i enjoys an enviable reputation for security, but no system is impervious to mistakes.
    Join this webinar to learn about the biggest errors made when securing a Power Systems server.
    This knowledge is critical for ensuring integrity of your application data and preventing you from becoming the next Equifax. It’s also essential for complying with all formal regulations, including SOX, PCI, GDPR, and HIPAA
    Watch Now.

  • Comply in 5! Well, actually UNDER 5 minutes!!

    SB CYBRA PPL 5382

    TRY 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.

    Request your trial now!

  • Backup and Recovery on IBM i: Your Strategy for the Unexpected

    FortraRobot automates the routine 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:
    - Simplified backup procedures
    - Easy data encryption
    - Save media management
    - Guided restoration
    - Seamless product integration
    Make sure your data survives when catastrophe hits. Try the Robot Backup and Recovery Solution FREE for 30 days.

  • Manage IBM i Messages by Exception with Robot

    SB HelpSystems SC 5413Managing messages on your IBM i can be more than a full-time job if you have to do it manually. 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:
    - Automated message management
    - Tailored notifications and automatic escalation
    - System-wide control of your IBM i partitions
    - Two-way system notifications from your mobile device
    - Seamless product integration
    Try the Robot Message Management Solution FREE for 30 days.

  • Easiest Way to Save Money? Stop Printing IBM i Reports

    FortraRobot 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:

    - Automated report distribution
    - View online without delay
    - Browser interface to make notes
    - Custom retention capabilities
    - Seamless product integration
    Rerun another report? Never again. Try the Robot Report Management Solution FREE for 30 days.

  • Hassle-Free IBM i Operations around the Clock

    SB HelpSystems SC 5413For over 30 years, Robot has been a leader in systems management for IBM i.
    Manage your job schedule with the Robot Job Scheduling Solution. Key features include:
    - Automated batch, interactive, and cross-platform scheduling
    - Event-driven dependency processing
    - Centralized monitoring and reporting
    - Audit log and ready-to-use reports
    - Seamless product integration
    Scale your software, not your staff. Try the Robot Job Scheduling Solution FREE for 30 days.