Re: sqlcmd-72.00 compile problems

Mark Fenbers wrote: > Yes, I install the latest and greatest (2.81.UC2 - ESQL 9.53), and I know that it is > a problem with ESQL/C and not sqlcmd. A poster from IBM has told me privately that > IBM is working on a patch (2.81.UC3) that should address the problem and be out later > in the quarter. But I can't wait that long. I have about 15-20 scripts that do > various jobs for our operations that are now broken since upgrading to RH9. I must > either fix sqlcmd or rework the code in all those scripts. > > The part that fails during compilation is at link-time with libifsgl.so, and I > figured that if I can link with the static library libifsgl.a then maybe it might > work. But I don't know how to link statically as it seems that it is controlled by > esql, not sqlcmd's Makefile... > > Ideas? > You can link statically when you add "-static" as additional parameter for esql. So you must call configure this way: LDFLAGS="-static" ./configure. Or you simply edit the Makefile and search for USER_LDFLAGS where you can add "-static". I just tried this on Solaris 9. After this, all informix libs are linked statically, only system libs remain dynamically linked.

Frank, Thanks for the tip. I compiled, uas you suggested, using -static, but had similar "undefined reference" results with the static library (libifgls.a) as I did the dynamic one (libifgls.so). So I am back to square one... thanks anyway... Mark "Langelage, Frank" wrote: > Mark Fenbers wrote: > > Yes, I install the latest and greatest (2.81.UC2 - ESQL 9.53), and I know that it is > > a problem with ESQL/C and not sqlcmd. A poster from IBM has told me privately that > > IBM is working on a patch (2.81.UC3) that should address the problem and be out later > > in the quarter. But I can't wait that long. I have about 15-20 scripts that do > > various jobs for our operations that are now broken since upgrading to RH9. I must > > either fix sqlcmd or rework the code in all those scripts. > > > > The part that fails during compilation is at link-time with libifsgl.so, and I > > figured that if I can link with the static library libifsgl.a then maybe it might > > work. But I don't know how to link statically as it seems that it is controlled by > > esql, not sqlcmd's Makefile... > > > > Ideas? > > > > You can link statically when you add "-static" as additional parameter > for esql. > So you must call configure this way: LDFLAGS="-static" ./configure. > Or you simply edit the Makefile and search for USER_LDFLAGS where you > can add "-static". > I just tried this on Solaris 9. After this, all informix libs are linked > statically, only system libs remain dynamically linked.