• Guru: More Date And Time Conversions Using SQL

  March 26, 2018 Ted Holt

  Since many, if not most, IBM i shops store dates and times in numeric and character fields, it behooves those of us who program those systems to understand all available date- and time-conversion tools. A conversation with a fellow attendee of the recent RPG & DB2 Summit made me realize that I had not written about certain SQL conversion methods.

  IBM i programmers need to convert date, time, and timestamp data from one format to another for at least two reasons. First, we can’t do date and time arithmetic with numeric and character fields. Second, the people whom we serve …

  Read more

• TEMBO Bolsters Database Modernization Kit

  March 26, 2018 Alex Woodie

  TEMBO Technology Lab is shipping a new release of its software designed to help IBM i shops modernize their databases for the SQL age. The South African company made mostly minor tweaks to its flagship product, dubbed AO Foundation, which should position the product to do more down the road.

  Since it entered the IBM i discussion in 2012, TEMBO has been building database modernization tools and evangelizing the benefits of the SQL Query Engine (SQE) as the modern, up-to-date database engine that IBM i shops should strive to use, as opposed to the older CQE engine that used DDS …

  Read more

• 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

Previous Articles Next Articles