ODBC access to Progress - transaction handling

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
beardo
Premium Member
Premium Member
Posts: 3
Joined: Wed Jun 27, 2007 2:19 am
Location: England

ODBC access to Progress - transaction handling

Post by beardo »

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
Dave Beardsley
Post Reply