Foundation Db2 and Python

Access Db2 with Module-Based API Examples Using Python

Authors: Ashley, David

Download source code Free Preview
  • Extensive coverage on how to access a Db2 data base from Python
  • Covers creating a small library for managing a Db2 data base
  • Covers how to avoid potential problems with the ibm_db module in future versions
see more benefits

Buy this book

eBook $39.99
price for USA
  • The eBook version of this title will be available soon
  • ISBN 978-1-4842-6942-8
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $54.99
price for USA
  • ISBN 978-1-4842-6941-1
  • Free shipping for individuals worldwide
  • Institutional customers should get in touch with their account manager
  • Covid-19 shipping restrictions
  • Usually ready to be dispatched within 3 to 5 business days, if in stock
About this book

Work with Db2 to write SQL and access databases using optimized code for the fastest response. This book will give you complete documentation on DB2 via Python for the IBM_db module and provide a number of examples for the usage of each module API.
Begin by getting your free version of Db2 for Linux and Windows. While the book concentrates more on the Linux version of Db2, it also covers enough of the Windows version so that you're comfortable with obtaining and installing Db2 on your version of Windows. Next, you'll see how to install the sample database that comes with Db2, and take some data from the web to design a database around it, including tables and indexes.
For Db2 to be really useful you need to use strong SQL expressions. This book provides specific examples of how to avoid using poor ones that can cause extra processing time for the query. Lastly, you'll look at each API in the ibm_db and ibm_db_dbi module. This module is not sponsored by IBM and must be installed separately from the Db2 database.
After reading Foundation Db2 and Python you'll be able to install Db2 on Windows or Linux, and perform backups and restore data. 
What You'll Learn

  • Obtain and install Db2 properly on Linux and Windows
  • Create databases and load them on Db2
  • Work with ibm_db and ibm_db_dbi API modules for Python
  • Write SQL for Db2
  • Review the future of the ibm_db Python module 
Who This Book Is For
Python programmers and DB2 administrators interested in building application with Python and DB2

About the authors

W. David Ashley is a technical writer for SkillSoft where he specializes in open source, particularly Linux. As a member of the Linux Fedora documentation team he recently led the Libvert project documentation, and wrote the Python programs included with it. He has developed in 20 different programming languages during his 30 years as a software developer and IT consultant, including more than 18 years at IBM and 12 years with American Airlines.

Table of contents (8 chapters)

Table of contents (8 chapters)

Buy this book

eBook $39.99
price for USA
  • The eBook version of this title will be available soon
  • ISBN 978-1-4842-6942-8
  • Digitally watermarked, DRM-free
  • Included format: EPUB, PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $54.99
price for USA
  • ISBN 978-1-4842-6941-1
  • Free shipping for individuals worldwide
  • Institutional customers should get in touch with their account manager
  • Covid-19 shipping restrictions
  • Usually ready to be dispatched within 3 to 5 business days, if in stock

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Foundation Db2 and Python
Book Subtitle
Access Db2 with Module-Based API Examples Using Python
Authors
Copyright
2021
Publisher
Apress
Copyright Holder
W. David Ashley
eBook ISBN
978-1-4842-6942-8
DOI
10.1007/978-1-4842-6942-8
Softcover ISBN
978-1-4842-6941-1
Edition Number
1
Number of Pages
XV, 214
Number of Illustrations
11 b/w illustrations
Topics