c libraries to access db2

On 6 déc, 19:26, Larry 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
 >> Stay informed about: c libraries to access db2 

On 7 déc, 07:23, "Mark A" wrote:
> > "News" wrote in message
> >
> > "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
 >> Stay informed about: c libraries to access db2 

On 7 déc, 06:27, Larry wrote:
> News wrote:
> > On 6 déc, 19:26, Larry 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 ?
 >> Stay informed about: c libraries to access db2 

> "News" wrote in message
>
> "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.
 >> Stay informed about: c libraries to access db2 

News wrote:
> On 6 déc, 19:26, Larry 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
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.
 >> Stay informed about: c libraries to access db2 

On 7 déc, 15:41, "Mark A" wrote:
> "News" wrote in message
>
>
>
> > 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..
 >> Stay informed about: c libraries to access db2 

"News" wrote in message

> 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.
 >> Stay informed about: c libraries to access db2 

> "News" wrote in message
>
> 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.
 >> Stay informed about: c libraries to access db2 

News wrote:
> On 7 déc, 06:27, Larry wrote:
>
>>News wrote:
>>
>>>On 6 déc, 19:26, Larry 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 ?
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.
 >> Stay informed about: c libraries to access db2 

On 8 déc, 02:14, Larry wrote:
> News wrote:
> > On 7 déc, 06:27, Larry wrote:
>
> >>News wrote:
>
> >>>On 6 déc, 19:26, Larry 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 withDB2?
>
> Well, you said you wanted c libraries that would enable you to "build c
> 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 !!!
 >> Stay informed about: c libraries to access db2 

On 7 déc, 16:25, "Mark A" wrote:
> > "News" wrote in message
> >
> > 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
 >> Stay informed about: c libraries to access db2 

On 8 déc, 15:19, News wrote:
> On 7 déc, 16:25, "Mark A" wrote:
>
> > > "News" wrote in message
> > >
> > > 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
 >> Stay informed about: c libraries to access db2 

"News" wrote in message

> 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).
 >> Stay informed about: c libraries to access db2