Re: Upgrade gotchas?

After an upgrade from 4GL 7.20 to 7.31.FC1., we found that NULLs are handled differently on cursors (Sorry I don't remember the exact problem). We confirmed the same results on the 32 bit 7.31.UC1 version too. IBM tech support told us that the 7.20 tools were not handling NULLs corrcetly, and were allowing our sloppy code to work. But not any more :( We ended up changing the SQL where we had problems to be more specific on handling the NULLs. Nick

If you have any C code, grep for "popvchar". (Actually a grep on "pop" would be better.) If you get any hits, you will run into the same issue we did: FROM RELEASE NOTES: C code for use with releases of 4GL earlier than Version 7.31 that calls any of the pop, push, or return functions must be recompiled with fglsys.h header file to map the pre-Version 7.31 names onto the new function names. After troubleshooting you just need to add in this to the top of your code: #include </opt/informix/incl/tools/fglsys.h> This cost us several hours of troubleshooting. Regards, Daniel