ODBC access to Progress - transaction handling

beardo · Post by **beardo** » Wed Oct 29, 2008 3:20 am

We are experiencing difficulties when reading large volumes from a Progress database using the ODBC stage. The select seems to be being handled by progress as a single transaction and causing issues with the progress database, when I looked on this forum people mentioned setting 'rows per transaction' and I was wondering where this is done.

transaction handling: rows per transaction: 0

chulett · Post by **chulett** » Wed Oct 29, 2008 7:03 am

So... do you need some help or is everything good?

ps. Please delete your duplicate post on this topic before someone replies to it.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 29, 2008 8:59 am

Rows per transaction is available when writing to the database, rather than when reading from it.

chulett · Post by **chulett** » Wed Oct 29, 2008 9:02 am

Ah... missed that little nugget of the direction involved.