#!/usr/bin/env python
#-*-Coding:utf-8-*-
Import ibm_db
Try
conn = Ibm_db.connect ("database=seat; hostname=10.221.196.92; port=50000; Protocol=tcpip;\
Uid=seat_ca; PWD=SEATCA "," "," ")
Except
Print ("Connect failed,%s"% ibm_db.conn_errormsg ())
Else
sql = "SELECT * from Seat_ca." Tm_seat_condition WHERE airline = ' CA ' and ' \
"Tm_seat_condition. Flt_reg = ' B6822 ' and tm_seat_condition. Mark_for_delete= ' N ' "
Try
stmt = ibm_db.exec_immediate (conn, SQL)
Dictionary = ibm_db.fetch_both (stmt)
While Dictionary!=false:
For I in range (0, 15):
If I in (10, 12):
Print (Dictionary.get (i). Strftime ('%y-%m-%d%h:%m:%s ')),
Else
Print (Dictionary.get (i)),
Print ("\ n")
Dictionary = ibm_db.fetch_both (stmt)
Except
Print ("stmt failed,%s"% ibm_db.stmt_errormsg ())
Finally
If Ibm_db.active (conn):
Ibm_db.close (conn)
Print ("Database Close success!")
Python Operations DB2 database