Hi All,

I am uning loooping over the document list that have 10 documents that i have to insert in the DB .if i am using No transcation for each insert transaction will be commited or after inserting all document it will get inserted.
But if there is any connection problem occure between IS and Database and only 6 transactions inserted then all 6 will get commited or all 6 will be rolled back??

Note:Bacially my question is : Is No Transcation do rollback?

[FONT=PalatinoLinotype-Roman][SIZE=3][FONT=PalatinoLinotype-Roman][SIZE=3]

[/SIZE][/font][/SIZE][/FONT]

Here you can use Local_Transcation

flow code should be as below…

start transaction
sequence (exit on sucess)
sequence (exit on failure)
–insert service
–update service
–commit
sequence (exit on done)
–rollback

A No Transaction connection simply means that IS doesn’t manage the transaction. The DB does. So your calls will be auto-commit. Each call to the DB is committed as it happens. A later error will not rollback previous calls.