In my opinion... NO : Retrofitting TRANSACTIONs into existing programs would be a nightmare.
YES: Definitely use them when writing a new application from scratch and even a new sub-system enhancement if it is pretty much self-contained with limited, well-defined interfaces that write into the parent system. NO : I would caution against writing them into new programs that are enhancements to existing (sub-)systems. cds From: Les Hewkin > we had a batch process that processed lots of data and I mean > lots, but it didn't have any transaction boundaries. Someone > was asked to add them. So what did they do? yes you got it. > At the start of the routine they started a transactions and > at the end of the routine they ended the transactions. Guess > what? the lock table filled up and the whole thing fell over. > > The fun you have with transactions is endless :-) ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/