NGS Blog - i View i View

Archives: 2024

Mastering Summary and Detail Data Delivery to One Excel Workbook, Extended Record Selection, and Adobe PDF Output Choices

Posted on December 19, 2024 by Bill Langston

During this presentation (recorded December 12), you'll see how to develop and run queries to populate detail and summary data to different sheets of a Microsoft Excel workbook. You'll also learn how to use the new extended record selection feature and how to take advantage of the different ways NGS-IQ can generate Adobe PDF files. 50 minutes.


Replacing IBM Query/400 and DB2 Web Query

Posted on October 17, 2024 by Teresa Moy

Are you still relying on IBM’s Query/400 or planning to replace DB2 Web Query now that it’s discontinued? While both tools have served businesses well over the years, the time has come to move beyond their limitations and adopt a more powerful, future-proof solution: NGS-IQ. Read more arrow


Make the Switch: Replace DB2 Web Query and Query/400 with NGS-IQ

Posted on October 3, 2024 by Jeff Coley

Are you still relying on IBM’s Query/400 or scrambling to replace DB2 Web Query now that it’s discontinued? While both tools have served businesses well over the years, the time has come to move beyond their limitations and adopt a more powerful, future-proof solution: NGS-IQ. Read more arrow


Mastering Excel Options, CSV Output, Email, and WebRunner Keywords

Posted on August 28, 2024 by Bill Langston

During this presentation (recorded August 21), we contrast the different ways you can output queries to Microsoft Excel to help you decide which method is best for any business requirement. We also explain the new CSV delimiter and escape character settings, commands to help you manage email distribution lists, and keywords you can use to integrate NGS-IQ web reporting into applications. 55 minutes.


Automating and Simplifying
IBM i Analytics and Reporting with NGS-IQ

Posted on June 26, 2024 by Teresa Moy

NGS-IQ can help you support a wide range of IBM i and business users who need to see and analyze operational data. Read more arrow


Data Access? Meet Managers and Analysts Where They Are

Posted on June 18, 2024 by Bill Langston

The reporting and analytics software marketplace is mature. Historically, business intelligence software vendors designed their solutions to address every step of the data extraction, transformation, and presentation process. As a result, many applications became increasingly complicated and challenging to deploy. Read more arrow


Automating Excel Output, Using IQ EVars, Customizing Web Reports, and Using Email Distribution Lists

Posted on April 25, 2024 by Teresa Moy

During this presentation (recorded April 18), you'll learn how to, use and link Qport Access .IQP files to automate output to Excel sheets, use IQ environment variables to pass run-time variable entries to queries that you run as a series, design a web report to draw attention to important values, customize the web reporting user interface, and use email distribution lists. Approximately 55 minutes.


Planning Your Exit from IBM DB2 Web Query

Posted on March 22, 2024 by Teresa Moy

IBM’s decision to drop DB2 Web Query caught customers by surprise. But as IBM said in their announcement letter, there are alternative solutions. We invite you to learn about ours: NGS-IQ. Read more arrow


Building APIs for IBM i Queries, Reports, and Applications

Posted on February 22, 2024 by Bill Langston

Do you have customers, suppliers, financial institutions, public agencies, or other trading partners who share data through application program interfaces (APIs)? Do you run your enterprise applications on IBM i? If so, you need an easy way to develop and use those APIs. Read more arrow


Enterprise Reporting and Analytics
and Application Program Interfaces (APIs)

Posted on January 24, 2024 by Bill Langston

APIs have become the industry standard for trading partners and customers to share the data they need to efficiently collaborate and provide better service. The people who use your ERP software need access to the data APIs can provide. We believe that NGS-IQ and RPG API Express present an optimal solution for IBM i customers. Read more arrow


IBM DB2 Web Query Security Bulletin, January 2, 2024

Posted on January 8, 2024 by Bill Langston

Just as you were returning to work to begin the new year, IBM published a security bulletin, alerting DB2 Web Query customers that the software is "vulnerable to a remote attacker bypassing security restrictions or executing arbitrary code, to a local authenticated attacker obtaining sensitive information, or to denial of service." Read more arrow

Categories

arrowEducation (21)
arrowEnterprise Software (1)
arrowIBM i Marketplace (3)

Recent Posts

Archives

Subscribe to our blog

How we protect your information