NGS-IQ Demonstration Playbacks

Share and Learn Playbacks

See Our Short Tutorials - Less Than 10 Minutes!

Google Fusion Tables provide a very easy way for users working from virtually any Web-enabled device (smartphone, tablet, PC) to quickly generate Google maps from addresses and business graphics like pie charts and line charts from your query output. Approximately 15 minutes.

The SENDEMAIL command is a feature of IQ Server you can use to distribute DB2 files to users in CSV and TXT format, files stored on your IBM i's Integrated File System (IFS), and spool files. You can use it with files generated by NGS-IQ as well as your own applications, custom programs, and other tools. Approximately 15 minutes.

The LSTQRYREF command may be used to identify the files and/or fields referenced in queries. It is another valuable tool a query developer can use to gain a deeper understanding of existing queries and also to identify queries that reference objects that have changed in your database. Approximately seven minutes.

Query Definition Tables are a valuable source of technical documentation for your NGS-IQ queries. Query Definition Tables can be generated from IQ Server and IQ Client to show you the files, fields, sorts, selections, new fields, summaries, and other characteristics used in the design of the query. If you use the IQ SeQure security management system at release 7.1 of NGS-IQ, you can also copy/paste information from a Query Definition Template into the extended description of a query to help make the query easier to locate when conducting inventory searches. Approximately five and a half minutes.

When developing a query, you can assign edit codes to numeric and date fields to control how they are formatted when a query is output to print, screen, PDF, Microsoft Word, and HTML. Approximately eight minutes.

The CHGQRYLIB command provides an easy way to change the library associated with a selected file in a query without having to open and revise the query. One potential use of this command is to make a query check the user's IBM i library list at run time to determine which DB2 file to query. Approximately four and a half minutes.

The Query Inventory feature enables you to extensively document your queries with descriptions, extended descriptions, and keywords that can serve as valuable notes - notes you and others can search to find queries that might help meet a current need. Don't write a new query when you or someone else has already created one that is nearly identical just because you can't remember the other query's name and library. Any customer with a license of IQ SeQure can take advantage of this feature upon installing release 7.1. Approximately 14 minutes.

People ask us every day whether we can convert queries they've developed in IBM Query/400 to run from NGS-IQ and take advantage of the many additional functions NGS-IQ offers. The NGS-IQ Query/400 API is the answer. Using this API, provided at no cost to NGS-IQ customers on maintenance, you can run any Query/400 queries from inside NGS-IQ without having to convert or rewrite them. Suddenly, every Query/400 query your company runs can be enhanced with run-time prompting, new output options like Excel, PDF, HTML, XML, and distributed using NGS-IQ's integrated email and FTP options. Take 20 minutes, (yes, we admit, this tutorial exceeds our 10 minutes rule), and learn how you can begin using the Query/400 API today.

Watch a short video and learn how to create meta files that can greatly simplify query development. You can create a meta file in seconds with descriptive file and field names that a business user can understand. You can also pre-define the join relationship between two or more files, so your users can find the data they need without having to understand the complex structure of your database. Don't overlook this powerful NGS-IQ feature. Approximately five minutes.

Get a quick introduction to SmartView and learn how to create a SmartView file you would like NGS to help you format. Approximately seven minutes.

See how you can format a SmartView presentation and use features like pivot, drill down, and charting to help you analyze your data. Approximately nine minutes.

Learn how to use the new WebRunner feature of IQ Server to run any NGS-IQ query from your favorite Web browser. Then, see how fast you can use the new HTML formatting features of IQ Client to make your query output sizzle when viewed over the Web. Approximately five minutes.

Learn how to use the meta-data function of NGS-IQ to pre-define joins between files so that your query developers don't need to understand the file relationships. Approximately seven minutes.

Get acquainted with the design, look, and feel of IQ Client, the Windows desktop query development module of NGS-IQ. IQ Client offers query developers a powerful drag-drop, point-click interface with all of the function of IQ Server, plus comprehensive HTML Web report design capabilities. Approximately six minutes.

See how easy it is to develop a query using IQ Client from selecting files, creating a new field, creating a run-time prompt for record selection, sorting, summarizing, and generating Web output. Approximately eight minutes.

Get acquainted with the design, look, and feel of Qport Access, the Windows desktop query execution module of NGS-IQ. Qport Access makes it easy to output query results to Microsoft Excel, Word, and Access; NGS SmartView; and other applications. Approximately five minutes.

Learn how easy it is to output query results to Microsoft Excel with Qport Access. See how you can use the advanced features of Qport Access to do much more than simple file transfers. Approximately nine minutes.