March 11, 2022

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

Lead Article - Programming

Building Python Applications That Work with Db2, Part 2

Establishing a Db2 server or database connection and a look at transaction processing.  Read Part 1 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.

Establishing a Db2 Server or Database Connection

Before any type of operation can be performed against a Db2 server or database, a connection to that server or database must first be established. Python applications that use the ibm_db library can establish Db2 server and database connections by executing the ibm_db.connect() or the ibm_ db.pconnect() API. Python applications using the ibm_db_dbi library must execute the ibm_db_dbi.connect() API instead.

Featured White Paper

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.
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!
Application Dev

Operating Systems

Database

Programming

Management & Career

System Administration

Featured News

IBM Report: Manufacturing Felt Brunt of Cyberattacks in 2021 as Supply Chain Woes Grew

Other Findings: Asia Pacific Now Most Attacked Region; Average Lifespan of Ransomware Groups is 17 Months; Vishing Triples Phishing Click Rate

By IBM Corporation

IBM Security today released its annual X-Force Threat Intelligence Index unveiling how ransomware and vulnerability exploitations together were able to "imprison" businesses in 2021 further burdening global supply chains, with manufacturing emerging as the most targeted industry. While phishing was the most common cause of cyberattacks in general in the past year, IBM Security X-Force observed a 33% increase in attacks caused by vulnerability exploitation of unpatched software, a point of entry that ransomware actors relied on more than any other to carry out their attacks in 2021, representing the cause of 44% of ransomware attacks.

MC Press Bookstore
Upcoming Events

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: