#!/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操作DB2数据库
标签:ase media failed ibm_db pwd delete 数据库 nec exce
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:http://www.cnblogs.com/fushou/p/7324842.html