• Guru: Content Assist Plus in Run SQL Scripts

  November 29, 2021 Paul Tuohy

  By now, you should be well aware that Run SQL Scripts provides content assist (promoting) for Select statements (see Guru: ACS 1.1.8.3 Content Assist Includes Prompt For SQL! ). But did you know that you can also use content assist for stored procedures, table functions and parameters? Let’s see how it works, using some of the Integrated File System (IFS) procedures and functions provided by IBM i Services.

  Prompting a Stored Procedure

  Open Run SQL Scripts, type in:

  call qsys2.
  

  Then press F4 (or Ctrl+Space). You will be presented with a list of all the stored procedures in the schema …

  Read more

• Security Threats, They Are a Changin’

  November 17, 2021 Alex Woodie

  Ransomware came into 2021 like a lion, but rather than going out like a lamb, it seemed to get bigger and meaner. Even IBM i shops, which so often are protected from the wider security storm, felt the panic and sense of helplessness of having their previous data held for ransom. But early indications are that the security threat we’re talking about this time next year may be entirely different.

  It’s tough to overestimate the impact that ransomware had on American businesses and other institutions through the course of the year. We had indications that something big was unfolding a …

  Read more

• Consider Modernizing Your Approach to IBM i Security, Too

  November 10, 2021 Alex Woodie

  Many IBM i users are facing the reality that they need to modernize their IBM i applications, especially those based on monolithic blocks of fixed-format RPG. But other aspects of the IBM i experience can use some renovating too, including how organizations manage their security settings. Luckily, in the last few Technology Refreshes to IBM i, IBM has provided a slew of new SQL-based services for doing just that.

  Traditionally on IBM i, administrators had two main approaches for viewing and changing security settings. They could view and control the settings directly using commands, often automated through CL programs. Or …

  Read more

• Guru: Abstract Data Types and RPG

  November 8, 2021 Ted Holt

  An abstract data type (ADT) is a type of data and a set of operations defined over that type of data. Using ADTs allows a programmer to work with data in terms of functionality rather than physical representation. The ADT is the basis of object-oriented programming. Does that mean that abstract data types don’t apply to procedural languages like RPG? Not at all. Quite the contrary.

  Before I show you how you can use abstract data types in RPG-based applications, let me further illustrate abstract data types with another, non-OO object — the user profile. The user profile is a …

  Read more

• Technical Debt: The Silent Killer

  October 27, 2021 Alex Woodie

  There’s a dangerous malady afflicting companies that rely on the IBM i server to run their business applications. Left undiagnosed and untreated, it can debilitate an IT shop, rendering it unable to take advantage of new opportunities and respond to challenges. It’s called technical debt, and you or an organization you know may be suffering from it as we speak.

  Technical debt is a concept that is credited to Ward Cunningham, the American programmer and the co-author of Manifesto for Agile Software Development. “If you develop a program for a long period of time by only adding features but …

  Read more

• The Mod Squad Comes Together to Modernize Old RPG

  October 6, 2021 Alex Woodie

  In the early 70s, a group of fictional social misfits joined up to solve crimes on the hit television series The Mod Squad. Now a group of real-life IBM i professionals of the same name are uniting to solve an equally pressing problem: modernizing old RPG code, including some that dates back to the 1970s.

  “You’ve heard of IBM‘s upward compatibility,” says Rich Ollari, an IBM i veteran who is one of the ringleaders of the new Mod Squad. “Code that ran back in the 80s, even the 70s, is still running today, and that’s what we’re fighting with. …

  Read more

• Hit A Fiduciary Home Run With A Backup, DR, Cybersecurity Triple Play

  October 4, 2021 Jim Kandrac

  The old adage that the only secure computer is one that is not networked to anything has never been more true; however, it is also irrelevant even if it is funny. No computer can exist in a vacuum and is only useful if it is connected to other machines – and potentially lots of other machines. The level of malicious activity out there on the networks of the world has never been higher, and you had better get used to the idea that the situation is going to get worse every year, and the IBM i platform is absolutely …

  Read more

• Db2 PTF Group Enhancements Target Web Services, Audit Journal

  October 4, 2021 Alex Woodie

  It is indisputable that the Db2 for i database is the beating heart of the IBM i platform. There were no earthshattering enhancements to this database in the latest batch of Technology Refreshes for IBM i 7.3 and 7.4 that IBM announced and shipped last month. But there were a few items worth mentioning that shipped in the Db2 PTF Group, including new HTTP commands for calling the database via REST and new SQL-based commands for querying the security audit journal.

  The top new Db2 for i feature arguably is the new set of functions for HTTP requests to consume …

  Read more

• Fresche Takes On New RPG Development And Modernization With X-Elevate

  September 27, 2021 Timothy Prickett Morgan

  Over the years, Fresche Solutions, the IBM i conglomerate that is focused on development of new applications as well as modernization of existing applications, their interfaces, and their databases, has acquired and built tools that help programmers create Java and PHP programs, or convert RPG applications to Java and PHP. But by its own admission, Fresche did not focus on new RPG application development or the kind of incremental programming that a lot of IBM i shops are doing to gradually modernize their applications, usually through the shift from fixed format RPG to the free form RPG that is similar …

  Read more

• Guru: Alternate SQL Row-Selection Criteria Revisited Revisited

  September 27, 2021 Ted Holt

  I am not a “do as I say and not as I do” kind of person. After I wrote the article Guru: Alternate SQL Row-Selection Criteria Revisited, I got serious about using dynamic SQL in my RPG programs instead of enabling and disabling logical expressions in the WHERE clause. I’m reliving the days when OPNQRYF was my best friend, trying to make apostrophes play nice with string concatenation.

  Overall, I’m happy with the change. When I have converted the switch-laden version to dynamic SQL, I have seen a noticeable performance improvement in some cases, and at least a slight …

  Read more

Previous Articles Next Articles