Transaction Processing: Retrieving Query Results.  Read Part 1 here and Part 2 here.

By Roger Sanders

Editor's Note: This article is excerpted from chapter 6 of QuickStart Guide to Db2 Development with Python, by Roger Sanders.

When an SQL statement other than the SELECTstatement is executed, the only additional processing that might be performed is a check of the return code produced to verify the statement executed as expected. Or, a check to determine how many rows were affected by the operation. However, when a SELECTstatement (i.e., a query) is executed, any results that might have been produced will typically need to be retrieved and processed. With the ibm_db library, all the query results produced can be copied to a dictionary, tuple, or both (by calling the ibm_db.fetch_assoc(), ibm_db.fetch_tuple(), or ibm_db.fetch_both() API).Alternately,theibm_db.fetch_row()API can be used to advance the cursor to the next row (or move the cursor to a specific row) in a…

SURVEY HIGHLIGHTS

By HelpSystems

Editor's note: This article introduces the February 2022 Report: 2022 IBM i Marketplace Survey Results, which is available to download from the MC White Paper Center.

Cybersecurity continues to top the charts as the main concern when planning an IT environment.

Perhaps the most consistent data point in the IBM i Marketplace Survey Results is the ongoing cybersecurity threat. Over the past six years, cybersecurity has been the main concern for people planning their IT environment, and this year was no exception. Although it has decreased since last year’s results, 62% of respondents still said this was their number one concern. And although organizations prioritizing security seem to be implementing multiple solutions, it is still alarming that, on average, almost 30% of respondents do not plan to implement each of the surveyed cybersecurity solutions. If your organization has concerns over IBM i cybersecurity skills, managed security services could be a way of filling in any holes.

It was great to be back in person recently gathering with new and old colleagues at the Financial Services Information Sharing and Analysis Center (FS-ISAC) Spring Summit.

By Howard Boville | Head of IBM Hybrid Cloud Platform

After two long years, it was inspiring to connect with leaders in the financial services space and hear about their needs as they contend with the evolving threat landscape.