Hi all,

When importing data through exchange, Baan seems to commit the transactions after multiple rows (which is good for performance).

Does someone know how to achieve a commit after each row inserted/updated?

I tried to use the stop condition of a batch line, but this is executed only once after all rows are processed...

When adding a commit in a condition for the last table field, this will be to early (insert/update not performed yet).

Any suggestion?

Thanks,
Frank

It seems to me there is a environment variable that can be set to determine when to commit a row. I will looks to see if I can find what they are.

See if this thread helps (http://www.baanboard.com/baanboard/showthread.php?t=8982).

I was thinking about these three variables ora_max_array_insert:1000,ora_max_array_fetch:1000,
ssts_set_rows:1000. I have no experience with using them. You might try some searching on them.

If your purpose is for an interface then I'd suggest reading the data into a interim table and then doing the insert/updates with a program script. It gives you much better control.

I solved this problem by adding a condition to the first field, where this condtion contains a commit.transaction(). This works fine.

Thanks for your replies,

Frank

Good to know ... well done.