Re: No Transactional -> Transactional

> 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) Nice try, but I don't think you're going to get away with it! :-) You will definitely need to add at least COMMIT WORK and ROLLBACK WORK to your code - then you can cheat with MODE ANSI, but frankly I'd rather go the whole hog and put in the BEGIN WORKs as well - then at least you can use buffered logging if you need to... -- Ciao, Billy NOTE: 1000's of programs for download at http://*&^*%!#+^|@$*)(?><"NO CARRIER