• IBM i Gets a New Crop of ‘Fresh Faces’

  June 12, 2019 Alex Woodie

  The IBM i platform isn’t getting any younger, and neither are the thousands of individuals who work on it. But that doesn’t mean that platform as a whole should be marked by gray. To celebrate the viability of the platform’s ability to attract young people, IBM System Magazine just introduced its newest crop of “Fresh Faces.”

  IBM System Magazine has been calling attention to the IBM i youth movement since 2016, when it debuted its original crop of Fresh Faces. Liam Allan was a member of that group as a teenager, and he has since gone on to build himself …

  Read more

• Speaking The SQL Lingua Franca On IBM i

  June 3, 2019 Timothy Prickett Morgan

  No matter what the job is, we all start out somewhere that is pretty far from being an expert and we depend on our elders and mentors to help us learn all the tricks and get good at the work.

  So it is with the nearly ubiquitous database query language, Structured Query Language, or SQL for short. It started out in the head of IBMer Ted Codd back in 1969, which was coincidentally when the System/3 minicomputer launched and its successor many generations later, the System/38 in 1978, was the first IBM system and the first system in the world …

  Read more

• IBM Bolsters ACS with Database and Administrative Goodies

  May 15, 2019 Alex Woodie

  Amid the many enhancements that IBM has delivered with IBM i 7.4 and IBM i 7.3 TR6 is a new release of Access Client Solutions (ACS), which has become the go-to client interface that many IBM i professionals use to access the system for a variety of tasks. Database engineers and system administrators are the big winners with this release.

  There’s no denying that IBM delivered a whopper of release with IBM i 7.4 and its sidekick, IBM i 7.3 TR6. There’s been so much news – starting with the availability and security enhancements in Db2 Mirror and Authority Collection …

  Read more

• Guru: Emulate Control Break Reporting With DB2 For i SQL

  May 13, 2019 Michael Sansoterra

  When generating ad hoc user reports, it’s often the case that developers don’t have the time or luxury to write a high-level language program or to use a reporting tool such as DB2 Web Query or Crystal Reports to format the data appropriately. But when a user is given a raw dump of a SELECT statement’s result set in Excel, it can be quite ugly to wade through and format.

  The user may have to do things like add total rows or remove duplicate values, which can be quite time consuming. Thankfully, DB2 for i SQL offers a way to …

  Read more

• Drilling Down Into Db2 Mirror for IBM i

  May 6, 2019 Timothy Prickett Morgan

  We did our initial coverage of the new Db2 Mirror for the IBM i operating system’s integrated database two weeks ago, and now it is time to dig in a little deeper. Elsewhere in this week’s issue of The Four Hundred, we have gotten feedback from the suppliers of high availability clustering and disaster recovery software for the IBM i platform as to how Db2 Mirror compete with as well as complements their wares. And in this story, we will be digging a little deeper into Db2 Mirror itself.

  As we explained, Db2 Mirror creates an active-active database …

  Read more

• How IBM i 7.4 Improves Security

  May 1, 2019 Alex Woodie

  The unveiling of Db2 Mirror may have gotten the lion’s share of attention with last week’s introduction of IBM i enhancements. But IBM has also given its customer base some significant security upgrades with the new releases of IBM i, including enhancements to the Authority Collection and support for the latest over-the-wire encryption protocol.

  “Our big things are around those two main themes – availability as well as security,” says Alison Butterill, IBM i product offering manager at IBM. “Those are the two main themes. But we have lots of things across the board.”

  IBM gave customers significant new user-focused …

  Read more

• Melding System Monitoring And Capacity Planning

  April 24, 2019 Timothy Prickett Morgan

  Installing a modern system to run enterprise applications is a pretty tough task, but the job is not done once the iron is in and the databases and applications are up and running. Sophisticated organizations, whether they are large or small, do sophisticated application and system monitoring to keep an eye on how things are running, they have job schedulers that synchronize work to optimize for performance as well as drive up system utilization, and they use all of the information gathered to better plan for the kinds of systems they will need in the future.

  There are many …

  Read more

• IBM i Announcements Loom, and So Does POWERUp 2019

  April 15, 2019 Alex Woodie

  By now you probably know that IBM is making its next round of IBM i announcements next Tuesday, April 23, via a COMMON webcast. But what you might not know is that COMMON has more than a dozen sessions about the yet-to-be-disclosed announcements planned for the upcoming POWERUp 2019 conference taking place next month at Disneyland.

  “Right now we’re looking at about 15 or 16 sessions about the announcement itself,” COMMON Executive Director Manzoor Siddiqui tells IT Jungle. “We’re going to be the first conference where people will have access to the knowledge and the content around that.”

  On …

  Read more

• Raz-Lee Reels In The File Editors

  April 10, 2019 Alex Woodie

  File editors can be great time-savers in certain situations. Who wouldn’t want developers to be able to quickly get into a database file, fix some errors, and then jump back out? Clearly, the answer is the security department. But thanks to a new solution from Raz-Lee Security called iSecurity Safe Update, file editors can be used without giving the security officer nightmares.

  File editors are among the most popular products on the IBM i platform, thanks to their capability to developers and administrators to make changes to data quickly and easily, without requiring programming. The IBM i operating system comes …

  Read more

• Guru: Dealing With RPG Errors and Embedded SQL

  April 8, 2019 Ted Holt

  Hey, Ted! I’m having trouble using some of the new techniques I learned at the RPG and DB2 Summit. Below is a screen shot of a program I am writing. I cannot figure out why the compiler doesn’t like it. Can you see anything that would be causing the declarations to fail?

  — Mike

  I glanced over Mike’s code and noticed that he used a correlation name in the SELECT and WHERE clauses, but did not define that correlation name for any of the tables, like this:

  SELECT x.onefield, x.twofield, x.redfield, x.bluefield
  FROM MYTABLE
  WHERE x.onefield = :TestValue;
  

  He …

  Read more

Previous Articles Next Articles