i ViewCategory: Education
Posted on August 28, 2025 by Teresa Moy
During this video (recorded August 21), you'll learn how to use NGS-IQ's report distribution features to burst and deliver separate sections of a query's output to different email addresses and network directories. You'll also learn how to access other valuable release 7.2 educational videos. 58 minutes.
Posted on July 1, 2025 by Bill Langston
Enterprise AI requires many data types and sources. During this presentation (recorded June 26), you'll learn about IBM's AI strategy, data lakes and lakehouses, business considerations before starting your enterprise AI project, and how IBM i and NGS-IQ can help you get started. Approximately one hour.
Posted on April 30, 2025 by Teresa Moy
Watch this demonstration (recorded April 24) and learn how you can use NGS-IQ's development and self-service reporting features to refresh Excel pivot tables and charts, load and format data into multidimensional models, and transform queries into visually appealing web reports. Approximately 50 minutes.
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.
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:
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 
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.
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
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.
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
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
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.
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
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
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
Posted on December 20, 2023 by Teresa Moy
We welcome NGS-IQ users to watch this preview of the forthcoming major new release of NGS-IQ. You'll learn about and see some of the enhancements we have planned. Note: Release availability and new features are subject to change at any time. Check out our webcast from December 13. 55 minutes.
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
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
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
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
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
Categories
Education (21)
Enterprise Software (1)
IBM i Marketplace (3)
Recent Posts
Archives
Subscribe to our blog
