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

On Thu, Jun 27, 2019 at 12:45 PM Mike Loyd <mloyd@xxxxxxx> wrote:

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)

It's helpful if you give more information than that. Ideally, you
should provide the entire traceback, but if that's really long, you
should at least give the last few lines. Crucially, they will reveal
which exact line of code triggered the error.

As it stands, I don't see any code that could have produced the error
that you're reporting.

Also, earlier you said you already have a script which gets data from
an Excel workbook into the database. How is *that* script connecting
to the database?

John Y.