ibm_db2_quickstart_create_table_insert_query_data.py

1import ibm_db
2
3# Replace the placeholder values with your actual database credentials
4dsn = (
5    "DRIVER={IBM DB2 ODBC DRIVER};"
6    "DATABASE=name;"
7    "HOSTNAME=host;"
8    "PORT=port;"
9    "PROTOCOL=TCPIP;"
10    "UID=username;"
11    "PWD=password;"
12    "SECURITY=SSL;"
13)
14
15try:
16    # Establish connection
17    conn = ibm_db.connect(dsn, "", "")
18    print("Connected to the database!")
19
20    # Create a table
21    create_table = "CREATE TABLE EMPLOYEE (ID INTEGER, NAME VARCHAR(20))"
22    stmt = ibm_db.exec_immediate(conn, create_table)
23
24    # Insert data
25    insert_sql = "INSERT INTO EMPLOYEE VALUES (1, 'John Doe')"
26    ibm_db.exec_immediate(conn, insert_sql)
27
28    # Query data
29    select_sql = "SELECT * FROM EMPLOYEE"
30    stmt = ibm_db.exec_immediate(conn, select_sql)
31
32    # Fetch and print results
33    result = ibm_db.fetch_both(stmt)
34    while result:
35        print(f"ID: {result[0]}, Name: {result[1]}")
36        result = ibm_db.fetch_both(stmt)
37
38    # Close connection
39    ibm_db.close(conn)
40    print("Connection closed.")
41
42except Exception as e:
43    print(f"Error: {e}")