Re: [IBMiOSS] using ibm_db_dbi to block insert

[Aaron Bartell <aaronbartell@xxxxxxxxx>]

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.