NGS Blog - i View i View

Category: Education

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:


Free IBM i Education: Tricks with Spool Files Using SQL

Posted on January 23, 2025 by Bill Langston

IBM i software developers, operators, and system administrators deserve a lot of respect. Their mostly invisible efforts literally enable businesses around the world to process trillions of dollars of economic output each year. However, IBM i and the integrated Db2 on i database make up a very specialized enterprise computing environment. IBM i doesn’t run on ubiquitous personal devices like phones, laptops, and tablet computers; it runs exclusively on IBM POWER servers. In other words, you aren’t likely to find a lot of useful IBM i education on YouTube or tips on social media. Read more arrow


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


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


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


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 arrow


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 arrow


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 arrow


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 arrow


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 arrow


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 arrow


Web Reporting Made Easy and
Using NGS-IQ with Microsoft 365

Posted on August 18, 2022 by Bill Langston

WebRunner is built into NGS-IQ, but maybe you haven't had time to get familiar with IQ Client's HTML formatting features. Read more arrow


Microsoft 365 and IBM Db2 on i

Posted on June 28, 2022 by Bill Langston

Technically, a Microsoft 365 user can connect to Db2 on i through the IBM Access Client Solutions (ACS) ODBC driver. But in practice, few Microsoft 365 users understand their company’s Db2 on i database well enough to join tables, select columns, and format the data they need. Read more arrow


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 arrow


Discover the IBM i Ecosystem

Posted on January 10, 2022 by Bill Langston

IBM i is a unique and proven enterprise computing platform. IBM announces software, operating system releases, technology refreshes, and new hardware periodically, but often the specific information you need to complete a task or explain a concept effectively isn’t in those announcement letters. Read more arrow

twitter logoFollow us on Twitter.

Categories

arrowEducation (17)
arrowEnterprise Software (1)
arrowIBM i Marketplace (4)

Recent Posts

Archives

Subscribe to our blog

How we protect your information