• Let’s Try Converged Power Infrastructure One More Time

  April 8, 2019 Timothy Prickett Morgan

  Do you remember the Flex System modular servers launched seven years ago this month? These were the innovative machines that Big Blue sold off to Lenovo about two and a half years after they were launched and they were ramping? Do you remember the PurePower follow-ons to these that came out in May 2015? Or did we all just imagine that happened?

  These modular machines, which were somewhere halfway between a rack server and a blade server, were put into preconfigured stacks and as the PureFlex system had cloud automation software to create a private cloud and then had …

  Read more

• Attention Synon Users: You Can Automate Your Move To RPG Free Form And DevOps

  April 3, 2019 Philippe Magne

  (Sponsored Content) Depending on who you ask, there are about 1,000 IBM i shops that used the CA 2E (Synon) CASE tool to create their applications and are still using this tool to maintain those applications. This is not an easy task any more, and there is a much better way.

  After three years in development and very stringent testing with five early adopter Synon shops, ARCAD Software is rolling out what it calls Modernization as a Service, or MaaS for short, which seeks to completely automate the move from Synon generated code to modern RPG Free Form, …

  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

• LANSA Bought By Software Conglomerate Idera

  January 7, 2019 Alex Woodie

  LANSA, one of the oldest independent software vendors targeting the IBM midrange server and arguably one of the most successful, has been acquired by Idera, a growing conglomerate of software companies that also owns Sencha, and which is owned in part by the same private equity firm behind HelpSystems.

  LANSA was founded in 1987 by Australian businessmen Peter Draney and Lyndsey Cattermole to create and sell software development tools for the IBM System/38. When IBM launched the AS/400 a year later, LANSA supported it with its fourth generation language (4GL) development environment. It hasn’t looked back, and today the company, …

  Read more

• An IBM i Year In Review

  December 10, 2018 Alex Woodie

  Another year is just about wrapped up for us here at IT Jungle. That means it’s time to ease off the news pedal just a tad and enter into a retrospective mood, with the hope of gaining some perspective on where we’ve been in 2018 and perhaps how we’ll start off 2019.

  It all started off rather poorly, way back in. . .

  January

  . . . when the big news was about Spectre and Meltdown, the two vulnerabilities that brought everybody rudely back to the real world following the New Year’s celebration. Nearly all types of processors, including …

  Read more

• Guru: Addressing A Legitimate Question

  December 10, 2018 Ted Holt

  This is the last Monday issue of The Four Hundred for 2018. My, how time flies! I like to do something different at year end. In previous years I have solved Sudoku puzzles, found my way through mazes, solved the peg game, and more. This year I wish to honor a request that has come from various people and to address what they consider to be a legitimate question.

  As I wrote recently, the question I hear occasionally goes something like this: “Why bother with service programs? Why not use dynamic calls?” Rather than insult the …

  Read more

• IBM Delivers New Goodies with ACS Update

  December 5, 2018 Alex Woodie

  IBM has issued a new release of Access Client Solutions (ACS), the indispensable Java-based client that delivers a range of functionality to administrators, developers, and users alike. In the new release of ACS, IBM delivers enhancements across a range of functions, including SQL queries, database schemas, data transfer, and printing and emulation.

  IBM first unveiled ACS way back in August 2012 as the strategic replacement for older IBM i client interfaces, such as Access for Windows, Access for Web, and Access for Linux. With a full 5250 emulator, support for printing, the capability to view IFS, spool file, and message …

  Read more

• Guru: More About Merge

  November 5, 2018 Ted Holt

  I often read back through articles that have appeared in this august publication to look for errors and omissions. Such an expedition recently made me aware that I have not told you as much as I would like to about the SQL MERGE statement. Today I am pleased to provide more information.

  First I want to be sure that everybody understands is that you can add conditions to the WHEN MATCHED and WHEN NOT MATCHED expressions. That means that you do not have to treat all matched or unmatched rows in the same way. Look at this example:

  merge . 

  …

  Read more

• CM First Removes IBM i Requirement From ALM

  October 17, 2018 Alex Woodie

  Companies that are adopting the application lifecycle management (ALM) software from CM First no longer need an IBM i server, the company announced recently. The move with CM MatchPoint is intended to widen the deployment options for CM First’s targeted customer base, which is CA Plex and 2E users.

  CM MatchPoint is used to automate the development of CA Plex and CA 2E environments, particularly among large development teams that are geographically dispersed. The software manages several aspects of Plex and 2E development, from user-submitted change requests and workflow to version control and deployment.

  With the delivery of CM MatchPoint …

  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

Previous Articles