• BMC Touches Clouds with Job Scheduler

  March 20, 2019 Alex Woodie

  Clouds are growing quickly as IT executives look to find more flexibility and cut costs by adopting cloud and software as a service (SaaS) applications. But most enterprises aren’t getting rid of all their on-premise systems, which means somebody needs to connect those cloud and on-premise systems. One of those “somebodies” is BMC Software.

  You might not remember it, but BMC Software still actively supports the IBM i environment with enterprise job scheduler, called CONTROL-M. The Houston, Texas, company has supported the IBM midrange server for years, and continues to do so with the 19th version of CONTROL-M, which the …

  Read more

• Guru: When Playing With SQL

  March 18, 2019 Paul Tuohy

  One of the questions I have been asked a lot at conferences is “How do you figure out x in SQL?” In this article, I will discuss four things I use a lot when playing with SQL in Run SQL Scripts: VALUES, SYSIBM.SYSDUMMY1, global variables, and the system catalog.

  VALUES

  When I am trying to figure out how an SQL function works, my first port of call is the VALUES statement. VALUES derives a result directly from an expression. For example, the following statement:

  values upper('paul');
  

  Would generate the following result set:

  

  You can specify more than one value in …

  Read more

• Building Out The .NET Stack Around Mono for IBM i

  March 13, 2019 Alex Woodie

  The first release of a Mono .NET port to IBM i was issued last year. Since then, the IBM i open source community has been busy building many of the other middleware components that will make it easier for developers to build IBM i applications using Microsoft tooling.

  Mono was ported to AIX and IBM i (via the PASE AIX runtime) last year, which gave IBM i and AIX shops the capability to run the open source .NET runtime on Power Systems servers, thus opening the door to allowing Microsoft‘s highly regarded suite of development tools to be …

  Read more

• Guru: Change XML Elements in SQL

  February 18, 2019 Paul Tuohy

  Over the last few years, it has become more common to store XML or JSON in a column in a table. Whereas SQL provides all the necessary functions to construct/deconstruct XML or JSON from/to relational data, it does not provide an easy means to change the contents of an element. In this article, I am going to demonstrate a technique for changing the contents of an XML element using an SQL stored procedure.

  Just to provide some background, I was recently working on a project where DB2 XML Extender functionality was being replaced with the standard XML functions. The project …

  Read more

• Taking A Fresche Approach To IBM i-Watson Education

  February 4, 2019 Alex Woodie

  There is a big data analytics revolution taking place that threatens to separate the AI haves from the have-nots. Companies that run the IBM i server want to get in on the analytics action just like everybody else, but AI discussions often stray away from IBM i. Now Fresche Solutions is working to close that disconnect with a series of educational courses centered squarely on the intersection of IBM i and Watson.

  Last year, Fresche Solutions worked with IBM last year to put together a series of onsite training seminars aimed at giving IBM i professionals the educational tools they …

  Read more

• Scaling Up For Cyber Monday With IBM i

  November 26, 2018 Alex Woodie

  A fulfillment company that’s expected to process millions of transactions on an IBM i server today will lean heavily on a slim layer of RPG-based Web services technology to keep the commerce flowing for its large clients. But there’s nothing stopping the middleware, dubbed iWebSrv, from simplifying data integration for clients in other industries.

  Retailers work all year to ensure they’re ready for the massive surge of traffic that springs up after Thanksgiving. For bricks-and-mortar types, Black Friday is their make-or-break day, while those with an omni-channel bent have Cyber Monday prominently circled on their calendars.

  Consumers are expected to …

  Read more

• Break Out Of Your RPG Comfort Zone

  October 29, 2018 Amanda Blackburn

  (Sponsored Content) IBM i developers, like all developers, can get stuck in a rut sometimes. The well-worn path that RPG provides is familiar and reassuring, but it doesn’t necessarily lead your company where it needs to go. That’s why exploring newer IBM i language alternatives, like Node.js, can provide a fresh path towards the goal of business innovation.

  The rapid ascent of the Node.js programming language over the past five years has been well-documented. While Java remains a popular business language, Node.js is now the world’s most popular development framework in all of computing, according to the 2018 …

  Read more

• PASE Versus ILE: Which Is Best For Open Source?

  October 22, 2018 Alex Woodie

  Open source has emerged as a driver of innovation in the past 20 years, and has greatly accelerated technological innovation. The proprietary IBM i platform has also benefited from this trend, thanks in large part to the capability to run Linux applications in the PASE runtime. But some members of the IBM i community are concerned that the fruits of the open source innovation have not tasted quite as sweet as they do on other platforms.

  Linux was the original breakout star in open source software, and so it should be no surprise that the vast majority of software developed …

  Read more

• New Open Source ERP Suite Written In ILE RPG

  October 15, 2018 Alex Woodie

  There’s something quite novel being introduced today at the Fall COMMON conference in Pittsburgh: An open source ERP package written in free-form RPG. Dubbed intERPprise, the software project is intended to harness core IBM i strengths – its integrated database and ILE environment – but above all, provide an example for what modern and native open source software can look like on IBM i.

  The intERPrise project (www.i-nterprise.org) was spearheaded by a group of IBM i advocates, including Chris Hird and Marinus van Sandwyk, who wanted to demonstrate what a modern business application would look like – and …

  Read more

• Infor Elaborates on Coleman, IBM i Strategy

  October 10, 2018 Alex Woodie

  When Infor held its annual Inforum conference two weeks ago, the new AI bot Coleman played a big part, but nary an IBM i word was muttered publically. But that shouldn’t come as a concern to the thousands of companies that rely on the company’s IBM i software to run their businesses, Infor’s IBM i strategy Ross Freeman leader says.

  “We heard the same from Syteline customers. They didn’t hear much about Syteline,” says Freeman, who heads up IBM i strategy for the LX, XA, and System 21 ERP product lines. “We have 235 products and we’re all following the …

  Read more

Previous Articles