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 >