Watch and learn how to use Qport Access' Transfer to Host feature, include the last run date and time in your Excel output, design Web reports that enable users to add and share their comments, and select records when field values include apostrophes. Approximately 60 minutes.
Learn about NGS-IQ’s many date functions to simplify date arithmetic, sorting, and record selection. Also, Russ Afton from Arbor Solutions will explain IBM i’s built-in job scheduling features. 75 minutes
This video includes demonstrations to help your productivity, whether you’re a programmer looking for advanced tips, someone who needs to deliver reports via email, or an Excel user looking to save steps when you use NGS-IQ. 60 minutes.
During this video, you'll learn about the best practices for using the QTEMP library, how a mid-size manufacturing company uses NGS-IQ, how to use SQL to extract data from spool files with the SPOOLED_FILE_DATA command, and the benefits of the new SmartView template you'll receive when you schedule a no-cost Business Analyst Tutoring session. One hour.
Learn how to use a temporary output file to pass parameters to a series of queries; format date fields for prompting, sorting, and presentation; and run Qport Access from the host using the STRPCCMD command. We also quickly review the enhancements included in the latest releases of Qport Access and SmartView, plus what's coming soon in IQ Client. 60 minutes.
For the best viewing experience, select 1080p in the quality section of the player settings. Watch this video for a review of the NGS and ProData remote database access solutions, an introduction to the new release of IQ Client, and a presentation of the IBM i Solution Edition program that can help customers lower the cost of upgrading to an IBM POWER9 server. 70 minutes.
For the best viewing experience, select 1080p in the quality section of the player settings. Watch this video for an overview of the enhancements you'll find in the new releases of Qport Access and Qport SmartView followed by a demonstration of these new features in action. 50 minutes.
For the best viewing experience, select 1080p in the quality section of the player settings. Learn how to use the PREV (previous) function in conditional new fields to set and reset counters at the detail level of a query. We use several sample queries to illustrate how you might apply this function to answer business questions.
The video also features a discussion on formatting queries to create output in Excel for users who want to generate 3D maps. Approximately 1 hour.
Learn how to use SQL Views or NGS-IQ meta files to help staff members develop queries more easily, how to format dates so they will sort and present correctly in SmartView, and about some recent email enhancements that are ready for customers to download and install. Approximately 1 hour.
Build several valuable reports using date arithmetic, conditional calculations, transfer to host, query to run next, report breaks, and other functions. See examples based on real-world questions from NGS-IQ customers during recent technical support calls and site visits. 70 minutes.
Learn about the many date functions for converting dates into the formats you need for accurate calculations, sorts, and selections. We also share a tip for documenting the logic and functions used in your new fields and record selections. We wrap up with a quick look at the Query Inventory features of IQ SeQure. 75 minutes.
Learn how to use the absolute value function, how to create and use email address lists to manage output distribution, and when to use "Print Hide" or "Print Never" when formatting a field. See a demo of an NGS-IQ Web report interacting with IBM's Watson Language Translation service.
We also explain what's covered in our Excel Reporting Features and IQ Client Tutoring sessions and how to use our new on-demand video topic search service. 60 minutes.
This presentation focuses on query and report development and wraps up with an overview of how you might use NGS-IQ with Microsoft Power BI to support data visualization requirements.
We demonstrate group by, having, date arithmetic, date formatting, query to run next, HTML report formatting, charting, drill down, and table (file) self joins to build these types of reports: "slow moving inventory," "items ordered together," "items ordered individually," and "how many items were ordered."
Our segment on Microsoft Power BI provides an overview of this software's capabilities and how to use NGS-IQ output to create graphical, Web-based dashboards. 85 minutes.
See an overview of the benefits of the NGS-IQ SeQure security management system. An NGS-IQ Support Specialist leads a demo on using IQ SeQure to control database and query security. Approximately 35 minutes. Part 2 of 2.
NGS-IQ offers a variety of powerful functions so you can work with just about any data to get the information you need and store it for future reference. In this session, you learn how to do the following:
join files on a new field created in your query
join files using record selection
design a query so that the destination of its output on the Integrated File System (IFS) is a variable you control at run time
include your query's name and library in your output to Excel when using Qport Access
learn about the new Web charting and drill down functions planned for the next release of NGS-IQ
Approximately one hour. (Requires Adobe Flash with Java enabled.)
3835 N. Freeway Blvd, Suite 200 Sacramento, CA USA 95834
Office: (916) 920.2200 Sales: (800) 824.1220 Support: (800) 257.2442 Fax: (916) 920.1380