DSXchange

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

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

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

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

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