Re: Running Informix-4gl Version 4.0 under AIX 4.3.3 on IBM-6000 6F1

Informix-4GL version 4.0??? Did the gentleman from IBM have a clue about the current version levels of 4GL and if the old version would work on AIX 4.3? Curious - Mr. Leffler? Rob > Here's a brief description of the situation we have now... > > Over the weekend, a gentleman from IBM backed up our production machine > (F50-AIX 4.2), installed AIX 4.3 on it, cloned the data to our new > server (F80-6F1), then restored our production machine (F50) to AIX 4.2. > > We can make every program we have run, but have to tweak certain things > first on the new 6F1. > > Initially running the C4GL compiler bombed out, and gave an error > message: > > -408 Invalid message type received from the sqlexec process. > > We got on groups.google.com and found an enviroment varable SQLEXEC that > points to the sqlexec processor (?). I did a "find" and noticed we had > 3 version of sqlexec. > > /usr/UAP/informix/5SE/lib/sqlexec > /usr/UAP/informix/2.1/lib/sqlexec > /usr/informix/lib/sqlexec > > In experiment with setting SQLEXEC to point to the different sqlexecs, > and had sucess using C4GL. I compiled a screen program (i_????.4ge) > and it ran perfectly. I compiled a report (o_???.4ge) and it appeared > to run properly, but showed "No Elements to Process". When I changed > the SQLEXEC to /usr/informix/lib the report gave the original error > "Invalid message received from sqlexec process". But when I moved the > report under the all.4gm directory and recompliled it (using the 5SE > sqlexec) then run it (using the /informix/lib/sqlexec) it runs > perfectly. > > Bottom Line: > To compile using C4GL set SQLEXEC=/usr/UAP/informix/5SE/lib/sqlexec To > run a screen program (i_???) set SQLEXEC to > SQLEXEC=/usr/UAP/informix/5SE/lib/sqlexec; export SQLEXEC > To run a report or posting program, move directory under all.4gm and set > SQLEXEC to SQLEXEC=/usr/informix/lib/sqlexec; export SQLEXEC > > We think we can do a "dirty" fix and move all of our program under > all.4gm (rather than pb.4gm, ar.4gm, etc) and put an extra line in each > menu file that sets SQLEXEC to the proper value for running a report or > a screen. But we know there must be a cleaner way to do this. Any help > would be much appreciated. > > Thanks, > Rick