Application development with ibm

Connecting to an IBM database server in Python
Before you can run SQL statements to create, update, delete, or retrieve data, you must connect to a database. You can use the ibm_db API to connect to a database through either a cataloged or uncataloged connection. To improve performance, you can also create a persistent connection.

Executing SQL statements in Python
After connecting to a database, use functions available in the ibm_db API to prepare and execute SQL statements. The SQL statements can contain static text, XQuery expressions, or parameter markers that represent variable input.

Fetching rows or columns from result sets in Python
After executing a statement that returns one or more result sets, use one of the functions available in the ibm_db API to iterate through the returned rows.

Calling stored procedures in Python
To call a stored procedure from a Python application, use ibm_db.callproc function. The procedure that you call can include input parameters (IN), output parameters (OUT), and input and output parameters (INOUT).

Retrieving multiple result sets from a stored procedure in Python
When a single call to a stored procedure returns more than one result set, you can use the ibm_db.next_result function of the ibm_db API to retrieve the result sets.

Commit modes in Python applications
You can control how groups of SQL statements are committed by specifying a commit mode for a connection resource. The ibm_db API supports two commit modes: autocommit and manual commit.

Error-handling functions in Python
The ibm_db API provides error-handling functions to help you recover gracefully from the error situations.

Database metadata retrieval functions in Python
You can use functions in the ibm_db API to retrieve metadata for IBM databases.

Application development in Python with ibm_db