• Guru: Generate SQL for Dependents

  May 24, 2021 Paul Tuohy

  Way back in October 2014, in the article Find A View Of A View Of A View. . ., I detailed a stored procedure that, given the name of a table or a view, provides the full list of dependent views and all of their dependents and all of their dependents, etc. This is a stored procedure that has served me well in the world of DDL, where it is common to have views of views of views.

  In this article I will describe a follow-on stored procedure that will generate the DDL for a given table/view and all …

  Read more

• Guru: Date Format Confusion

  May 10, 2021 Ted Holt

  Hey, Ted:

  I use the Copy to Import File (CPYTOIMPF) command to build a CSV file to be sent to a MySQL system. My colleagues are unable to import the file because of the format of a timestamp field. CPYTOIMPF puts a hyphen between the date and time (e.g. 2021-05-10-04.36.24.849555), but the other system wants a space between them. Other than writing a custom program do you know of another way to change the format of the timestamp output?

  — Richard

  You won’t need a custom program, Richard. There’s another way to handle this requirement.

  IBM has already very thoughtfully …

  Read more

• What’s New With BRMS, PowerHA, And Db2 Mirror

  April 28, 2021 Alex Woodie

  The latest IBM i Technology Refreshes (TRs) brought a number of enhancements to various parts of the operating system and related licensed products. That includes new stuff for its backup and recovery product, BRMS, as well as the two high availability offerings, PowerHA and Db2 Mirror.

  On the Backup and Recovery Media Services (BRMS) front, IBM added several new features with IBM i 7.4 TR4 and IBM i 7.3 TR10, including new SQL services that returns log information for BRMS activities. This new SQL service generates the same information that the Display Log for BRM (DSPLOGBRM) command does, but it …

  Read more

• Query Supervisor Gives Database Engineers New Power

  April 14, 2021 Alex Woodie

  One of the most exciting new features in the upcoming releases of IBM i 7.4 Technology Release (TR4) and 7.3 TR10 is the Query Supervisor. We recently caught up with Scott Forstie, IBM’s Db2 for i business architect, who gave us the low down on the new tech for controlling the database.

  Forstie told IT Jungle said that the Query Supervisor was the biggest new feature added to Db2 for i with IBM i 7.4 TR4 and 7.3 TR10, which IBM announced yesterday (see “IBM Unveils Spring 2021 Batch of TRs” for more news about the TRs).

  So, …

  Read more

• IBM Unveils New and Improved IBM i Services

  April 14, 2021 Alex Woodie

  If you like IBM i Services — those SQL-based methods for executing a range of tasks in the operating system — then you’re in luck, because IBM has included a handful of new and improved IBM i Services in the Technology Refreshes (TRs) for IBM i 7.4 and 7.3, which were unveiled yesterday and ship this Friday.

  IBM has developed an affinity for IBM i Services in the last few releases of the operating system. And why not? Users seem to like having a SQL-based alternative to CL commands and APIs. And since the IBM i Services are so easily …

  Read more

• IBM i PTF Guide, Volume 23, Number 14

  April 12, 2021 Doug Bidwell

  Apologies to all in the IBM i community for being late for putting together the IBM i PTF Guide last week. Sometimes real life interferes with business life, as you all know well. So this is a catch up issue of the Guide, with everything back on track with an update to get current coming out in this Wednesday’s issue of The Four Hundred.

  Editor’s Note: It goes without saying that we all owe a big hearty thanks to Doug Bidwell for his tireless efforts over many decades in keeping track of the patches for the firmware, operating …

  Read more

• Guru: Web Services, DATA-INTO and DATA-GEN, Part 1

  April 5, 2021 Jon Paris

  Many of the “Can you help me with. . . ” communications that cross my desk these days include reference to JSON. Sometimes the questioner is receiving JSON in a file, or has to retrieve it from a web service, or needs to generate JSON in response to a query. While there are many ways to handle these requirements, RPG’s built-in DATA-INTO and DATA-GEN can do a lot of the heavy lifting for you and are quite simple once you understand the basics.

  In this series of tips, I am going to start with a basic example that uses both …

  Read more

• Controlling IBM i Access With Exit Points

  March 29, 2021 Bill Hammond

  Today, the job of managing security on IBM i can be complicated, requiring dynamic technologies and processes that can respond quickly to ever-evolving threats and new regulations. Ransomware and other malware can, and has, infected IBM i systems and effective access control is a major weapon in the battle to secure your IBM i. There are many different approaches and technologies you can use to keep your IBM i secure.

  Using the exit points provided by the IBM i operating system can be a powerful tool to monitor and secure four important levels of access within the IBM i:

  • Networks

  …

  Read more

• Guru: SELECT INTO And Arrays

  March 8, 2021 Ted Holt

  I got egg on my face again. I told a couple of colleagues that they could use the SELECT INTO statement to load multiple rows into an array data structure in an RPG program. Boy, was I wrong! I had confused SELECT INTO with the FETCH statement, of course, which retrieves data over which a cursor has been declared.

  But the matter continued to nag me. I much like the simplicity of SELECT INTO. There’s no cursor to declare, open, fetch from and close, the same reason I like the FOR loop in SQL PL. It seemed (and continues …

  Read more

• iTech Solutions Keeps You In The Know With VERIFi

  February 22, 2021 Alex Woodie

  “An ounce of prevention is worth a pound of cure.” That time-tested bit of advice from Ben Franklin has many applications, including, it turns out, IBM i systems management. And through its new VERIFi offering, iTech Solutions is set to provide many ounces of prevention by keeping customers on top of what is happening with their IBM i servers.

  iTech Solutions’ VERIFi comes in three flavors. With VERIFi Weekly Status Reporting, the company remotely monitors key aspects of IBM i server health and summarize those findings in a PDF sent once a week for $295 per year. It offers …

  Read more

Previous Articles Next Articles