I downloaded and installed the latest client SDK from Informix this morning
(2.81 UC2).

I downloaded sqlcmd-72.00 as well. I ran ./configure. No problems. I ran
'make' and got the following messages after getting pretty far:

INFORMIXC="gcc" esql -o appblob appblob.o libjlss.a
/opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_b'
/opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_toupper'
/opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_tolower'
collect2: ld returned 1 exit status
make: *** [appblob] Error 1


I checked the files in /opt/informix/lib/esql/ and see a libifgls.so that is
older (May 15) compared to the libifgls.a which has today's date (when I
installed the CSDK), but both were put on the system today when I installed the
CSDK (because I started with a clean slate). All the remaining compilations
from 'make -k' show this error, too.

How do I get past this problem?

Mark

Mark Fenbers wrote:

> I downloaded and installed the latest client SDK from Informix this morning
> (2.81 UC2).
>
> I downloaded sqlcmd-72.00 as well. I ran ./configure. No problems. I ran
> 'make' and got the following messages after getting pretty far:
>
> INFORMIXC="gcc" esql -o appblob appblob.o libjlss.a
> /opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_b'
> /opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_toupper'
> /opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_tolower'
> collect2: ld returned 1 exit status
> make: *** [appblob] Error 1
>
>
> I checked the files in /opt/informix/lib/esql/ and see a libifgls.so that is
> older (May 15) compared to the libifgls.a which has today's date (when I
> installed the CSDK), but both were put on the system today when I installed the
> CSDK (because I started with a clean slate). All the remaining compilations
> from 'make -k' show this error, too.
>
> How do I get past this problem?


This is basically the RedHat 9 problem alluded to elsewherein c.d.i
today - it is primarily a bug in ESQL/C rather than any of the code in
SQLCMD per se. I've lost track of the correct version of CSDK for
fixing this problem - I think it exists, but I'm not sure what the
number is (beyond, apparently, being later than 2.81.UC2). According
to one of the other posts, the ESQL/C version 9.53.UC2 has the errno
problem fixed - and presumably this one too. When you type 'esql -V',
is this the version you get?


--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

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?

Mark


Jonathan Leffler wrote:

> Mark Fenbers wrote:
>
> > I downloaded and installed the latest client SDK from Informix this morning
> > (2.81 UC2).
> >
> > I downloaded sqlcmd-72.00 as well. I ran ./configure. No problems. I ran
> > 'make' and got the following messages after getting pretty far:
> >
> > INFORMIXC="gcc" esql -o appblob appblob.o libjlss.a
> > /opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_b'
> > /opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_toupper'
> > /opt/informix/lib/esql/libifgls.so: undefined reference to `__ctype_tolower'
> > collect2: ld returned 1 exit status
> > make: *** [appblob] Error 1
> >
> >
> > I checked the files in /opt/informix/lib/esql/ and see a libifgls.so that is
> > older (May 15) compared to the libifgls.a which has today's date (when I
> > installed the CSDK), but both were put on the system today when I installed the
> > CSDK (because I started with a clean slate). All the remaining compilations
> > from 'make -k' show this error, too.
> >
> > How do I get past this problem?
>
> This is basically the RedHat 9 problem alluded to elsewherein c.d.i
> today - it is primarily a bug in ESQL/C rather than any of the code in
> SQLCMD per se. I've lost track of the correct version of CSDK for
> fixing this problem - I think it exists, but I'm not sure what the
> number is (beyond, apparently, being later than 2.81.UC2). According
> to one of the other posts, the ESQL/C version 9.53.UC2 has the errno
> problem fixed - and presumably this one too. When you type 'esql -V',
> is this the version you get?
>
> --
> Jonathan Leffler #include <disclaimer.h>
> Email: jleffler@earthlink.net, jleffler@us.ibm.com
> Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

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.