Paul Tuohy

Guru: Content Assist Plus in Run SQL Scripts

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…

Guru: Getting Meaningful Audit Information from a Journal

Journaling is an invaluable tool that is used for data recovery, data replication, commitment control and, of course, auditing. But getting at the audit information in an easy-to-use manner can be cumbersome. In this article I want to introduce you…

Guru: Generate SQL for Dependents

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,…

Guru: Prompting Stored Procedures

In this tip I would like to touch on two items, in relation to stored procedures, that may have escaped your notice: prompting stored procedures and/or parameters (in Run SQL Scripts) and passing parameters by name. I must admit that, as I have…

iTalk With Kent Milligan

In this episode of iTalk With Tuohy, host Paul Tuohy talks with Kent Milligan from IBM Systems Lab Services. Paul Tuohy: Hi everybody and welcome to another iTalk with Tuohy. And I know I often say it's a delight to have a person with me on these,…

iTalk With Sarah Mackenzie

In this episode of iTalk With Tuohy, IBMer Sarah Mackenzie talks about the inner workings of IBM i development. Paul Tuohy: Hi everybody and welcome to another iTalk with Tuohy. My guest today is another Fresh Face but this time it's not one the…

iTalk With Mike Pavlak

In this episode of iTalk With Tuohy, Mike Pavlak talks about the progress of open source on IBM i and some of the major game changers. Paul Tuohy: Hi everybody and welcome to another iTalk with Tuohy. My guest today is the right honorable Michael…

Guru: Overloading Subprocedures

The ability to overload subprocedures in RPG is something I had been waiting for a long, long time. IBM finally made it available through a Technology Refresh (7.4, TR1 or 7.3 TR7). If you are not familiar with the term, overloading (in RPG) is the…

Tom Huntington on the Latest IBM i Survey

In this episode of iTalk with Tuohy, host Paul Tuohy interviews Tom Huntington on the latest IBM i client survey. Paul Tuohy: Hi everybody and welcome to another iTalk with Tuohy. So I got to say it's that time of year again, and so my guest today is…

iTalk With Quinn Kramer

In this episode of iTalk With Tuohy, Paul talks with Quinn Kramer, a software engineer at IBM Rochester. Paul Tuohy: Hi everybody and welcome to another iTalk with Tuohy. So I'm joined today by yet another of the fresh young faces within IBM, another…

Guru: The Case for Mixed-Case Procedure Names

Using mixed case makes source code easier to read and easier to debug. I programmed in all upper case for many, many years, so I don’t recoil in horror when I see something in all uppercase. However, it’s a bit more difficult for developers who…

Guru: SUBSET on EXECUTE and OPEN

The DB2 for i Enhancements in IBM i 7.3 Technology Refresh 8 / IBM i 7.4 Technology Refresh 2 just made dynamic SQL, embedded in RPG, a lot easier to use. It includes an enhancement entitled USING SUBSET on EXECUTE and OPEN with Extended indicators.…

Alison Butterill on Solutions Edition, the Latest TR and More

In this episode of iTalk With Tuohy, IBM i Offering Manager Alison Butterill talks with host Paul Tuohy about the IBM i Solutions Edition, what was included in the latest Technology Refresh and more. Paul Tuohy: Hi everybody and welcome to another…

IBMer Scott Forstie on TR Database Enhancements

In this episode of iTalk With Tuohy, host Paul Tuohy and IBM Business Architect Scott Forstie discuss IBM i enhancements and more. Paul Tuohy:Hi everybody and welcome to another iTalk with Tuohy. Just strange it's been just over a year since I last…

Brandon Pederson Talks IBM i Product Marketing

In this episode of iTalk With Tuohy, Brandon Pederson talks about golf, the IBM Champions program, marketing IBM i and more. Show Notes: Since the recording of this podcast, IBM Think has become a digital-first event. Register for free here. Connect…

Guru Classic: Tuning SQL Environments On i

Author’s Note: This article was originally published in November 2015. This was one of the first DB2 for i Services that I used in anger. I have used a lot since. One of the frustrating things about being a speaker at conferences is that when you…

Guru: Using Identity Columns For Complex Keys

In September 2019, Ted Holt published an article that demonstrated how an identity column can be used to generate a unique key in a table. In this article, I want to expand on that theme and examine another use of an identity column — replacing…

Steve Will on Cloud, Cognitive and More

On this episode of iTalk With Tuohy, host Paul Tuohy interviews IBM i Chief Architect Steve Will on cloud, cognitive, development cycles and more. Paul Tuohy:Hi everybody and welcome to another iTalk with Tuohy. So it just struck me when I was…

Guru Classic: Find a View of a View of a View. . .

Author’s Note: This article was originally published in October 2014. This stored procedure is something I use a lot and has saved me from accidentally deleting dependent views more than once. Basically, I call it before I ever drop a view. SQLs Data…

Paul Tuohy Reviews 2019

The host of the iTalk With Tuohy podcast recaps 2019 events in the IBM i world. Paul Tuohy:Hi everyone and welcome to another iTalk with Tuohy. Well it's that time of year again when I get to talk to myself and take the opportunity to look back at…