Re: Logical Unit of Work

In article <33422956.32529B69@www.weideneder.de>, Stefan Weideneder <stefan@www.weideneder.de> writes >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; > I have not come across this syntax - which version did it appear in? >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 -- David Williams