Re: Informix 4.1 vs later versions
From villy Thu Oct 22 15:20:05 1992
Subject: Re: Informix 4.1 vs later versions
To: auzodt3.mel.cocam.oz.au!adamt@uunet.UUCP
Date: Thu, 22 Oct 92 15:20:05 PDT
From: Will Hartung - Master Rallyeist <villy>
In-Reply-To: <1511@rand.mel.cocam.oz.au>; from "Adam Tiller" at Oct 22, 92 2:17 am
X-Mailer: ELM [version 2.3 PL11]
> We moved from 4.1 to 5.0 a few months ago.
> We haven't had a single problem with 5.0 yet!
> We have even found a use for stored procedures to solve an
> integration problem. :-)
This brings up an issue that I'm dealing with right now. We have a system
that runs fine on 4.0, and gives strange errors on 4.1. It has been suggested
we go to 5.0.
So I'm looking for the some notes on the experiences anyone out there has
had running 4.1 OnLine vs OnLine 5.0. We're running it on AIX 3.20 on
an RS/6000 320.
We've been getting both -408 errors and (I think) -242 "Table not open"
errors. It has been suggested we change our code from:
select bla bla bla into temp t_table
to
create temp table t_table( bla bla bla )
insert into t_table select x,y,z ...
This worked (solved our -408 error), but we still had the -242 errors.
Ended up replacing several "prepare - open - fetch" groups with just
plain 'selects' in the 4GL.
While researching this, someone suggested just going to 5.0, saying that
it's "Just Super", and a lot more stable.
So any thoughts etc. would be appreciated.
Will
(uunet!la4gen!villy)