Re: Migrating from UNIX to Windows frontend for Informix DB
Posted in 1996
Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion
At 11:48 AM 5/5/96 +0100, Peter Miles wrote: >There are a couple of issues, however, which make this migration more >complicated. One thing is that some of the UNIX-based 4GL programs call >UNIX scripts and programs to carry out various file updates and other >functions. Now I understand that it may be possible to have these scripts >run by using the Stored Procedure feature available in Informix 7.1. Look at New Era - it's a bit pricier than some of the c/s tools, but it does support application partitioning which is a far safer way of running Unix stuff than an SP (IMHO)... plus you don't have to learn (much) new syntax. And we've seen you can do some pretty nifty stuff with it. There is also a (relatively) straightforward migration to NE from 4GL. >And are there any limits on what Stored Procedures can return to the calling >program? ie Does it have to return a table row, or can it return just a >string, a number, or even several variables? I think the limits are set by ODBC. >Lastly, can anyone recommend a Windows development environment for us to >use to quickly develop the forms, reports and 4GL programs to run under >Windows? I think I just did... >What are the advantages and disadvantages of Informix's Viewpoint? I dount it will have the flexibility you need. It's pretty much a graphical version of ISQL... HTH. Hasta la vista! -- billy.wheeler@pixie.co.za