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
Rough idea of what Table looks like.
<class 'list'>: [('LIBONE', 'DTA', Decimal('10'), 'SomeText', 'XXXX',
'NameasText '), ('LIBTWO', 'DTA', Decimal('10'), 'SomeText', 'XXXX',
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,
or email: OpenSource-request@xxxxxxxxxxxx Before posting, please take
a moment to review the archives at
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.