QuickStart Guide to Db2 Development with Python

by Roger E. Sanders

Overview

This book brings Python, SQL, and Db2 application development together as never before, to show how these three technologies can successfully be used with each other. By reading this book, you will receive:

• An introduction to Db2
• An overview of SQL and how it is used
• An introduction to Python and the Python libraries/drivers available for Db2 application development
• A step-by-step guide for setting up a Python-Db2 development environment (on RedHat or Ubuntu Linux)
• In-depth information on how to structure and build Python applications that interact with Db2 (along with the link to a GitHub site that contains over 70 sample programs and 60 Jupyter Notebooks)

Whether you're a Python developer who wants to build applications that work with Db2, or you're a Db2 user who wants to know how to build Python applications that interact with Db2 servers and databases, you'll find this book a must-read.

Product Details

ISBN-13:	9781583478882
Publisher:	MC Press, LLC
Publication date:	06/03/2019
Edition description:	None
Pages:	64
Product dimensions:	5.90(w) x 8.70(h) x 0.20(d)

About the Author

ROGER E. SANDERS is a Field Enablement Professional focused on Machine Learning on IBM Z Systems at IBM. He has worked with Db2 since it was first introduced and is the author of 25 books on relational database technology (six focused on application development), and many articles and tutorials on database topics. He lives in Fuquay Varina, North Carolina.

Table of Contents

1 What Is IBM Db2? 1

From the Mainframe to Distributed Platforms and the IBM Cloud 3

Db2 Today 3

2 Structured Query Language (SQL) 5

3 The Db2 Call Level Interface 9

4 Python and Db2 15

Installing the Python Interpreter 17

IBM Db2 Support for Python 18

5 Setting Up a Python-Db2 Development Environment 21

A Word About My Development Platform: the UDOO X86 22

Downloading the Db2 Software 23

Enabling root User Access (Ubuntu Linux Setup Only) 25

Preparing a Linux Server for Db2 Installation 25

Installing the Db2 Software 27

Building the SAMPLE Database 36

Installing the Db2 Python Library (Driver) 38

Summary 40

6 Building Python Applications That Work with Db2 41

Functionality Provided by the ibm_db and ibm_db_dbi Python Libraries 42

Special Objects Used by Db2-Python Applications 47

Establishing a Db2 Server or Database Connection 48

Transaction Processing: Executing SQL Statements 51

Transaction Processing: Retrieving Query Results 53

Transaction Processing: Obtaining Result Set Information 56

Transaction Processing: Terminating the Current Transaction 58

Calling Stored Procedures 60

Terminating a Db2 Server or Database Connection 61

Obtaining Information About a Data Source and Setting Driver Options 62

Diagnostics and Error Handling 63