• One Way To Condense A Verbose Spooled File

  November 29, 2016 Ted Holt

  IBM i includes many reports that we can use to glean a lot of information. If you run packaged software, the vendor likely includes many other reports. The problem with such reports is that they often contain more information than what you need and want. After all, they’re written for the world at large, not tailored for you. It may be that a utility that resides on your system can transform reports into something more suitable for you and those who use your system. First, let’s get a report. DSPLNK OUTPUT(*PRINT) DETAIL(*EXTENDED) DSPOPT(*USER) Running this command on one of the

  …

  Read more

• What Koch’s $2.5 Billion Infor Investment Means For IBM i

  November 28, 2016 Alex Woodie

  Koch Equity Development LLC, the private equity arm of Koch Industries, will invest more than $2 billion into IBM i ERP giant Infor, the companies announced last week. Infor says it will use the cash to expand its business, while news reports say some of it will go to pay off earlier investors in the company. Infor wouldn’t comment on questions about what exactly it’s going to spend KED’s reported $2.5 billion investment, beyond what it said in the press release. Even IBM i customers would benefit, an Infor spokesman said. “All existing and future customers will reap

  …

  Read more

• DB2 For IBM i: Made But Not Mastered

  November 28, 2016 Dan Burger

  IBM recently hosted an SAP on IBM i conference for customers and business partners. The conference is described as a showcase of best practices and advice on deployment of the latest technologies. IBM’s lineup of experts included Scott Forstie, DB2 for i Business Architect and a member of the DB2 on i Lab Services team. Forstie says interest in the new analytic features and OLAP functions available in DB2 for i surpasses anything to do with HANA. “Many attendees come to a conference like this to concentrate on better ways to use what they already own and to get the

  …

  Read more

• The Supercomputer At The Heart Of The Power Systems Revival

  November 28, 2016 Timothy Prickett Morgan

  With both the Supercomputing 2016 conference and Thanksgiving Day behind me, I find myself being thankful that the engineers that helped IBM make the transition from proprietary 48-bit CISC processors to 64-bit PowerPC processors in 1995–yes, that was more than two decades ago–were forward thinking. But as it turns out, there were other technologies, including massive floating point performance and database acceleration, that may in the long run help the entire Power Systems line not only survive, but thrive. We all know that the PowerPC-AS version of the Power line of chips was the only one of several early attempts

  …

  Read more

• As I See It: Leave It To Cleaver

  November 28, 2016 Victor Rozek

  The grand paradox of humanity’s quest for wisdom is that the truly great questions have no definitive answers. Age-old questions such as: Why am I here? What is the meaning of life? And does the recent election prove that God exists, or that He doesn’t? These are the eternal questions that haunt us and rob us of sleep. But once in a while, like the proverbial blind squirrel bumping into an acorn, we stumble upon an elusive answer. The question in question is: What single quality in a spouse will be most useful to advancing your career? It’s a deliciously

  …

  Read more

• Forced Windows Migration Failures

  November 28, 2016 Dan Burger

  Here’s what 90 percent of the companies don’t do before, during, and after making the decision to migrate from IBM i to Windows. They don’t plan the way they would for any other major business event. Quite possibly that’s because management doesn’t understand the system they currently have and how it works, nor do they understand what the new system entails. Hasty decisions can be costly decisions. Hundreds of thousands of dollars are wasted. A recent blog post by Bob Losey on LinkedIn casts a critical look at these migrations and why so many of them are failures. Bob Losey

  …

  Read more

• Calling SQL Functions From RPG, A Service Program

  November 15, 2016 Paul Tuohy

  Note: The code accompanying this article is available for download here. In this article I would like to introduce a service program that provides RPG subprocedure “wrappers” for using SQL scalar functions. This means you can use an SQL scalar function as if it were an RPG built-in function. Using an SQL scalar function can be a lot easier than using the RPG alternative: Use the UPPER function instead of defining two translation strings and using %XLATE. Use DAYNAME function instead of calculating the day of the week and using an array to provide the day name. Using the

  …

  Read more

• SQL PL–The LOOP Loop

  November 15, 2016 Ted Holt

  In the previous episode of this exciting series, I wrote about FOR, arguably the most useful of the SQL PL looping structures. Next in line of usefulness, in my opinion, is the LOOP structure. Like the rest of SQL PL, this is an easy structure to master, and I am pleased to write about it. In its simplest form, the syntax of the LOOP structure is as follows: LOOP - body - END LOOP Here is a more realistic version of the syntax: label: LOOP - body - END LOOP label The body contains any assortment of simple statements

  …

  Read more

• QTEMP Is A Different Animal

  November 15, 2016 Hey, Ted

  I have a problem with an FTP script. I wish to send a file in QTEMP to a remote system, but the script tries to send the file from QGPL instead. The PUT command does not tell which library to send the file from because our standards prohibit the use of hard-coded library names. Any thoughts will be appreciated. –Al I commend you and other wise people in your shop for outlawing the hard-coding of library names, Al. The library list is a wonderful feature of IBM i, a feature that is sorely missing from other database systems. I have

  …

  Read more

• IBM Cuts Core And Memory Pricing On Entry Power Iron

  November 14, 2016 Timothy Prickett Morgan

  We are always trying to get IBM to do more to promote the IBM i platform and the Power Systems hardware that comprises the physical part of that platform. In days gone by, Big Blue used to make very public and loud pronouncements regarding its ability to bring customers more value for the dollar, often above and beyond the Moore’s Law capacity increases that are just part of the chip business and usually at the tail end of the product cycle as we are now with the Power8 machines that have been shipping since April 2014. IBM is not as

  …

  Read more

Previous Articles Next Articles