Using Commit in DataStage

avidal18 · Post by **avidal18** » Fri Apr 21, 2006 3:33 pm

Hi, i'm trying to use the commit in a ODBC stage, because the quantity of records are very big and make me slow the server, and if by some reason the execution failed the rollback take a lot of time to do, what i'm tring to do is taking a numbers of records and make the commit, write another group of records and make the commit, can some one helpe me please.....thanks. :D

ray.wurlod · Post by **ray.wurlod** » Fri Apr 21, 2006 3:43 pm

Find the "rows per transaction" setting. This configures a value N which causes DataStage to issue a COMMIT request for each N rows that have been sent to the database server.

avidal18 · Post by **avidal18** » Fri Apr 21, 2006 3:55 pm

Thank you very much Ray, i find it.

Regards.

Angel.

chowmunyee · Post by **chowmunyee** » Sun Aug 13, 2006 10:01 pm

avidal18 wrote:Thank you very much Ray, i find it.

Regards.

Angel.

Is is avidal18's question is is called batch commit?