• A Closer Look At Enhancements To Integrated Web Services

  March 21, 2018 Dan Burger

  Technology Refresh 8 for IBM i 7.2 and TR4 for IBM i 7.3 became available last week. One of the enhancements in this TR pertains to the Integrated Web Services (IWS), which Business Architect for IBM i Application Development Tim Rowe calls IWS “one of our most widely used pieces of software from an integrated perspective.”

  Web services provide the capability to expose the database to outside developers via APIs and Web services. Although that thought brings a shiver down the spine of many developers who learned the proprietary ways of the AS/400, multi-platform integration is the modern development path. …

  Read more

• Guru: Use SQL To Find Duplicate Source Code

  March 12, 2018 Ted Holt

  According to Brian Tracy, “good habits are hard to develop but easy to live with; bad habits are easy to develop but hard to live with. The habits you have and the habits that have you will determine almost everything you achieve or fail to achieve.” This is as true in programming as in anything else we may do.

  Unfortunately, even those of us who strive for good work habits often have to follow the work of people who did not. One bad habit I come across occasionally is known in software engineering as WET solutions. WET stands for “write …

  Read more

• IT Jungle Readers Respond To Tech Refreshes

  February 28, 2018 Alex Woodie

  IBM took some people in the IBM i community by surprise when it unveiled the latest Technology Refreshes for IBM i 7.2 and 7.3 two weeks ago. Support for new Power9 servers obviously headlines the news, but several other notable new features are worth mentioning. We asked IT Jungle readers to chime in on the parts they liked best.

  Birgitta Hauser, a developer with Toolmaker Advanced Efficiency in Germany, says she likes the productivity enhancements that TRs bring, and the latest TRs are no different.

  “Because I’m at first an IBM i programmer, with the main focus on RPG and …

  Read more

• IBM i Database Capabilities Highlight Midrange Dynamics’ Development Activity

  February 28, 2018 Dan Burger

  Despite the gravitational pull of a legacy reputation, development on IBM i systems continue to move into new arenas. Shops are modernizing their applications not just to eliminate green-screen displays but to also add features and functionality. Databases are being modernized for the same reasons. And tools that benefit the modernization process are being enhanced.

  Change management software (CMS) is in the thick of this. Michael Morgan, managing director of the CMS development company Midrange Dynamics, sees IBM i shops investing in new technologies. He’s doing the same to keep pace with the early adopters and to prepare for …

  Read more

• Tooling Around With IBM i Access Client Solutions Announcements

  February 21, 2018 Dan Burger

  Access Client Solutions (ACS) received several feature/function enhancements when the Technology Refreshes were announced last week with a little something for end users, system administrators, and database engineers. Although nothing stands out as a major item, this is an incremental release fulfilling user-requested features.

  The 5250 emulator is a good example. It’s a key technology that is likely the most used component in ACS, but it’s been around for so long it’s easy to think there’s nothing new in emulation. But users never seem to cease to ask for something new: support for Chinese CCSID 1371 is one of those …

  Read more

• Guru: Combine Related Rows Using SQL

  February 12, 2018 Ted Holt

  A reader writes: “Hey, Ted. In our ERP system, certain business objects, such as sales orders and purchase orders, can have multiple comment records. Is it possible, using SQL, to combine all the comment records for an order into one long comment and retrieve it as a column in a result set?”

  I can relate to this. I can remember supporting an ERP system where not only the orders, but the order detail lines, could have such comments. End users depend heavily on such unstructured data to do their jobs. To answer your question, yes, it is possible and it …

  Read more

• Guru: Three Suboptimal I/O Practices

  February 5, 2018 Ted Holt

  I have on numerous occasions looked at source code that I had written in previous years and asked myself, “Why on earth did I do that? What could I have been thinking?” We live and learn, or at least we hope we learn. Today I share three database practices that I see from time to time that can be simplified. Maybe there’s something for you to learn today.

  Before I share the three examples, let me say that I do not consider the more cumbersome code to be wrong. To my way of thinking, any code that produces the correct …

  Read more

• Guru: An Update Conundrum Finally Solved!

  January 8, 2018 Ted Holt

  Russ writes, “Hey, Ted! I was trying to use a pure SQL solution to adjust some data today. My SQL statement worked fine in quality control, but failed in production. I’ve been wondering if the failure was caused by the database or by me! My problem was to renumber sequence numbers for a customer in a table.”

  Russ’s question arrived in my inbox on February 1, 2012. Yes, almost six years ago. At the time, I couldn’t help him. But with the latest technology refreshes from IBM, there is now a way to make the update work properly, and I’m …

  Read more

• Guru: Quirky SQL Creations

  December 11, 2017 Ted Holt

  Hey, Ted:

  We are creating a view from a source member using the Run SQL Statements (RUNSQLSTM) command. None of the objects are qualified in the source member. The system always creates the view in the wrong library, no matter how we set the current library. Can you tell me what is happening?

  –William

  William ran up against the quirky behavior of the SQL CREATE VIEW statement. It sure threw me for a loop. I would have thought that the view would be created in the current library. Not so. William found the answer to his question in the IBM …

  Read more

• VAI Covers All the Bases With Modernization

  December 6, 2017 Alex Woodie

  There are a lot of ways to “modernize” your IBM i application. You could create Web and mobile user interfaces. You could adopt free form RPG and migrate the database to modern SQL. You could host it all on the cloud. You could integrate analytic capabilities into it. Or, if you’re the IBM i ERP software vendor VAI, you could do all those things.

  VAI has, in fact, done all those things leading up to this year’s release of S2K Enterprise 6.0, and according to CEO and founder Bob Vormittag, the company is reaping big rewards as a result.

  “We’re …

  Read more

Previous Articles Next Articles