IBM has introduced a number of SQL Views and table functions in the past few IBM i operating system releases and Technology Refreshes. These functions allow anyone to do things with spool files that previously required using Application Program Interfaces (APIs) or writing complex programs.

During this presentation 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), and extract information from spool files.

Power 10, IBM i 7.5, Subscriptions, License Simplification, Db2 Mirror, Merlin, and More: What's in It For Me?

In 2022, IBM rolled out Power 10 servers, IBM i 7.5, new licensing and subscription offers, Merlin, IBM i software enhancements, and more. Keeping up with that much news isn’t easy. In this video, experts from NGS and Datanational Corporation filter and analyze those announcements to help you decide how they apply to you. The presentation closes with the announcement of the NGS-IQ Subscription offering for new NGS customers. 70 minutes.

Since the early days of OS/400, job scheduling has been common in IBM i environments. But over time, new releases get installed, and companies and staff members continually change. Eventually, users forget valuable IBM i features or neglect training new staff.

As a query, reporting, and analytics software provider for IBM i, our staff regularly receives questions about job scheduling. The topic comes up so often we decided to enlist help from an expert, Russ Afton of Arbor Solutions, to present this overview of IBM i's job scheduling features. Approx. 45 minutes.

In this video, we explain NGS' Query/400 Application Program Interface (API) and the IBM SPOOLED_FILE_DATA command - two simple methods you can use to leverage legacy queries and spool files.

This video features respected IBM i programming expert, Simon Hutchinson of www.rpgpgm.com, who explains SQL Views and how you can use them to support database access. A short demonstration of NGS-IQ concludes the presentation. Approx. 60 minutes.