Re: Oracle-to-informix conversion

Path: emory!sol.ctr.columbia.edu!samsung!olivea!gossip.pyramid.com!pyramid!infmx!randall From: randall@informix.com (Randall Rhea) Newsgroups: comp.databases.informix Message-ID: <1992Jan29.020103.10293@informix.com> Date: 29 Jan 92 02:01:03 GMT Sender: news@informix.com (Usenet News) Organization: Informix Software, Inc. In article <1992Jan27.150229.5431@westech.uucp> writes: > >Topic: Converting from Oracle to Informix, what would change? > You are doing the right thing by converting to Informix. You will find that Informix tools are more flexible and practical than SQL*Forms. This will not be easy, though. Oracle's SQL contains a number of non-ANSI SQL extensions that are not included in Informix-SQL. For example, you will need to get rid of the concatination operator (|) and the DECODE function. Once you have edited the SQL statements, most of the Pro*C code should compile just fine under Informix ESQL/C. Your SQL*Forms applications will need to be re-written in Informix-4GL. You may want to use a 4GL code generator to save time. Informix now sells "Informix 4GL Forms", which is made by a company called Fourgen. Fourgen sells the product also. The look-and-feel of Oracle's SQL*Forms is different from Informix-4GL. I think that you will find it to be superior, though. I always had a hard time telling the user what "COMMIT" and "ROLLBACK" means. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Randall Rhea Informix Software, Inc. Project Manager, MIS Sales/Marketing Systems uunet!pyramid!infmx!randall -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Randall Rhea Informix Software, Inc. Project Manager, MIS Sales/Marketing Systems uunet!pyramid!infmx!randall