Re: Rollback transaction

You have to choose if your database will be ANSI compliant or not, regarding the transaction management you want to deal with. If you want an implicit COMMIT after each statement, choose a Non ANSI database and do not use transaction statements. Otherwise, you can manage transactions on each database type (BEGIN and COMMIT or ROLLBACK delimiter statements for no ANSI database, only COMMIT and ROLLBACK statement on ANSI database -> implicit transaction in this case). "Balasubramanian .M" wrote: > Dear all, > > I am using Informix 7.23. I could not able to rollback the transactions which are not commited. > Since INFORMIX is one of the RDBMS, rollback facility should be available Isn't it ? > > Is there any way that i can disable the rollback feature and commit the transaction with out explicity > giving 'COMMIT' ? May be because of that i could not able to rollback the transaction. > > Pl. reply me at the earliest. > > Rgds, > bala -- - ------------------------------------------------------------------ - - Arnaud ANDRIEUX tel direct : 02.99.12.52.22 - - Alliance Qualite Logiciel http://www.aql.fr - - GROUPE SILICOMP http://www.silicomp.fr - - Rue de la Chataigneraie - B.P. 127 - - 35513 CESSON SEVIGNE - FRANCE - - tel : (33) (0)2.99.12.50.00 fax : (33) (0)2.99.63.70.40 - - ------------------------------------------------------------------ -