DB2 with python - Revision history

84.59.9.173: /* Install */

2020-11-10T11:21:55Z

Install

← Older revision		Revision as of 11:21, 10 November 2020
Line 11:		Line 11:

	sudo pip install ibm_db		sudo pip install ibm_db

			for this to succeed you need to have a db2 client installed (e.g. as instance owner) or set IBM_DB_HOME=/path/to/dsdriver.
			This path has include/sqlcli1.h and other needed files and is provided by a db2 odbc driver install, a db2 client install or a db2 server install.

	= Test Connection =		= Test Connection =

Joachim: /* Prerequisites */

2015-12-07T23:16:15Z

Prerequisites

← Older revision		Revision as of 23:16, 7 December 2015
Line 1:		Line 1:
	= Prerequisites =		= Prerequisites =

	I tested python3		I only tested python3

	* Python		* Python

Joachim: /* Prerequisites */

2015-12-07T23:11:30Z

Prerequisites

← Older revision		Revision as of 23:11, 7 December 2015
Line 1:		Line 1:
	= Prerequisites =		= Prerequisites =

			I tested python3

	* Python		* Python

Joachim: /* Example */

2015-12-07T23:09:26Z

Example

← Older revision		Revision as of 23:09, 7 December 2015
Line 26:		Line 26:
	import ibm_db_dbi		import ibm_db_dbi
	conni = ibm_db_dbi.Connection(conn)		conni = ibm_db_dbi.Connection(conn)

	conni.tables('SYSCAT', '%')		conni.tables('SYSCAT', '%')

	[{'TABLE_SCHEM': 'SYSCAT', 'REMARKS': None, 'TABLE_TYPE': 'VIEW', 'TABLE_NAME': 'ATTRIBUTES', 'TABLE_CAT': None}, ...]		[{'TABLE_SCHEM': 'SYSCAT', 'REMARKS': None, 'TABLE_TYPE': 'VIEW', 'TABLE_NAME': 'ATTRIBUTES', 'TABLE_CAT': None}, ...]

Joachim: Created page with "= Prerequisites = * Python * Python-dev? = Install = no client software required, just the python module ibm_db sudo pip install ibm_db = Test Connection = ibm_db can s..."

2015-12-07T23:07:55Z

Created page with "= Prerequisites = * Python * Python-dev? = Install = no client software required, just the python module ibm_db sudo pip install ibm_db = Test Connection = ibm_db can s..."

New page

= Prerequisites =

* Python
* Python-dev?

= Install =

no client software required, just the python module ibm_db

sudo pip install ibm_db

= Test Connection =

ibm_db can specify connections by
* referencing db2cli.ini database definitions
* referencing db2dsdriver.cfg definitions
* directly

= Example =

import ibm_db
# conn = ibm_db.connect('alias', 'user', 'pass')
conn_str = "DATABASE=mspr;HOSTNAME=job4;PORT=50002;PROTOCOL=TCPIP;UID=db2inst2;PWD=secret;"
conn = ibm_db.connect(conn_str, '', '')

import ibm_db_dbi
conni = ibm_db_dbi.Connection(conn)

conni.tables('SYSCAT', '%')

[{'TABLE_SCHEM': 'SYSCAT', 'REMARKS': None, 'TABLE_TYPE': 'VIEW', 'TABLE_NAME': 'ATTRIBUTES', 'TABLE_CAT': None}, ...]