Re: Unify to Informix conversion

Jack Green (green@andrews.edu) wrote: : Does anyone have any experience converting from UNIFY RDBMS to : Informix? We are considering converting. We are on an IBM : RS/6000/580. Any suggestions? Thanks in advance. : -- : ********************************************************* : ** Drink deeply or not at all from the Pyrrhian spring, ** : ** a little bit of knowledge is a dangerous thing. ** : Alexander Pope ** Howdy, We did just that at the beginning of this year. It really depends on what tools you were using with Unify. The biggest pain for us was the (atleast for OnLine 5.01) the 18 character limit on identifiers (table names, fields etc.). Also, if you were using Accell, any queries in your .fs's need to have semi-colons at the end. Also, you will have fun if you have multiple SQL selects in a single file. Unify provides (with Accell for Informix) a shell script that partially emulates the Unify SQL command, but not too well. I made some changes to make it tolerable. Anyway, if you have any other questions, send me e-mail. I have used IDS through version 5 and u2000. Best of luck to you, Andrew Sawley