Oninit cdi / Archive
Talk to an expert →

Re: 4GL application migration to work against SQL Server

Posted in 2006

Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion, Java & JDBC Development

Gil Lapid — — source: Usenet: comp.databases.informix

Thanks, So once I converted the 4GL to EGL I can make my application work against SQL Server instead of Informix? Jean Georges Perrin wrote: > I do not think Art in Soft a concrete success story about it. > > If you'd like to go the Java way, I would consider IBM Rational EGL. EGL is > a 4th generation language, similar to 4GL which generates Java and relies on > Java technologies, like JDBC for accessing the DB. IBM provides a code > converter from i4GL to EGL, which is told to convert about 95% of the code. > They provide a nice document for I4GL migration, where they list pitfalls, > etc. > > Then you become a bit more independent and can easily turn your EGL business > logic into Web Services for SOA, Web apps, etc. > > EGL is not super-intuitive now but you start to find quite a few good > documents about it. > > > -----Original Message----- > > From: informix-list-bounces@iiug.org [mailto:informix-list- > > bounces@iiug.org] On Behalf Of Gil Lapid > > Sent: Wednesday, September 27, 2006 02:52 > > To: informix-list@iiug.org > > Subject: Re: 4GL application migration to work against SQL Server > > > > Does anyone have experience with artinsoft.com > > http://www.artinsoft.com/wp_newway.aspx > > They say they move 4GL to Java > > > > > > ifxmaillist@quanta.co.nz wrote: > > > There are a number that will run your 4GL code. Genero www.4js.com > > for > > > example > > > > > > > > > -----Original Message----- > > > From: informix-list-bounces@iiug.org [mailto:informix-list- > > bounces@iiug.org] > > > On Behalf Of Gil Lapid > > > Sent: Wednesday, 27 September 2006 11:06 a.m. > > > To: informix-list@iiug.org > > > Subject: 4GL application migration to work against SQL Server > > > > > > Hi, > > > > > > Could anyone provide any guid what is the most practical way to migrate > > > 4gl application running against IDS so that it run against SQL Server ? > > > > > > Even if you do a total rewrite is there any way to use some of the > > > existing logic ? > > > > > > Thanks, > > > > > > Gil > > > > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-list@iiug.org > > > http://www.iiug.org/mailman/listinfo/informix-list > > > > _______________________________________________ > > Informix-list mailing list > > Informix-list@iiug.org > > http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to Gil Lapid
Mike Aubury — — source: Usenet: comp.databases.informix

Will EGL do the required SQL conversions too ? On Wednesday 27 September 2006 22:16, Gil Lapid wrote: > Thanks, > > So once I converted the 4GL to EGL I can make my application work > against > SQL Server instead of Informix? > -- Mike Aubury

↪ replying to Gil Lapid
tc — — source: Usenet: comp.databases.informix

The Best Solution is GENERO from www.4js.com. It is a superset of Informix 4GL. Same Syntax. Only Interface section changes, some extra lines to .per and few advancements to the Ring Menu. Once compiled can deploy in any plaform... Gil Lapid wrote: > Thanks, > > So once I converted the 4GL to EGL I can make my application work > against > SQL Server instead of Informix? > > > Jean Georges Perrin wrote: > > I do not think Art in Soft a concrete success story about it. > > > > If you'd like to go the Java way, I would consider IBM Rational EGL. EGL is > > a 4th generation language, similar to 4GL which generates Java and relies on > > Java technologies, like JDBC for accessing the DB. IBM provides a code > > converter from i4GL to EGL, which is told to convert about 95% of the code. > > They provide a nice document for I4GL migration, where they list pitfalls, > > etc. > > > > Then you become a bit more independent and can easily turn your EGL business > > logic into Web Services for SOA, Web apps, etc. > > > > EGL is not super-intuitive now but you start to find quite a few good > > documents about it. > > > > > -----Original Message----- > > > From: informix-list-bounces@iiug.org [mailto:informix-list- > > > bounces@iiug.org] On Behalf Of Gil Lapid > > > Sent: Wednesday, September 27, 2006 02:52 > > > To: informix-list@iiug.org > > > Subject: Re: 4GL application migration to work against SQL Server > > > > > > Does anyone have experience with artinsoft.com > > > http://www.artinsoft.com/wp_newway.aspx > > > They say they move 4GL to Java > > > > > > > > > ifxmaillist@quanta.co.nz wrote: > > > > There are a number that will run your 4GL code. Genero www.4js.com > > > for > > > > example > > > > > > > > > > > > -----Original Message----- > > > > From: informix-list-bounces@iiug.org [mailto:informix-list- > > > bounces@iiug.org] > > > > On Behalf Of Gil Lapid > > > > Sent: Wednesday, 27 September 2006 11:06 a.m. > > > > To: informix-list@iiug.org > > > > Subject: 4GL application migration to work against SQL Server > > > > > > > > Hi, > > > > > > > > Could anyone provide any guid what is the most practical way to migrate > > > > 4gl application running against IDS so that it run against SQL Server ? > > > > > > > > Even if you do a total rewrite is there any way to use some of the > > > > existing logic ? > > > > > > > > Thanks, > > > > > > > > Gil > > > > > > > > _______________________________________________ > > > > Informix-list mailing list > > > > Informix-list@iiug.org > > > > http://www.iiug.org/mailman/listinfo/informix-list > > > > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-list@iiug.org > > > http://www.iiug.org/mailman/listinfo/informix-list

Glossary