Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

c libraries to access db2

138 views
Skip to first unread message

News

unread,
Dec 6, 2008, 3:27:00 AM12/6/08
to
HI ! could anyone point me to where can I find and install c libraries
for db2 8.2 under AIX 5.3 ? I means contents of sqllib/include and
sqllib/lib
regards

Larry

unread,
Dec 6, 2008, 1:26:29 PM12/6/08
to
Which "C" libraries do you want? Generally, if one needs C libraries
under AIX, one must purchase them and order them in the form of the AIX
C Runtime Libraries:

http://www-01.ibm.com/software/sw-bycategory/subcategory/SW760.html

Larry E.

News

unread,
Dec 6, 2008, 11:50:54 PM12/6/08
to
On 6 déc, 19:26, Larry <la...@nospam.net> wrote:
> News wrote:
> > HI ! could anyone point me to where can I find and install c libraries
> > fordb28.2 under AIX 5.3 ? I means contents of sqllib/include and

> > sqllib/lib
> > regards
>
> Which "C" libraries do you want?

"C" libraries to build c applications with embeded SQL to access DB2
under AIX

Larry

unread,
Dec 7, 2008, 12:27:23 AM12/7/08
to
Again, the ones that I know about for AIX, one must purchase them and
order them in the form of the AIX C Runtime Libraries:

http://www-01.ibm.com/software/sw-bycategory/subcategory/SW760.html

You might also be able to find freeware "C" libraries somewhere, but
you'd need to check with DB2 support to find out if they would be
supported with DB2.

Larry E.

Mark A

unread,
Dec 7, 2008, 1:23:09 AM12/7/08
to
> "News" <Conta...@hotmail.com> wrote in message
> news:13ea93bb-ea0e-4c0b...@k36g2000yqe.googlegroups.com...

> "C" libraries to build c applications with embeded SQL to access DB2
> under AIX

If you want the libraries in the directories you mentioned earlier, you
download the DB2 8.2 Try and Buy code for AIX and install the code.

I assume you can find the exact same libraries in the DB2 8.3 for Windows
version, in which case just down load 8.2 FP17 Server code and install it
(license will expire in 90 days). You might be able to extract the files on
the windows version without installing the DB2 product.


News

unread,
Dec 7, 2008, 3:36:27 AM12/7/08
to
On 7 déc, 07:23, "Mark A" <some...@someone.com> wrote:
> > "News" <Contact_...@hotmail.com> wrote in message

> >news:13ea93bb-ea0e-4c0b...@k36g2000yqe.googlegroups.com...
> > "C" libraries to build c applications with embeded SQL to accessDB2
> > under AIX
>
> If you want the libraries in the directories you mentioned earlier, you
> download the DB2 8.2 Try and Buy code for AIX and install the code.

what's DB2 8.2 code means ? any URL ?

we have DB2 8.2 entreprise edition installed with permanent license
but the directories sqllib/lib and include are empty

News

unread,
Dec 7, 2008, 3:38:11 AM12/7/08
to
On 7 déc, 06:27, Larry <la...@nospam.net> wrote:
> News wrote:
> > On 6 déc, 19:26, Larry <la...@nospam.net> wrote:
>
> >>News wrote:
>
> >>>HI ! could anyone point me to where can I find and install c libraries
> >>>fordb28.2 under AIX 5.3 ? I means contents of sqllib/include and
> >>>sqllib/lib
> >>>regards
>
> >>Which "C" libraries do you want?
>
> > "C" libraries to build c applications with embeded SQL to accessDB2
> > under AIX
>
> Again, the ones that I know about for AIX, one must purchase them and
> order them in the form of the AIX C Runtime Libraries:

we have XL C/C++ for AIX installed and then ? what about the contents
of sqllib ?

according to you it comes with c compiler and according to Mark it
comes with DB2 ?

Mark A

unread,
Dec 7, 2008, 9:41:23 AM12/7/08
to
"News" <Conta...@hotmail.com> wrote in message
news:55f4d77f-a940-4d44...@r40g2000yqj.googlegroups.com...

> we have DB2 8.2 entreprise edition installed with permanent license
> but the directories sqllib/lib and include are empty

Do you have an instance created (using db2icrt)? That is when the sqllib
directory is created.

The path is <instance-home>/sqllib/lib

where <instance-home> is the home directory of the instance owner userid.

If those directories are there for an existing instance, but are empty, I
don't have an answer. Maybe someone deleted them? Try creating a new
instance.


News

unread,
Dec 7, 2008, 9:47:21 AM12/7/08
to
On 7 déc, 15:41, "Mark A" <some...@someone.com> wrote:
> "News" <Contact_...@hotmail.com> wrote in message
>
> news:55f4d77f-a940-4d44...@r40g2000yqj.googlegroups.com...
>
> > we haveDB28.2 entreprise edition installed with permanent license

> > but the directories sqllib/lib and include are empty
>
> Do you have an instance created (using db2icrt)? That is when the sqllib
> directory is created.
>
> The path is <instance-home>/sqllib/lib
>
> where <instance-home> is the home directory of the instance owner userid.
>
> If those directories are there for an existing instance, but are empty, I
> don't have an answer. Maybe someone deleted them? Try creating a new
> instance.

in fact, sqllib/include and sqllib/lib are symbolic link to
directories where software is installed. Include is almost empty (it
contains only asn.h since we use replication). lib contains a lot of
files but not the required ones to link c program..

Mark A

unread,
Dec 7, 2008, 10:25:39 AM12/7/08
to
> "News" <Conta...@hotmail.com> wrote in message
> news:dcd531b6-c92e-4a6c...@d14g2000yqb.googlegroups.com...

> in fact, sqllib/include and sqllib/lib are symbolic link to
> directories where software is installed. Include is almost empty (it
> contains only asn.h since we use replication). lib contains a lot of
> files but not the required ones to link c program..

I don't know what files you are talking about, but you need a C compiler
(not included with DB2) to compile C programs. I have compiled C programs
running against DB2 on Linux using GCC, but I don't know if that is
available for AIX. IBM has a C compiler for AIX, but you must purchase that.


Larry

unread,
Dec 7, 2008, 8:14:56 PM12/7/08
to
Well, you said you wanted c libraries that would enable you to "build c
applications with embeded SQL to access DB2". You must have a C compiler
to do so.

Larry E.

News

unread,
Dec 8, 2008, 9:05:00 AM12/8/08
to
> applications with embeded SQL to accessDB2". You must have a C compiler
> to do so.
>

sorry ! having c compiler it's not enough

for embedded SQL some include files must be there as sqladef.h and
sqlca.h.... These files are part of DB2 and not of the compiler

I cannot find these files !!!

News

unread,
Dec 8, 2008, 9:19:24 AM12/8/08
to
On 7 déc, 16:25, "Mark A" <some...@someone.com> wrote:
> > "News" <Contact_...@hotmail.com> wrote in message

> >news:dcd531b6-c92e-4a6c...@d14g2000yqb.googlegroups.com...
> > in fact, sqllib/include and sqllib/lib are symbolic link to
> > directories where software is installed. Include is almost empty (it
> > contains only asn.h since we use replication). lib contains a lot of
> > files but not the required ones to link c program..
>
> I don't know what files you are talking about

after precompiling sqc file usinf db2 prep ..

there's

#include "sqladef.h"

/*
EXEC SQL INCLUDE SQLCA;
*/

is translatled

/* SQL Communication Area - SQLCA - structures and constants */
#include "sqlca.h"

and so on ..

I need theses include .h files

and I didn't reach linking to know what lib are missing

Mark A

unread,
Dec 8, 2008, 10:26:09 AM12/8/08
to
"News" <Conta...@hotmail.com> wrote in message
news:25f85d15-6bb2-487f...@a29g2000pra.googlegroups.com...

> sorry ! having c compiler it's not enough
>
> for embedded SQL some include files must be there as sqladef.h and
> sqlca.h.... These files are part of DB2 and not of the compiler
>
> I cannot find these files !!!

I found the include files on a DB2 V9.5 FP 2 Linux system that I installed
at ../sqllib/include (within home directory of instance) with symbolic link
to /opt/ibm/db2/V9.5/include (this would be slightly different for AIX).

But on another Linux system (DB2 V9.5 FP 2 installed by our system
administrator) there is only the asn.h file in that directory.

I also found them on a DB2 Express-C for Windows systems that I have running
on my PC, also at ..\sqllib\include.

It could be that you need the Application Development Client installed along
with the server, I am not sure. If you download DB2 8.2 Fixpack 17 for
Windows, you should be able to extract them out of there (or you may have to
do an DB2 install on a PC to get them).


News

unread,
Dec 8, 2008, 10:28:46 AM12/8/08
to
On 8 déc, 15:19, News <Contact_...@hotmail.com> wrote:
> On 7 déc, 16:25, "Mark A" <some...@someone.com> wrote:
>
> > > "News" <Contact_...@hotmail.com> wrote in message
> > >news:dcd531b6-c92e-4a6c...@d14g2000yqb.googlegroups.com...
> > > in fact, sqllib/include and sqllib/lib are symbolic link to
> > > directories where software is installed. Include is almost empty (it
> > > contains only asn.h since we use replication). lib contains a lot of
> > > files but not the required ones to link c program..
>
> > I don't know what files you are talking about
>
> after precompiling sqc file usinfdb2prep ..

>
> there's
>
> #include "sqladef.h"
>
> /*
> EXEC SQL INCLUDE SQLCA;
> */
>
> is translatled
>
> /* SQL Communication Area - SQLCA - structures and constants */
> #include "sqlca.h"
>
> and so on ..
>
> I need theses include .h files
>
> and I didn't reach linking to know what lib are missing

finally i found out the missing files part of "Application Development
Client" that needs to be downloaded and installed from here

http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21256046

News

unread,
Dec 9, 2008, 3:53:04 AM12/9/08
to
On 8 déc, 16:26, "Mark A" <some...@someone.com> wrote:
> It could be that you need the Application Development Client installed along
> with the server, I am not sure. If you downloadDB28.2 Fixpack 17 for

> Windows, you should be able to extract them out of there (or you may have to
> do anDB2install on a PC to get them).

it's OK with DB2

now I'm looking for the same files for MQ Series .. mqm/inc and mqm/
lib any help ?

0 new messages