Have you tried this:

conn = db2.connect()

My samples don't use any connection string when running on the i.

I only use connection strings if running off-box on Windows or Linux.

Richard Schoen
Web: http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
Phn: (612) 315-1745


message: 1
date: Thu, 27 Jun 2019 16:45:31 +0000
from: Mike Loyd <mloyd@xxxxxxx>
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.