RE: DON'T LAUGH! Help? Informix 2.10 to ? & SCO Xenix to Unix Sys V

gervasi@reston.unisysgsg.com John J. Gervasi writes: >I have been nursing an old copy of Informix 2.10.03k on SCO Xenix 2.3.2. >Yes, I was too cheap to upgrade but now I'm worried. The software I wrote >for my wife's business is still needed but I don't know a clear path to >upgrade to the lates Informix 4GL product for Unix Sys V. My first big assignment using Informix was making a conversion like the one above. Its been a while but... Use acego report writer to unload your files, you'll need to format your data so that new Informix can understand it. Unloads in 2.10 will do things like format a null date as "00/00/00" which is an error in 5.0X. (I seem to remember "12/31/1899" poping up alot also) All of your acego and perform files need to be converted. The select statements have changed (to ANSII SQL). This isn't difficult, just make sure your results are the same between old and new. If I remember correctly there are some syntax difference too. Hope this helps. -- || ======= **** **T* ======= ||John Regep || **** **** ||Kmart Information Systems || **** *R** ||Kmart Corporation || =========== ********* =========== ||3100 West Big Beaver C-1 || ***A* **** ||Troy, MI 48084 || **** **** ||(810) 643-5078 ||=============== *M** **** ===============||uunet!kmart!jregep