Re: [IBMiOSS] CSV file in the IFS, writing it to a DB2 file using Python

FWIW, if the job is already running as the desired user, you should be able to get by with this:
conn = db2.connect()



-----Original Message-----
From: Mike Loyd [mailto:mloyd@xxxxxxx]
Sent: Thursday, June 27, 2019 11:46 AM
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxxxxxxxx>
Subject: Re: [IBMiOSS] CSV file in the IFS, writing it to a DB2 file using Python

Hi there
I am trying to connect to DB2 in python using the following -

import ibm_db_dbi as db2
sys_nam = "*LOCAL"
user = "USER"
password = "PASSWORD"
conn = db2.connect(sys_nam,user,password)

I am receiving this error when running the script -
ValueError: not enough values to unpack (expected 2, got 1)

I have tried looking online and nothing is working.
Any thoughts?