Re: DIFFERENCES BETWEEN INFORMIX-SE/INFORMIX-ONLINE

> Hi Hi Hi to everybody !!!!! It must be all that Espresso... > I'm Erika from Florence .... Then how come your e-mail address is Umberto? :-) > What happen if i try to migrate a procedure using informix on line to > informix se ?????? I assume you want to move a database from OL to SE. The major differences are that in OL, you have control over read ISOLATION LEVELs, PAGE or ROW mode locking and you have greater control over how big and where your database is. You should (with a few caveats) be able to migrate successfully between OL and SE. But why do you want to? OL is a much better engine. > What are the differences between se/online database ? There are hundreds, but they're mostly hidden from the developer/user. Data is stored using the O/S with SE, and the O/S is largely bypassed with OL. This is why OL is much faster and more reliable. From a functionality viewpoint (from a developer's perspective), I reckon you should be able to migrate without much trouble. > Is INFORMIX-SE a transactional database ? SE does support transactions. YAMMV, IMHO and RTFM. HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | Billy Wheeler Junior Programmer / Director The West Solutions Group | +------------------------------------------------------------------------------+ | (E) billy@west.co.za (U) http://www.west.co.za/billy.html | +------------------------------------------------------------------------------+