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?

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.