Running Informix-4gl Version 4.0 under AIX 4.3.3 on IBM-6000 6F1
Posted in 2003
Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Platform-Specific Issues
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