1<!DOCTYPE html> 2<html><!-- InstanceBegin template="/Templates/blog.dwt" codeOutsideHTMLIsLocked="false" --> 3<head> 4<!-- Google Tag Manager --> 5
6<script>
vendor: 327 bytes, line 6
6(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start': new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0], j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src= 'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f); })(window,document,'script','dataLayer','
6GTM-PJRPDJDR
vendor: 3 bytes, line 6
6');
6</script>
6 7 8<!-- End Google Tag Manager --> 9 10<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> 11 12<title>NGS Blog</title> 13 14<link href="http://www.ngsi.com/company/css/blog.css" rel="stylesheet" type="text/css"> 15<link href="http://www.ngsi.com/company/css/blognav.css" rel="stylesheet" type="text/css"> 16<link href="https://fonts.googleapis.com/css?family=Fugaz+One" rel="stylesheet" type="text/css"><br> 17 18<!-- Insert favicon --> 19<link rel="shortcut icon" href="http://www.ngsi.com/company/images/ngs-favicon.ico"> 20<link rel="apple-touch-icon" href="http://www.ngsi.com/company/images/ngs-favicon.png"> 21
22<SCRIPT type="text/javascript"> 23<!-- Begin Current Date 24var day=""; 25var month=""; 26var myweekday=""; 27var year=""; 28mydate = new Date(); 29myday = mydate.getDay(); 30mymonth = mydate.getMonth(); 31myweekday= mydate.getDate(); 32weekday= myweekday; 33myyear= mydate.getYear(); 34if (myyear < 2000) myyear += 1900; 35year = myyear 36if(myday == 0) 37day = " Sunday" 38else if(myday == 1) 39day = " Monday" 40else if(myday == 2) 41day = " Tuesday" 42else if(myday == 3) 43day = " Wednesday" 44else if(myday == 4) 45day = " Thursday" 46else if(myday == 5) 47day = " Friday" 48else if(myday == 6) 49day = " Saturday" 50if(mymonth == 0) { 51month = "January "} 52else if(mymonth ==1) 53month = "February " 54else if(mymonth ==2) 55month = "March " 56else if(mymonth ==3) 57month = "April " 58else if(mymonth ==4) 59month = "May " 60else if(mymonth ==5) 61month = "June " 62else if(mymonth ==6) 63month = "July " 64else if(mymonth ==7) 65month = "August " 66else if(mymonth ==8) 67month = "September " 68else if(mymonth ==9) 69month = "October " 70else if(mymonth ==10) 71month = "November " 72else if(mymonth ==11) 73month = "December " 74// End Current Date --> 75</SCRIPT>
75 76 77<!-- Google Analytics tracking code START -->
78<script type="text/javascript"> 79 80 var _gaq = _gaq || []; 81 _gaq.push(['_setAccount', 'UA-42055234-1']); 82 _gaq.push(['_trackPageview']); 83 84 (function() { 85 var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true; 86 ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js'; 87 var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s); 88 })(); 89 90</script>
90 91 92<!-- Google Analytics tracking code END --> 93 94<!-- Google tag (gtag.js) -->
vendor: 66 bytes, lines 94-95
94 95<script async src="https://www.googletagmanager.com/gtag/js?id=
95AW-1067762979
vendor: 12 bytes, line 95
95"></script>
95<script>
vendor: 127 bytes, line 95
95window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', '
95AW-1067762979
vendor: 4 bytes, line 95
95');
95</script>
95 96 97<!-- Visitor Queue tracking code START --> 98
99<script>function vqTrackId(){return '6d88a38a-10df-4cfb-aba2-9007de880ae1';} (function(d, e) { var el = d.createElement(e); el.sa = function(an, av){this.setAttribute(an, av); return this;}; el.sa('id', 'vq_tracking').sa('src', '//t.visitorqueue.com/p/tracking.min.js?id='+vqTrackId()).sa('async', 1).sa('data-id', vqTrackId()); d.getElementsByTagName(e)[0].parentNode.appendChild(el); })(document, 'script'); </script>
99 100 101<!-- Visitor Queue tracking code END --> 102 103<!-- Google tag (gtag.js) -->
vendor: 67 bytes, lines 103-105
103 104 105<script async src="https://www.googletagmanager.com/gtag/js?id=
105G-MHYFY5WFGN
vendor: 13 bytes, line 105
105"></script>
106<script> 107
vendor: 138 bytes, lines 107-111
107window.dataLayer = window.dataLayer || []; 108 function gtag(){dataLayer.push(arguments);} 109 gtag('js', new Date()); 110 111 gtag('config', '
111G-MHYFY5WFGN
vendor: 5 bytes, line 111
111');
112</script>
112 113 114<!-- Google tag code END --> 115 116</head> 117 118<body> 119 120<!-- Google Tag Manager (noscript) -->
vendor: 72 bytes, lines 120-122
120 121 122<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=
122GTM-PJRPDJDR
vendor: 87 bytes, lines 122-123
122" height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript> 123
124<!-- End Google Tag Manager (noscript) --> 125 126<div class="doctitle"> 127 <h1> <a href="http://www.ngsi.com/company/blog/blog.html"><img src="http://www.ngsi.com/Company/blog/images/NGS_Logo_Long320.jpg" width="320" height="62" alt="NGS Blog - i View"></a> i View</h1> 128</div> 129 130<section> 131 132 <!-- InstanceBeginEditable name="blogpost" --> 133 <div> 134 <h2 class="subhdgray">Introducing NGS-IQ Report Distribution and <br> 135Release 7.2 Video Library Resources </h2> 136 <p><span class="post">Posted on <a href="http://www.ngsi.com/company/blog/blog-202508.html" title="August 2025">August 28, 2025</a> by <a href="http://www.ngsi.com/company/blog/author-moy.html" title="Blog Author">Teresa Moy</a></span></p> 137 <p><img src="../../Events/webinar2025_08_21.jpg" alt="NGS Webcast" width="332" height="221" align="right" hspace="25">During this <a href="http://www.ngsi.com/events/webcastform-vod.php?p_seq=5">video</a> (recorded August 21), you'll learn how to use <em>NGS-IQ</em>'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.</p> 138 <p><span class="comment">Posted in <a href="http://www.ngsi.com/company/blog/blog-education.html" title="Education">Education</a> | <a href="mailto:[email protected]?subject=Blog Comments" title="Comments">Comments</a></span></p> 139 <p> </p> 140 <p> </p> 141 <p> </p> 142 <hr> 143 <h2 class="subhdgray">Creating Great Data for Enterprise AI </h2> 144 <p><span class="post">Posted on <a href="http://www.ngsi.com/company/blog/blog-202507.html" title="July 2025">July 1, 2025</a> by <a href="http://www.ngsi.com/company/blog/author-langston.html" title="Blog Author">Bill Langston</a></span></p> 145 <p><img src="../../Events/webinar2025_06_26.jpg" alt="NGS Webcast" width="332" height="221" align="right" hspace="25">Enterprise AI requires many data types and sources. During this <a href="http://www.ngsi.com/events/webcastform-ngsiq-vod.php?p_seq=38">presentation</a> (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 <em>NGS-IQ</em> can help you get started. Approximately one hour.</p> 146 <p><span class="comment">Posted in <a href="http://www.ngsi.com/company/blog/blog-education.html" title="Education">Education</a> | <a href="mailto:[email protected]?subject=Blog Comments" title="Comments">Comments</a></span></p> 147 <p> </p> 148 <p> </p> 149 <p> </p> 150 <hr> 151 <h2 class="subhdgray">Simplifying IBM i Query, Reporting, and Analytics </h2> 152 <p><span class="post">Posted on <a href="http://www.ngsi.com/company/blog/blog-202504.html" title="April 2025">April 30, 2025</a> by <a href="http://www.ngsi.com/company/blog/author-moy.html" title="Blog Author">Teresa Moy</a></span></p> 153 <p><img src="../../Events/webinar2025_04_24.jpg" alt="NGS Webcast" width="332" height="221" align="right" hspace="25">Watch this <a href="http://www.ngsi.com/events/webcastform-ngsiq-vod.php?p_seq=28">demonstration</a> (recorded April 24) and learn how you can use <em>NGS-IQ</em>'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.</p> 154 <br> 155 <p><span class="comment">Posted in <a href="http://www.ngsi.com/company/blog/blog-education.html" title="Education">Education</a> | <a href="mailto:[email protected]?subject=Blog Comments" title="Comments">Comments</a></span></p> 156 <p> </p> 157 <p> </p> 158 <hr> 159 <h2 class="subhdgray">More Release 7.2 Enhancements, Analytical Summary Tables for Reports, and Basic Web Report Design</h2> 160 <p><span class="post">Posted on <a href="http://www.ngsi.com/company/blog/blog-202504.html" title="April 2025">April 18, 2025</a> by <a href="http://www.ngsi.com/company/blog/author-moy.html" title="Blog Author"> Teresa Moy</a></span></p> 161 <p><img src="http://www.ngsi.com/events/webinar2025_04_10.jpg" width="332" height="221" alt="BI on IBM i" align="right" hspace="25">During this <a href="http://www.ngsi.com/events/webcastform-vod.php?p_seq=27">presentation</a> (recorded April 10, 2025), we demonstrated how to take advantage of more <em>NGS-IQ</em> release 7.2 enhancements, including:</p> 162 <ul> 163 <li>two helpful new field functions</li> 164 <li>the search query definition template command</li> 165 <li>the email job log and query definition template function</li> 166 </ul> 167 <p>We also stepped through making reports more helpful to decision makers by adding analytical summary tables to your report breaks. After building a query with these summaries, we used <em>IQ Client</em>'s web report design features to format the query output. </p> 168 <p><span class="comment">Posted in <a href="http://www.ngsi.com/company/blog/blog-education.html" title="Education">Education</a> | <a href="mailto:[email protected]?subject=Blog Comments" title="Comments">Comments</a></span></p> 169 <hr> 170 <h2 class="subhdgray">Webcast: Tricks with Spool Files Using SQL</h2> 171 <p><span class="post">Posted on <a href="http://www.ngsi.com/company/blog/blog-202502.html" title="February 2025">February 7, 2025</a> by <a href="http://www.ngsi.com/company/blog/author-moy.html" title="Blog Author"> Teresa Moy</a></span></p> 172 <p><img src="http://www.ngsi.com/events/webinar2025_02_06_playback.jpg" width="332" height="221" alt="BI on IBM i" align="right" hspace="25">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.</p> 173 <p>During this <a href="http://www.ngsi.com/Events/webcastform-vod.php?p_seq=20">webcast</a> presented by IBM i Champion and RPGPGM.com founder, Simon Hutchinson, you'll learn how to: </p> 174 <ul> 175 <li>use SQL to work with spool files in a partition</li> 176 <li>delete spool files</li> 177 <li>copy spool files to Adobe PDF in the Integrated File System (IFS)</li> 178 <li>extract information from spool files.</li> 179 </ul> 180 <p><span class="comment">Posted in <a href="http://www.ngsi.com/company/blog/blog-education.html" title="Education">Education</a> | <a href="mailto:[email protected]?subject=Blog Comments" title="Comments">Comments</a></span></p> 181 <hr> 182 <h2 class="subhdgray">Free IBM i Education: Tricks with Spool Files Using SQL</h2> 183 <p><span class="post">Posted on <a href="http://www.ngsi.com/company/blog/blog-202501.html" title="January 2025">January 23, 2025</a> by <a href="http://www.ngsi.com/company/blog/author-langston.html" title="Blog Author">Bill Langston</a></span></p> 184 <p><img src="http://www.ngsi.com/events/webinar2025_02_06.jpg" alt="NGS Webinar" align="right" hspace="25"><strong>IBM i: A Specialized Enterprise Computing Environment</strong></p> 185 <p>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. </p> 186 <p> Unless you work for a company that relies on IBM i, you may not know it exists, much less appreciate the benefits it provides. If you do work on IBM i, you might not live near a user group, and
186your job, budget, and personal obligations might make traveling to IBM i events difficult. As a result, IBM i education can seem a bit hard to access.</p> 187 <p> <strong>IBM i Champion, Simon Hutchinson</strong></p> 188 <p>In business, companies tend to focus on achieving quarter-to-quarter or year-to-year revenue targets. We’re no exception. The NGS staff focuses on developing, supporting, and marketing <em>NGS-IQ</em> – our widely used IBM i query, reporting, and analytics software. But we’re IBM i specialists, and our success depends on the broader success of IBM i and that depends on IT professionals in IBM i shops making the platform shine. So, periodically, we shift our focus from <em>NGS-IQ</em> to the support of IBM i education. We also maintain an <a href="http://www.ngsi.com/company/IBM-i-benefits.html">IBM i resources</a> page on our website.</p> 189 <p>One of the best sources of IBM i education is the <a href="http://www.RPGPGM.com">RPGPGM.com</a> blog, founded and actively updated by independent IBM i Champion, Simon Hutchinson. This blog is Simon’s gift to the people who use the platform he loves. Simon isn’t on the payroll of IBM or any IBM Business Partner. He’s not an NGS customer or a consultant hoping to sell his services. He has a day job just like you. Fortunately, his passion for IBM i drives him to document and share original, practical educational content on RPGPGM.com. He also speaks at <a href="http://www.common.org">COMMON</a> and regional IBM i user group meetings and conferences around the world. </p> 190 <p><strong>IBM i Educational Event: Tricks with Spool Files using SQL</strong></p> 191 <p> On Thursday, February 6, 2025, we’ve asked Simon to bridge the geographical, work and personal commitments that separate IBM i professionals and share some of his knowledge during normal business hours. His topic is “Tricks with Spool Files Using SQL.” We encourage you to register and attend this webinar. We plan to record the session, so please register even if you can’t attend live, and we'll send you the link to the video as soon as it is available.</p> 192 <p> During this event, you won’t see a demo of <em>NGS-IQ</em>. Of course, we hope you’ll attend an <em>NGS-IQ</em> webinar in the near future or visit our video library and watch a previously recorded demonstration. Even if you don’t write queries, once you see what <em>NGS-IQ</em> can do, we think you'll understand why it's so popular.</p> 193 <p>Please take advantage of this free opportunity to learn from one of the best IBM i educators. </p> 194 <p>FREE Webinar: February 6, 2025<br> 195 Time: 11:00am PT | 1:00pm CT | 2:00pm ET</p> 196 <p><span class="comment">Posted in <a href="http://www.ngsi.com/company/blog/blog-education.html" title="Education">Education</a> | <a href="mailto:[email protected]?subject=Blog Comments" title="Comments">Comments</a></span></p> 197 </div> 198 <!-- InstanceEndEditable --> 199 200 <div class="aside"> 201 202<ul class="nav"> 203<li><a href="http://www.ngsi.com" target="_self">NGS Website</a></li> 204<li><a href="http://www.ngsi.com/company/blog/blog.html" target="_self">Blog Home</a></li> 205<li><a href="http://www.ngsi.com/company/IBM-i-benefits.html" target="_self">IBM i Resources, White Papers, and Experts</a></li> 206<li><a href="http://www.ngsi.com/company/contactus.html" target="_self">Contact Us</a></li> 207</ul> 208 209 <p><em><a href="https://www.linkedin.com/company/new-generation-software"><img src="../icon_linkedIn1.gif" alt="" width="150" height="55"></a></em></p> 210 <p><em>C</em><em>ategories</em></p> 211 <p><img src="http://www.ngsi.com/company/blog/images/blogbullet1.gif" width="21" height="19" alt="arrow"><a href="http://www.ngsi.com/company/blog/blog-education.html" title="Education">Education</a> (21)<br> 212 <img src="http://www.ngsi.com/company/blog/images/blogbullet1.gif" width="21" height="19" alt="arrow"><a href="http://www.ngsi.com/company/blog/blog-enterprise.html" title="Enterprise Software">Enterprise Software</a> (1)<br> 213 <img src="http://www.ngsi.com/company/blog/images/blogbullet1.gif" width="21" height="19" alt="arrow"><a href="http://www.ngsi.com/company/blog/blog-IBMi-marketplace.html" title="IBM i Marketplace">
213IBM i Marketplace</a> (3)</p> 214 <p><em>Recent Posts</em></p> 215 <ul> 216 <li><a href="http://www.ngsi.com/company/blog/blog-20250828-webcast-recording-20250821.html" title="Introducing NGS-IQ Report Distribution and Release 7.2 Video Library Resources">Introducing NGS-IQ Report Distribution and Release 7.2 Video Library Resources</a><br> 217August 28, 2025</li> 218 <li><a href="http://www.ngsi.com/company/blog/blog-20250701-webcast-recording-20250626.html" title="Creating Great Data for Enterprise AI">Creating Great Data for Enterprise AI</a><br> 219July 1, 2025</li> 220 <li><a href="http://www.ngsi.com/company/blog/blog-20250430-webcast-recording-20250424.html" title="Simplifying IBM i Query, Reporting, and Analytics">Simplifying IBM i Query, Reporting, and Analytics</a><br> 221April 30, 2025</li> 222 <li><a href="http://www.ngsi.com/company/blog/blog-20250418-webcast-recording-20250410.html" title="More Release 7.2 Enhancements, Analytical Summary Tables for Reports, and Basic Web Report Design">More Release 7.2 Enhancements, Analytical Summary Tables for Reports, and Basic Web Report Design</a><br> 223 April 18, 2025</li> 224 <li><a href="http://www.ngsi.com/company/blog/blog-20250207-webcast-recording-20250206.html" title="Webcast: Tricks with Spool Files Using SQL">Webcast: 225 Tricks with Spool Files Using SQL</a><br> 226 February 7, 2025</li> 227 <li><a href="http://www.ngsi.com/company/blog/blog-20250123-tricks-with-spool-files-using-SQL.html" title="Free IBM i Education: Tricks with Spool Files Using SQL">Free IBM i Education: <br> 228Tricks with Spool Files Using SQL</a><br> 229January 23, 2025</li> 230 </ul> 231 <p><em>Archives</em></p> 232 <ul> 233 234 235 <li><a href="http://www.ngsi.com/company/blog/blog-202508.html" title="August 2025">August 2025</a> (1)</li> 236 <li> <a href="http://www.ngsi.com/company/blog/blog-202507.html" title="July 2025">July 2025</a> (1)</li> 237 <li><a href="http://www.ngsi.com/company/blog/blog-202504.html" title="April 2025">April 2025</a> (2)</li> 238 <li><a href="http://www.ngsi.com/company/blog/blog-202502.html" title="February 2025">February 2025</a> (1)</li> 239 <li> <a href="http://www.ngsi.com/company/blog/blog-202501.html" title="January 2025">January 2025</a> (1)</li> 240 <li><a href="http://www.ngsi.com/company/blog/blog-2024.html" title="2024"> 2024</a> (11)</li> 241 242 <li><a href="http://www.ngsi.com/company/blog/blog-2023.html" title="2023">2023</a> (5)</li> 243 <li><a href="http://www.ngsi.com/company/blog/blog-2022.html" title="2022">2022</a> (3)</li> 244 </ul> 245 <p><em>Subscribe to our blog</em></p> 246 <FORM ACTION="/cgi-bin/ourfmprog.pl" METHOD="post"> 247 <p> 248 <label>First Name*<br> 249 <input type="text" name="firstname" id="firstname"> 250 </label> 251 </p> 252 <p> 253 <label>Last Name*<br> 254 <input type="text" name="lastname" id="lastname"> 255 </label> 256 </p> 257 <p> 258 <label>Email Address*<br> 259 <input name="email address" type="text" id="email address" maxlength="50"> 260 </label> 261 </p> 262 <p> 263 <input type="submit" name="submit" id="submit" value="Send"> 264 </p> 265 <h6><a href="http://www.ngsi.com/company/privacy-policy.html#data">How we protect your information</a></h6> 266 <P> 267 <INPUT TYPE="hidden" NAME="email" VALUE="[email protected]"> 268 <INPUT TYPE="hidden" NAME="realname" VALUE="NGS Website http://www.ngsi.com/company/blog/blog.html"> 269 <INPUT TYPE="hidden" NAME="recipient" VALUE="[email protected]"> 270 <INPUT TYPE="hidden" NAME="subject" VALUE="NGS Blog - subscribe"> 271 <INPUT TYPE="hidden" NAME="redirect" 272 VALUE="http://www.ngsi.com/company/blog/blogsubscribe-ty.html"> 273 <INPUT TYPE="hidden" NAME="required" 274 VALUE="firstname,lastname,email address"> 275 </P> 276 </form> 277 </div> 278 279</section> 280 281<div class="footer"> 282<p align="center"><a href="http://www.ngsi.com/company/privacy-policy.html"><img src="../icon_cookies.jpg" width="115" height="55" alt="We Use Cookies"></a></p> 283<h6 align="center">Copyright & Copy; 284
284<script type="text/javascript"> 285document.write(year); 286 </script>
286 287 New Generation Software, Inc. All rights reserved. </h6> 288</div> 289 290<!-- Google Code for Remarketing Tag --> 291<!-------------------------------------------------- 292Remarketing tags may not be associated with personally identifiable information or placed on pages related to sensitive categories. See more information and instructions on how to setup the tag on: http://google.com/ads/remarketingsetup 293--------------------------------------------------->
294<script type="text/javascript"> 295/* <![CDATA[ */ 296var google_conversion_id = 1067762979; 297var google_custom_params = window.google_tag_params; 298var google_remarketing_only = true; 299/* ]]> */ 300</script>
vendor: 2 bytes, line 300
300
301<script type="text/javascript" src="//www.googleadservices.com/pagead/conversion.js"> 302</script>
302 303<noscript> 304<div style="display:inline;"> 305<img height="1" width="1" style="border-style:none;" alt="" src="//googleads.g.doubleclick.net/pagead/viewthroughconversion/1067762979/?value=0&guid=ON&script=0"> 306</div> 307</noscript> 308 309<!-- Google code for which ad campaign generated the hit --> 310
311<script> 312 window.addEventListener('load', function(){ 313 if(document.location.pathname.includes('/confirmation-register.html')){ 314 gtag('event', 'conversion', {'send_to': 'AW-1067762979/rYmuCNXfl5UYEKOKk_0D'}); 315 } 316 }); 317</script>
317 318 319</body> 320<!-- InstanceEnd --></html>
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.