Re: -1228 rc from rdefmtdate()???

In article <CLqs49.JE0@group1.com>, karla@group1.com (Karla Leibowitz) writes: |> : However, if you are installing an Informix tool which is older |> : (lower version number) than any other Informix tool you did install |> : previously, these ".iem" files are simply WRONG. The newer ones are |> : silently overwritten with the old versions. |> It means reinstalling the |> engine and I-Star whenever you get a bug fix for the sql or 4gl products |> that you are using. Which means taking the engine off-line to do a language |> upgrade. |> |> We have shortened the downtime by installing into a dummy directory and then |> swapping directories. The system administrator has also cpio'd the engine |> and istar so that he can just zap them into place and avoid having to |> sit by the floppy drive feeding it disk after disk. The sqlexecd daemon has |> to be killed and restarted when you make the swap. Actually, it doesn't even have to be that complicated. As pointed out in your included text, it is only the .iem files that cause the conflict. I know sql.iem is one of the primary offenders (it contains the set explain text) but there may be a couple more. If you just make a copy of the .iem files common to both the server and tools before your install, then copy them back after, you should be fine. The following is the list (circa 5.0) of .iem files that come with tools (4gl, ISQL) that also come with the server: msg/dbload.iem msg/esql.iem msg/esqlc.iem msg/isam.iem msg/ised.iem msg/isedhelp.iem msg/os.iem msg/rds.iem msg/security.iem msg/sql.iem If you copy the version of these that come with the server somewhere, then copy them back after your tool install, you should be ok. And you should not have to bring your server down to do this. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney