Re: [IBMiOSS] using ibm_db_dbi to block insert

Yeah just the connection.commit() right? Autocommit is off so I am issuing a commit on the open connection right after.

-----Original Message-----
From: OpenSource [mailto:opensource-bounces@xxxxxxxxxxxx] On Behalf Of Aaron Bartell
Sent: Tuesday, October 10, 2017 4:17 PM
To: IBMi Open Source Roundtable <opensource@xxxxxxxxxxxx>
Subject: Re: [IBMiOSS] using ibm_db_dbi to block insert

The e-mail below is from an external source. Please do not open attachments or click links from an unknown or suspicious origin.

Check to make sure you have it either auto committing or are issuing an SQL commit.

Aaron Bartell
IBM i hosting, starting at $157/month. litmis.com/spaces


On Tue, Oct 10, 2017 at 4:13 PM, Jeremy Meyer <JMeyer@xxxxxxxxxxxxx> wrote:

We just got ibm_db_dbi installed and I have been trying it out. I have
no issue retrieving information but cannot seem to be able to insert.

Using cursor.executemany() I am trying to insert several rows. Table
is just a big list of tuples.

cur.executemany('insert into lib.table
(LIBNAME,LIBTYPE,TO_LVL,TO_ENV,LIBAPP,MST_OWNER)
values (?,?,?,?,?,?)',table)

Rough idea of what Table looks like.
<class 'list'>: [('LIBONE', 'DTA', Decimal('10'), 'SomeText', 'XXXX',
'NameasText '), ('LIBTWO', 'DTA', Decimal('10'), 'SomeText', 'XXXX',
'NameasText ')]

So it executes the statement like it is successful, but I never get
any data inserted into my table. I haven't found any examples anywhere
yet using ibm_db_dbi for inserting.
NOTICE: This electronic mail message and any files transmitted with it
are intended exclusively for the individual or entity to which it is
addressed. The message, together with any attachment, may contain
confidential and/or privileged information.
Any unauthorized review, use, printing, saving, copying, disclosure or
distribution is strictly prohibited. If you have received this message
in error, please immediately advise the sender by reply email and
delete all copies.
--
This is the IBMi Open Source Roundtable (OpenSource) mailing list To
post a message email: OpenSource@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
https://archive.midrange.com/opensource.

--
This is the IBMi Open Source Roundtable (OpenSource) mailing list To post a message email: OpenSource@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/opensource
or email: OpenSource-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/opensource.

NOTICE: This electronic mail message and any files transmitted with it are intended
exclusively for the individual or entity to which it is addressed. The message,
together with any attachment, may contain confidential and/or privileged information.
Any unauthorized review, use, printing, saving, copying, disclosure or distribution
is strictly prohibited. If you have received this message in error, please
immediately advise the sender by reply email and delete all copies.