Foundation Db2 and Python: Access Db2 with Module-Based API Examples Using Python

Book Description

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

中文：

书名：基础DB2和Python：使用Python通过基于模块的API访问DB2示例

使用DB2编写SQL并使用优化代码访问数据库，以获得最快的响应速度。本书将为您提供有关通过Python实现ibm_db模块的完整的DB2文档，并提供大量使用每个模块API的示例。

首先，获取用于Linux和Windows的免费版本的DB2.虽然这本书更多地集中在Linux版的DB2上，但它也涵盖了足够多的Windows版本，这样您就可以轻松地在您的Windows版本上获得并安装DB2.接下来，您将了解如何安装随附的示例数据库，并从Web获取一些数据来设计一个围绕它的数据库，包括表和索引。

要使DB2真正有用，您需要使用强SQL表达式。本书提供了一些具体的示例，说明如何避免使用可能会导致查询额外处理时间的错误代码。最后，您将了解ibm_db和ibm_db_DBI模块中的每个API。该模块不是由IBM赞助的，必须与DB2数据库分开安装。

读完后。Foundation Db2 and Python您将能够在Windows或Linux上安装DB2，并执行备份和恢复数据。

你会学到什么？

• 获取并在Linux和Windows上正确安装DB2.
• 创建数据库并将其装载到DB2中
• 使用适用于Python的ibm_db和ibm_db_dbi API模块
• 为DB2编写SQL
• 回顾ibm_db Python模块的未来

这本书是为谁写的

对使用Python和DB2来构建应用程序感兴趣的Python程序员和DB2管理员