Re: Multiple Inserts - does block writing occur?

Kurt,

If memory serves, writing records to a table that has an index with unique
keys will never block records. That's my understanding from my RPG native
I/O experience. Not sure whether doing this via SQL changes this, but I
doubt it.

- Dan


On Wed, Apr 10, 2013 at 12:16 PM, Anderson, Kurt <KAnderson@xxxxxxxxxxxx>wrote:

Continuing down the SQL path...

If I execute 100 individual insert statements to a table (no commitment
control), does the system insert each record out individually, or does
blocked inserting occur?

A little background:
We receive files with all sorts of layouts, and we mediate them and output
them to our standard file. The mediation programs have a lot of
similarities, and I have moved most of those similarities into service
programs. However one thing they all still share is that each program is
writing to the standard file. I'd like to encapsulate that standard file.
In doing so, I'd like to use SQL to write the records, but I can't
sacrifice blocked writing due to the high volume of transactions.

I'm aware of inserting multiple rows in one statement using arrays,
however I don't want to attempt to control the number of records the system
should write out at once. In addition, there will already be an element of
complexity using arrays because one incoming record may result in more than
one standard record (so doing a blocked insert for that situation would be
fine).

I'm on IBM i 7.1.

Thanks,
Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems, a division of Enghouse Systems Ltd.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.