Re: Logical Unit of Work

marchey@interval-intl.com wrote: > > I have a question related to a Windows based development product. > > We are developing a product on Windows95, using ANSI C++, running against an > Informix Online 7.2 database. We have developed a 3 tier architecture, although > our business layer currently runs on the client. > > My question is this: how can I handle nested logical units of work? > * I initiate a LUW process (update contract) > * I decide to update a person's address in the context of this action. > * I want the address update to be persistant regardless of the outcome of the > contract transaction. > * The address LUW is nested within the contract LUW. > > Opinions? Advice? Hi, don't you think that parallel transactions are good enough ? I've never heard anything about nested transactions in Informix. But you can set up several transactions by opening several connections. CONNECT TO ... AS connect_name1 WITH CONCURRENT TRANSACTIONS; ... CONNECT TO ... AS connect_name2 WITH CONCURRENT TRANSACTIONS; There's a way to switch between the different transactions and this should be enough. Do you aggree ? Bye Stefan > Thanks in advance, > > Mary Archey > CCS International > marchey@ccsintl.com