Products & Services

NGS-IQ™ Release 6.50
PDF Version

6.50 is the latest release of NGS-IQ. This release introduces the addition of a new module to the NGS-IQ business intelligence suite, IQ Client. Highlights of this release are listed below to assist current and prospective NGS-IQ customers in their planning and evaluation process. New Generation Software, Inc. (NGS) reserves the right to change the contents and availability of its software at any time without notice. Please contact your NGS sales representative for more details.

IQ Server

Enhanced XML File Definition

The results of report break summary and new field calculations are now assigned their own, individual XML tags when you output your query result in XML format. This provides users with greater flexibility when generating XML files and potentially simplifying the development of dashboards with the NGS Business Performance Dashboard solution.

Enhanced Date New Field Formatting

You now have the ability to create a date new field from an existing date field, character field, literal, or system value and output the new date new field in MM/DD/YYYY, YYYY-MM-DD (ISO), DD.MM.YYYY, YYYY-MM-DD (JIS), MM/DD/YY, DD/MM/YY, YY/MM/DD, or YY/DDD format. When outputting a date new field in one of the last four formats listed in the previous sentence, you can assign a forward slash, hyphen, period, comma, or blank as the separator.

Enhanced Time New Field Generation

You now have the ability to create a time new field from an existing character value in a character field, literal, or system value.

Enhanced Timestamp Field Generation

You now have the ability to create a timestamp new field from an existing character value in a character field, literal, or system value.

Enhanced Security

NGS-IQ now supports the use of long and mixed case passwords when connecting from Qport Access to the System i, and when attempting to invoke the FTP and Remote Network Output file functions. Using longer passwords and both upper and lower case characters dramatically increases the number of passwords that can be assigned and reduces your vulnerability to unauthorized user access.

Enhanced ASCII File Output Function

When creating an ASCII delimited or text output file, you can now indicate whether or not you want NGS-IQ to put your field names or column headings into the first row of your output. This makes it much easier for those receiving these files to understand their data.

Greater Control Over the Size of Output Files

The value you assign to the NGS-IQ global default keyword OUTFSIZE (output file size) now applies to all forms of NGS-IQ output, including CSV, TXT, PDF, XML, HTML, and DB2.

IQ Client

IQ Client - NGS-IQ's new, separately licensed, Windows "Smart Client" Query Development Module

IQ Client is the new NGS-IQ Windows query development tool. With IQ Client, a user works in a highly productive, drag-and-drop, point-and-click Windows user interface that supports offline query development and revision. Queries and DB2 database structures, but not actual records with data, are copied to the local environment from the System i and used offline. When the user is satisfied with his or her design, he or she can transfer the query to the System i for storage and immediate processing. Once on the System i, a query developed or revised with IQ Client may be run or revised like any other NGS-IQ query. Users can even use IQ Server and Qport Builder to open, revise, and run a query developed in IQ Client. All security enforcement and data storage remains on the System i.

IQ Client brings all of the power of IQ Server to the Windows desktop, but without sacrificing the benefits of native, i5/OS, and batch query processing.

New Generation Software, Inc. (NGS) reserves the right to change the contents and availability of its software at any time without notice.

NGS-IQ, IQ Server, Qport Access, Builder, and SmartView are trademarks of New Generation Software, Inc. All other trademarks are the property of their respective owners.