Authors:
- 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
Buy it now
Buying options
Tax calculation will be finalised at checkout
Other ways to access
This is a preview of subscription content, log in via an institution to check for access.
Table of contents (8 chapters)
-
Front Matter
-
Back Matter
About this book
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
Python programmers and DB2 administrators interested in building application with Python and DB2
Authors and Affiliations
-
Austin, USA
W. David Ashley
About the author
Bibliographic Information
Book Title: Foundation Db2 and Python
Book Subtitle: Access Db2 with Module-Based API Examples Using Python
Authors: W. David Ashley
DOI: https://doi.org/10.1007/978-1-4842-6942-8
Publisher: Apress Berkeley, CA
eBook Packages: Professional and Applied Computing, Apress Access Books, Professional and Applied Computing (R0)
Copyright Information: W. David Ashley 2021
Softcover ISBN: 978-1-4842-6941-1Published: 05 August 2021
eBook ISBN: 978-1-4842-6942-8Published: 04 August 2021
Edition Number: 1
Number of Pages: XV, 214
Number of Illustrations: 11 b/w illustrations
Topics: Python, Information Systems and Communication Service, Enterprise Architecture