i View

Posts by Teresa Moy

More Release 7.2 Enhancements, Analytical Summary Tables for Reports, and Basic Web Report Design

Posted on April 18, 2025 by Teresa Moy

During this presentation (recorded April 10, 2025), we covered two helpful new field functions, the search query definition template command, and the email job log and query definition template function. We also stepped through making reports more helpful to decision makers and used IQ Client's web report design features to format query output.

---

Latest Recording: Tricks with Spool Files Using SQL

Posted on February 7, 2025 by Teresa Moy

During this webcast presented by IBM i Champion and RPGPGM.com founder, Simon Hutchinson, you'll learn how to:

• use SQL to work with spool files in a partition
• delete spool files
• copy spool files to Adobe PDF in the Integrated File System (IFS)
• extract information from spool files.

---

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

---

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

---

Designing Dashboards for Different Needs and Users

Posted on August 25, 2023 by Teresa Moy

We often hear from NGS-IQ customers who want to develop dashboards. When we inquire about their needs, we quickly find that not everyone uses the term "dashboard" to mean the same thing. Read more

---

Data Visualization and Analytics with NGS-IQ and Microsoft Power BI

Posted on May 30, 2023 by Teresa Moy

Watch this presentation and learn how NGS-IQ can simplify and automate the cleansing, transformation, and delivery of accurate, timely data to Power BI. Read more

---

Mastering NGS-IQ Run-Time Prompting, Translating Data Values, and Serving Data to Microsoft Power BI Users

Posted on April 21, 2023 by Teresa Moy

Check out our webcast from April 13, where you'll learn when to use a new field or record selection to add run-time prompts to queries; how to work with inconsistent data values to support accurate file joins, sorts, and summaries... Read more

---

NGS-IQ: Modernize IBM i Data Access
(Without Programming)

Posted on March 3, 2023 by Teresa Moy

Check out our webcast from February 15, where you'll get an overview of NGS-IQ and see how it connects Microsoft Excel, SharePoint, and Web users to Db2 on i. Read more

---

Queries that Text, Query Links, and Creative Uses for Web Reports

Posted on December 14, 2022 by Teresa Moy

Check out our webcast from December 8, where we discuss queries that text, the Query Reference File command, and accessing data from external sites to produce bar codes and other objects. Read more

---

Valued But Overlooked Features of NGS-IQ

Posted on December 7, 2022 by Teresa Moy

If you use NGS-IQ, please register to attend our next customer webinar. It will be held on December 8, 2022, and recorded for on-demand viewing afterwards. Read more

---

NGS-IQ Tips for All Types of Users

Posted on May 9, 2022 by Teresa Moy

Check out our webcast from April 27, where we discuss using Qport Access' Transfer to Host feature and more solutions. Read more