I am having a problem install the DBD::DB2 module on my IBM server running
AIX 5. I download DBI-1.48 from the CPAN site and successfully installed
it. I also downloaded DBD-DB2-0.78 from the CPAN site but I am having a
problem installing it. I get an error when I issue the 'make' command. I
have successfully installed 'IBM DB2 Universal Database' and I can issue
db2 commands from an xterm session to my database. I need to install the
DBD::DB2 module so that I can write a perl script to access my database.
Any help would be appreciated. I have include information concerning the
install .Please let me know if you need any further information.
--------------------------------------------------------------------------------------------------------
IBM DB2 Universal Database
Release Notes
Version 8.2 (Version 8.1 FixPak 7)
Before using this information and the product it supports, be sure to
read the general information under Notices.
----------------------------------------------------------------------------------------------------------
perl -v
This is perl, v5.8.3 built for aix
Copyright 1987-2003, Larry Wall
Perl may be copied only under the terms of either the Artistic License or
the
GNU General Public License, which may be found in the Perl 5 source kit.
Complete documentation for Perl, including FAQ lists, should be found on
this system using `man perl' or `perldoc perl'. If you have access to the
Internet, point your browser at http://www.perl.com/, the Perl Home Page.
------------------------------------------------------------------------------------------------------------
gcc -v
Reading specs from /usr/local/lib/gcc/powerpc-ibm-aix5.1.0.0/3.4.3/specs
Configured with: ../gcc-3.4.3/configure --disable-nls --disable-aix64
Thread model: aix
gcc version 3.4.3
-------------------------------------------------------------------------------------------------------------
DBD-DB2-0.78: perl Makefile.PL
Configuring DBD::DB2...
Remember to actually read the README and CAVEATS files!
Using DB2 in "/local_home/db2inst1/sqllib"
System: perl5.008003 DBI1.48 aix pdslib51 1 5 00088d5f4c00 aix dl_aix.xs
Compiler: cc -O -D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-qmaxmem=16384 -qnoansialias -DUSE_NATIVE_DLOPEN -I/usr/local/include -q32
-D_LARGE_FILES -qlonglong
Includes: -I"/local_home/db2inst1/sqllib/include"
-I"/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI"
Libraries: -L/local_home/db2inst1/sqllib/lib -ldb2
Checking if your kit is complete...
Looks good
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::DB2::Constants
Writing Makefile for DBD::DB2
-----------------------------------------------------------------------------------------------------------
make
cc -c -I"/local_home/db2inst1/sqllib/include"
-I"/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI" -D_ALL_SOURCE
-D_ANSI_C_SOURCE -D_POSIX_SOURCE -qmaxmem=16384 -qnoansialias
-DUSE_NATIVE_DLOPEN -I/usr/local/include -q32 -D_LARGE_FILES -qlonglong -O
-DVERSION=\"0.78\" -DXS_VERSION=\"0.78\" "-I/usr/local/lib/perl5/5.8.3
/aix/CORE" DB2.c
cc: unrecognized option `-qmaxmem=16384'
cc: unrecognized option `-qnoansialias'
cc: unrecognized option `-q32'
cc: unrecognized option `-qlonglong'
In file included from DB2.xs:7:
DB2.h:9:20: sqlcli.h: No such file or directory
DB2.h:11:21: sqlcli1.h: No such file or directory
DB2.h:12:20: sqlext.h: No such file or directory
DB2.h:14:66: sqlstate.h: No such file or directory
In file included from DB2.h:20,
from DB2.xs:7:
dbdimp.h:16: error: parse error before "SQLHENV"
dbdimp.h:16: warning: no semicolon at end of struct or union
dbdimp.h:19: error: parse error before '}' token
dbdimp.h:24: error: parse error before "SQLHENV"
dbdimp.h:24: warning: no semicolon at end of struct or union
dbdimp.h:25: warning: data definition has no type or storage class
dbdimp.h:27: error: parse error before '}' token
dbdimp.h:33: error: parse error before "SQLHENV"
dbdimp.h:33: warning: no semicolon at end of struct or union
dbdimp.h:34: warning: data definition has no type or storage class
dbdimp.h:35: error: parse error before "phstmt"
dbdimp.h:35: warning: data definition has no type or storage class
dbdimp.h:38: error: parse error before '*' token
dbdimp.h:38: warning: data definition has no type or storage class
dbdimp.h:42: error: parse error before "done_desc"
dbdimp.h:42: warning: data definition has no type or storage class
dbdimp.h:44: error: parse error before '*' token
dbdimp.h:44: warning: data definition has no type or storage class
dbdimp.h:48: error: parse error before "RowCount"
dbdimp.h:48: warning: data definition has no type or storage class
dbdimp.h:55: error: parse error before '}' token
dbdimp.h:63: error: parse error before "SQLSMALLINT"
dbdimp.h:63: warning: no semicolon at end of struct or union
dbdimp.h:64: warning: data definition has no type or storage class
dbdimp.h:65: error: parse error before "cbufl"
dbdimp.h:65: warning: data definition has no type or storage class
dbdimp.h:66: error: parse error before "dsize"
dbdimp.h:66: warning: data definition has no type or storage class
dbdimp.h:67: error: parse error before "prec"
dbdimp.h:67: warning: data definition has no type or storage class
dbdimp.h:68: error: parse error before "scale"
dbdimp.h:68: warning: data definition has no type or storage class
dbdimp.h:69: error: parse error before "nullok"
dbdimp.h:69: warning: data definition has no type or storage class
dbdimp.h:72: error: parse error before "ftype"
dbdimp.h:72: warning: data definition has no type or storage class
dbdimp.h:75: error: parse error before "bufferSize"
dbdimp.h:75: warning: data definition has no type or storage class
dbdimp.h:76: error: parse error before "rlen"
dbdimp.h:76: warning: data definition has no type or storage class
dbdimp.h:86: error: parse error before "SQLUSMALLINT"
dbdimp.h:86: warning: no semicolon at end of struct or union
dbdimp.h:87: error: conflicting types for 'indp'
dbdimp.h:73: error: previous declaration of 'indp' was here
dbdimp.h:87: warning: data definition has no type or storage class
dbdimp.h:90: error: parse error before "descSQLType"
dbdimp.h:90: warning: data definition has no type or storage class
dbdimp.h:91: error: parse error before "descDecimalDigits"
dbdimp.h:91: warning: data definition has no type or storage class
dbdimp.h:92: error: parse error before "descColumnSize"
dbdimp.h:92: warning: data definition has no type or storage class
dbdimp.h:95: error: parse error before "sql_state"
dbdimp.h:95: warning: data definition has no type or storage class
DB2.xs: In function `XS_DBD__DB2__dr_disconnect_all':
DB2.xs:41: error: dereferencing pointer to incomplete type
DB2.xs:42: error: dereferencing pointer to incomplete type
DB2.xs: In function `XS_DBD__DB2__db_commit':
DB2.xs:91: error: dereferencing pointer to incomplete type
DB2.xs: In function `XS_DBD__DB2__db_rollback':
DB2.xs:100: error: dereferencing pointer to incomplete type
DB2.xs: In function `XS_DBD__DB2__db_disconnect':
DB2.xs:109: error: dereferencing pointer to incomplete type
DB2.xs:113: error: dereferencing pointer to incomplete type
DB2.xs:114: error: dereferencing pointer to incomplete type
DB2.xs:115: error: dereferencing pointer to incomplete type
DB2.xs:119: error: dereferencing pointer to incomplete type
DB2.xs:119: error: dereferencing pointer to incomplete type
DB2.xs:121: error: dereferencing pointer to incomplete type
DB2.xs:123: error: dereferencing pointer to incomplete type
DB2.xs: In function `XS_DBD__DB2__db_DESTROY':
DB2.xs:164: error: dereferencing pointer to incomplete type
DB2.xs:166: error: dereferencing pointer to incomplete type
DB2.xs:173: error: dereferencing pointer to incomplete type
DB2.xs:174: error: dereferencing pointer to incomplete type
DB2.xs:175: error: dereferencing pointer to incomplete type
DB2.xs:177: error: dereferencing pointer to incomplete type
DB2.xs:178: error: dereferencing pointer to incomplete type
DB2.xs:178: error: dereferencing pointer to incomplete type
DB2.xs:178: error: dereferencing pointer to incomplete type
DB2.xs:180: error: dereferencing pointer to incomplete type
DB2.xs:188: error: dereferencing pointer to incomplete type
DB2.xs:189: error: dereferencing pointer to incomplete type
DB2.xs:194: error: dereferencing pointer to incomplete type
DB2.xs:194: error: dereferencing pointer to incomplete type
DB2.xs:194: error: dereferencing pointer to incomplete type
DB2.xs: In function `XS_DBD__DB2__st_execute':
DB2.xs:336: error: dereferencing pointer to incomplete type
DB2.xs:338: error: dereferencing pointer to incomplete type
DB2.xs:343: error: dereferencing pointer to incomplete type
DB2.xs:344: error: dereferencing pointer to incomplete type
DB2.xs:345: error: dereferencing pointer to incomplete type
DB2.xs:360: error: dereferencing pointer to incomplete type
DB2.xs:361: error: dereferencing pointer to incomplete type
DB2.xs: In function `XS_DBD__DB2__st_finish':
DB2.xs:406: error: dereferencing pointer to incomplete type
DB2.xs:407: error: dereferencing pointer to incomplete type
DB2.xs:411: error: dereferencing pointer to incomplete type
DB2.xs:414: error: dereferencing pointer to incomplete type
DB2.xs:414: error: dereferencing pointer to incomplete type
DB2.xs:414: error: dereferencing pointer to incomplete type
DB2.xs: In function `XS_DBD__DB2__st_DESTROY':
DB2.xs:472: error: dereferencing pointer to incomplete type
DB2.xs:474: error: dereferencing pointer to incomplete type
DB2.xs:480: error: dereferencing pointer to incomplete type
DB2.xs:481: error: dereferencing pointer to incomplete type
DB2.xs:481: error: dereferencing pointer to incomplete type
DB2.xs:481: error: dereferencing pointer to incomplete type
DB2.xs:483: error: dereferencing pointer to incomplete type
DB2.xs:484: error: dereferencing pointer to incomplete type
DB2.xs:485: error: dereferencing pointer to incomplete type
DB2.xs:489: error: dereferencing pointer to incomplete type
DB2.xs:489: error: dereferencing pointer to incomplete type
DB2.xs:489: error: dereferencing pointer to incomplete type
DB2.xs: In function `boot_DBD__DB2':
DB2.xs:24: error: invalid application of `sizeof' to incomplete type
`/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI/DBIXS.h'
DB2.xs:25: error: invalid application of `sizeof' to incomplete type
`/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI/DBIXS.h'
DB2.xs:26: error: invalid application of `sizeof' to incomplete type
`/usr/local/lib/perl5/site_perl/5.8.3/aix/auto/DBI/DBIXS.h'
make: 1254-004 The error code from the last command is 1.
Stop.
*****************************************
Richard Rice
Continental Tire North America, Inc.
(704) 583-8668
*****************************************
