This repository contains Jupyter Notebooks and Python sample programs that illustrate how to use the APIs that are available in the ibm_db and ibm_db_dbi library with Db2. The list of APIs available with the ibm_db library are:
- ibm_db.active
- ibm_db.autocommit
- ibm_db.bind_param
- ibm_db.callproc
- ibm_db.client_info
- ibm_db.close
- ibm_db.column_privileges
- ibm_db.columns
- ibm_db.commit
- ibm_db.conn_error
- ibm_db.conn_errormsg
- ibm_db.connect
- ibm_db.createdb
- ibm_db.createdbNX
- ibm_db.cursor_type
- ibm_db.dropdb
- ibm_db.exec_immediate
- ibm_db.execute
- ibm_db.execute_many
- ibm_db.fetch_tuple
- ibm_db.fetch_assoc
- ibm_db.fetch_both
- ibm_db.fetch_row
- ibm_db.field_display_size
- ibm_db.field_name
- ibm_db.field_num
- ibm_db.field_precision
- ibm_db.field_scale
- ibm_db.field_type
- ibm_db.field_width
- ibm_db.foreign_keys
- ibm_db.free_result
- ibm_db.get_option
- ibm_db.next_result
- ibm_db.num_fields
- ibm_db.num_rows
- ibm_db.pconnect
- ibm_db.prepare
- ibm_db.primary_keys
- ibm_db.procedure_columns
- ibm_db.procedures
- ibm_db.recreatedb
- ibm_db.result
- ibm_db.rollback
- ibm_db.server_info
- ibm_db.set_option
- ibm_db.special_columns
- ibm_db.statistics
- ibm_db.stmt_error
- ibm_db.stmt_errormsg
- ibm_db.table_privileges
- ibm_db.tables
For information on how to use the APIs and functions in the ibm_db_dbi library, refer to the PEP 249 -- Python Database API Specification v2.0.