Re: No Transactional -> Transactional

Rodrigo Prenafeta <rprenafe@me.dcc.uchile.cl> wrote in article <55nv73$9vk@dcc.uchile.cl>... > Is it possible to change my actual database to transactional one? > > I have a database in Informix 7.1, using a lot of programs in > ACUCobol and SQLWindows (Gupta) in client/server architechture. > > The programs doesn't use the commit instructions, so > if i change the database to transactional i get errors (-244) > telling me that the table is locked. > > Any help? > (the idea is not change any old program code) If you mean that you want to change an unlogged database into a logged database and not make any program code changes, then using SQLWindows you have a problem. I had to change an unlogged database into a logged one where the client PCs were running SQLWindows. The main problem seems to be that SQLWindows issues a -begin work- but relies on you to do the -commit- We had to insert very many commits into our Gupta code to get the thing to work. However, it is possible to do, and, provided that the Gupta code is understood, should not be to great a problem.