언어 꿀Tip/Python 꿀tip!
07_01_48. DB2 연결하여 SQL로 데이터 산출
늉이늉이
2021. 6. 14. 10:16
import ibm_db_dbi
import pandas as pd
conn = ibm_db_dbi.connect("DRIVER={IBM DB2 ODBC DRIVER}; Database=데이터베이스; Hostname=host_ip; Port=port_number; PROTOCOL=TCPIP; UID=USER_ID; PWD=USER_비밀번호", "", "")
query = '''
쿼리 입력
'''
# Sql
df = pd.read_sql( query, conn)