Re: DIFFERENCES BETWEEN INFORMIX-SE/INFORMIX-ONLINE

At 04:53 PM 9/12/96 +0200, you wrote: >Hi Hi Hi to everybody !!!!! >I'm Erika from Florence .... >What happen if i try to migrate a procedure using informix on line to >informix se ?????? >What are the differences between se/online database ? >Is INFORMIX-SE a transactional database ? > >Please, help me and answer me !!!!! > >Bye Bye > Hi Erika, INFORMIX-SE is an engine that doesn't need the administration required by OnLine. The SE engine supports transactions if you specify it when creating the database or with the instruction start database <xx> with log in <path>, however it is not fault tolerance ( Fast Recovery, physical log, logical log and all that kind of things ). Depending on the version, INFORMIX-SE supports triggers,store procedures,referential integrity. But will not take all the advantages from the Hardware and OS that INFORMIX-OnLine supplies. Q. Does your stored procedures update from two diferent databases and execute the Two-Phase commit transparently ? A. INFORMIX-SE does not support two-phase commit, you will have to manage it in other way. Q. Do they check something from the SMI database ? A. Why ? , INFORMIX-SE doesn't have SMI database, it administrates the database as a directory with .dat and idx files, altough there are system tables like systables, sysconstraints ... Q. Do they execute any sql-statement referencing the server,database and table? A. You will have to change it to the sintax supported by INFORMIX-SE. Anyway, if you want to know a more extensive answer, Point your browser to http://www.iiug.org/ and click your mouse on this message: Technical Information and FAQ Technical publications such as books and articles, and the ever popular Informix Frequently Asked Questions (FAQ) Listing. then click on .. The Informix Technical FAQ Listing / Table of Contents The Informix Frequently Asked Questions Listing maintained by Kerry Sainsbury. I hope this help, -------------------------------------------- Mario Estrada Rosa (LESCO,S.A.) lesco@guate.net Phone (502) 3318116 Fax (502) 3348447 --------------------------------------------