Re: error 256

On Wed, Jul 29, 2009 at 06:20, Floyd Wellershaus<floyd@fwellers.com> wrote: > We are working with Oracle ODI to connect to our non-transaction logged > database. ODI wants to do begin work, commit etc... > > I know this is very highly unlikely, but thought I'd ask anyway. Is there > anyway to get Informix to ignore the the transaction syntax and not give the > 256 error ( other than turning logging on)? Probably not in practice. In theory, you could use I-Spy, have ODI connect to I-Spy, and have I-Spy filter out the transaction statements. However, doing that will probably mess up your database horribly - transactional code assumes that if it does a ROLLBACK, then the changes are undone; and unlogged database doesn't know that (doubly not if it does not see the ROLLBACK statement). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Mike Ditka - "If God had wanted man to play soccer, he wouldn't have given us arms." - http://www.brainyquote.com/quotes/authors/m/mike_ditka.html