RE: Informix 7.x and Fourgen

We went throuth this as well. We were a Fougen 4.10 development shop running against 5.XX informix. We had some problems other than the one discussed below. You will find that in 6.XX and high engines your code generation tools will not work. the problem is this the old tools would call the folowing code. database dbname This caused us a lot of problems, since in 6.XX engines and higher you need to do the following. close database database dbname What we ended up doing for the short term was to use the case tools against 5.XX engine and compile and run against 6.XX or higher. this works fine and we are continuing to do this. You will have to modify your Fourgen libraries to handle this problem as well. (Since init.4gl for fougen does this same thing.). We had some other issues but I don't recall any that we couldn't get around with some changes in our coding style. We ended up moving to Fourgen 4.12 where this problem is fixed and have not had any problem since. ( But this was a very painfull upgrading process even thou some people will its not) GOOD LUCK..... Russ.... }---------- }From: richardw@orion.dairymans.com[SMTP:richardw@orion.dairymans.com] }Sent: Thursday, January 30, 1997 10:40 AM }To: leonj@zeta.org.au }Cc: informix-list@rmy.emory.edu }Subject: Re: Informix 7.x and Fourgen } }Leon, } We've recently performed the same upgrade on our system. We had three }things }that took a little work to correct. } 1) The INFORMIXSERVER variable must be set for all users. (Not really a }big } deal, just took us time to find all of the places in our system where } we needed to replace TBCONFIG with INFORMIXSERVER) } 2) We had another problem with some of our legacy code... } The programs were preparing a statement then opening without } declaring the cursor. We had to declare each of these cursors } and then open them. } i.e.: OLD - prepare stmt from scratch } open stmt } } NEW - prepare stmt from scratch } declare stmt_curs cursor for stmt } open stmt_curs } } This also worked pre upgrade..(Note the declared/prepared names) } prepare stmt from scratch } declare stmt_curs cursor for stmt } open stmt } 3) Cursor Name Mangling } The mangling scheme forced us to change some of our cursor } names. (i.e. this_curs1 and this_curs2 worked fine pre-upgrade } however they were mangled into the same name post-upgrade) } We had to make sure that cursor names were unique within the } first few characters. (I think it was 6, but I'm not sure.) } } 4) If you are using a temp dbspace you will need to make sure that you }don't } have any cluster indexes being created for temp tables. (More legacy } code...still can't figure out why those that came before chose to try } this one...) } }Most of these issues are in the Release notes.... Otherwise, things went }pretty }smoothly. Good luck. } }Richard Walther }Senior Programmer }Dairyman's Cooperative Creamery Association }richardw@dairymans.com } } }> From informix-list-owner@rmy.emory.edu Wed Jan 29 21:15:34 1997 }> Subject: Informix 7.x and Fourgen }> Reply-To: "Leon" <leonj@zeta.org.au> }> Organization: Kralizec Dialup Internet Sydney, http://www.zeta.org.au/ }> Sender: informix-list-owner@rmy.emory.edu }> To: informix-list@rmy.emory.edu }> X-Informix-List-To: richardw@orion.dairymans.com }> X-Informix-List-Id: <news.33147> }> Content-Length: 221 }> X-Lines: 5 }> }> We are using Online 5.05, with Fourgen Case tools 4.10. We would like to }> upgrade to Online 7.x Is there anyone out there who has done somthing }> similar, and if so are there any problems to look out for. }> }> leonj@zeta.org.au }> }