Re: Multiple Inserts - does block writing occur?

[Dan <dan27649@xxxxxxxxx>]

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.