21
Fri, Feb
1 New Articles
  1. You are here:  
  2. Home
  3. Publications
  4. MC RPG Developer

April 15, 2022

MC TNT Header dots fade with byline 2017 06 01 l r

Lead Article - Programming

Building Python Applications That Work with Db2, Part 3

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…

Featured White Paper

2022 IBM i Marketplace Survey Results

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.

White Paper Download

   Profound Logic

 

More than ever, there is a demand for IT to deliver innovation.

Your IBM i has been an essential part of your business operations for years. However, your organization may struggle to maintain the current system and implement new projects.

The thousands of customers we've worked with and surveyed state that expectations regarding the digital footprint and vision of the company are not aligned with the current IT environment.

Get your copy of this important guide today! Download your copy today!
Webcast Learning

   LANSA

  

Supply Chain is becoming increasingly complex and unpredictable. From raw materials for manufacturing to food supply chains, the journey from source to production to delivery to consumers is marred with inefficiencies, manual processes, shortages, recalls, counterfeits, and scandals.

In this webinar, we discuss how:

  • Low-Code facilitates the development of Supply Chain Collaborative Portals.
  • Value Chain integration enhances visibility, timeliness, and consistency.
  • New technologies help modernize and expand ERP and Legacy Platform support.

 

Watch Now.
Application Dev

Operating Systems

Database

Programming

Management & Career

System Administration

Featured News

Public and Private Sectors Must Collaborate in the New Cyber Era

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.

Upcoming Events
27 Jul, 2023

OCEAN TechCon23 - July 27 - 29, 2023

MC Press Bookstore

Support MC Press Online

$

Book Reviews

Resource Center

  •  

  • LANSA Business users want new applications now. Market and regulatory pressures require faster application updates and delivery into production. Your IBM i developers may be approaching retirement, and you see no sure way to fill their positions with experienced developers. In addition, you may be caught between maintaining your existing applications and the uncertainty of moving to something new.

  • The MC Resource Centers bring you the widest selection of white papers, trial software, and on-demand webcasts for you to choose from. >> Review the list of White Papers, Trial Software or On-Demand Webcast at the MC Press Resource Center. >> Add the items to yru Cart and complet he checkout process and submit

  • SB Profound WC 5536Join us for this hour-long webcast that will explore:

  • Fortra IT managers hoping to find new IBM i talent are discovering that the pool of experienced RPG programmers and operators or administrators with intimate knowledge of the operating system and the applications that run on it is small. This begs the question: How will you manage the platform that supports such a big part of your business? This guide offers strategies and software suggestions to help you plan IT staffing and resources and smooth the transition after your AS/400 talent retires. Read on to learn: