• Guru: Edit Result Sets in Run SQL Scripts

  October 7, 2019 Paul Tuohy

  Before getting into the detail in this article, I want it to be clear that I do NOT (in any way) advocate the direct editing of data in a production database. But when it comes to a test database, then the ability to directly edit data is invaluable.

  Back in the days of System i Navigator, you could right click on a table, select the Edit option and a window would open containing the contents of the table. You could directly edit the contents of any cell. Rows could be inserted or deleted using the Rows option on the menu. …

  Read more

• Power7 And Power7+ Will Truly Be Dead At The End Of 2020

  October 7, 2019 Timothy Prickett Morgan

  There are five dates that define the life of a piece of software and hardware: When it is announced, when it is generally available, when it is withdrawn from marketing, when service is withdrawn on the product, and when extended service (which is limited and which costs a lot more money than regular service) is dropped and the product is truly done for.

  With software, IBM sometimes provides service, service extension, extended service extension, and even extended-extended service extension. I am not making this up, and yes it sounds like the Monty Python SPAM skit. Take a look:

  As you …

  Read more

• Midrange Dynamics Dives Into REST With Acquisition

  October 2, 2019 Alex Woodie

  Change management specialist Midrange Dynamics this month announced that it has acquired Rest4i, the UK-based developer of a native IBM i framework for integrating RPG and SQL applications with REST-based APIs. The move positions Midrange Dynamics as a player in the rapidly evolving world of microservices.

  Rest4i was founded several years ago by Stuart Milligan, who headed up DB2 database modernization firm Databorough before selling it to Fresche Solutions (then Fresche Legacy) back in 2013. Milligan foresaw the coming wave of microservices and developed software to “turn the IBM i into a complete REST API server and the RPG developers …

  Read more

• Guru: MERGE, Chicken, And Eggs

  September 30, 2019 Ted Holt

  Which came first: the chicken or the egg? I don’t have time to ponder such trivialities. However, I am glad to know that SQL has a way to help me with chicken-and-egg database updates, i.e., when two statements need to run but each politely needs for the other to go first.

  Suppose you support an IBM i system that keeps up with inventory. It has an item master table (physical file) that stores general information such as a description, the standard cost, and the list price of an item.

  create table ItemMaster
    (ItemNumber     char(6),
     Revision       dec(3),
     Description    char(20),
     Cost           dec(5,2),
     

  …

  Read more

• PTC Completes Database Support In Implementer

  September 11, 2019 Alex Woodie

  As a change management tool, PTC’s Implementer is well-regarded among IBM i users for its ability to track development tasks and smooth out the promotion process. While the product has mostly been used to track source code in programming languages like RPG and Java, customers have increasingly been putting business logic into Db2 for i. With the recent launch of Implementer 12.3, PTC has wrapped up planned enhancements for the database.

  PTC‘s Implementer provides a full range of capabilities for managing development processes for IBM i shops. The software works closely with IBM‘s Rational Developer for i (RDi) …

  Read more

• Fresche Hires Database Modernization Expert

  September 11, 2019 Alex Woodie

  IBM i database modernization expert Birgitta Hauser has a new software house to call home following her hiring at Fresche Solutions. The new gig marks the start of a new era in the German’s 20-year career on the IBM i, and adds to Fresche’s growing arsenal of midrange talent.

  IBM i shops around the world are under pressure to either modernize their systems or migrate to something newer. While IBM i applications largely do what they were designed to do, the requirements have changed, and the siren call of digital transformation and big data analytics is too hard for …

  Read more

• Guru: Read a Data Area As a One-Row Table with SQL, Take Two

  August 26, 2019 Ted Holt

  Fifteen years ago, reader W.G. asked me about the possibility of treating a data area as a one-row table (a physical file with one record) in an SQL query. The question intrigued me because in my System/36 days, I had often wished that I could access the local data area (LDA) as a one-record data file in a query.

  Today, thanks to Scott Forstie and his team at IBM, I update my response to W.G. with more information. It’s not that the technique I presented in 2004 is outdated — it’s as relevant as ever — but that the fine …

  Read more

• Boutique Footwear Company Finds A Great Fit With Node.js

  August 19, 2019 Alex Woodie

  As one of the premier providers of winter footwear in North America and Europe, Kamik knows what it takes to run a successful manufacturing operation. But when its custom RPG-based ERP system started to show its age, the company turned to Node.js to help modernize production systems, and found that it improved application integration and developer productivity along the way.

  “Legacy” is a word that the folks at Kamik can take pride in. Founded in Quebec in 1898, Kamik remains a family owned business to this day, with factories located in Canada and the United States. Through its brand-name and …

  Read more

• Is Authority Collection The Right Thing For IBM i Security?

  August 12, 2019 Alex Woodie

  In the past two releases of IBM i, Big Blue has added new security capabilities in the form of the authority collection that allow administrators to see exactly what authorities users need to use their applications. While some welcome authority collection as helping to tighten the security of IBM i applications, others in the IBM i community wonder if the new information is helping at all.

  Authority collection debuted in 2016 with the launch of IBM i version 7.3. When the feature is activated, it monitors what authorities (such as ALLOBJ, SECADM, and so forth) are being called as users …

  Read more

• Cloud ERP for Less than $400 Per Month? Now There’s a Concept

  July 22, 2019 Alex Woodie

  What do you call a full-fledged ERP system running on a private IBM i cloud that costs less than $400 per month for three users? If you’re Software Concepts – the Massachusetts-based ERP vendor behind the bold new deal – you might call it just what the IBM i ecosystem needed.

  The IBM midrange server has always been something of an enigma in the IT business. Tucked between the giant mainframes running Fortune 100 outfits and the PCs favored by one-man shops, the AS/400 and its progeny have catered to midsized organizations that demand advanced business functionality, but not the …

  Read more

Previous Articles Next Articles