Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^6: DBD::ODBC to Teradata

by DanEllison (Scribe)
on Nov 12, 2010 at 14:16 UTC ( [id://871061]=note: print w/replies, xml ) Need Help??


in reply to Re^5: DBD::ODBC to Teradata
in thread DBD::ODBC to Teradata

Okay! I got it going with the DataDirect ODBC that was shipped with the Teradata client. My first problem, although InstallDir pointed to a directory with my ini's and libs, it didn't have locale info which is why I wasn't getting my messages. Secondly, DataDirect apparently doesn't use the odbcinst.ini so I had to directly identify my driver in the .odbc.ini.

After getting it to work with DataDirect, I went back to see if I could get it working with unixODBX. Under 2.2.11, tdata.so was trying to open shared objects that existed in DataDirect and don't exist in unixODBC. 2.3.0 couldn't open the tdata.so driver at all.

To get the DBD-ODBC to compile with DataDirect, I had to make similar modifications to the Makefile.PL as were described in the document http://web.datadirect.com/resources/odbc/perl/config.html. My diff looks like:

diff Makefile.DataDirect Makefile.PL
448,450d447
<     $myodbc = 'intersolve'
<         if !$myodbc && -f "$odbchome/include/sqlunx.h";
<
463a461,463
>     $myodbc = 'intersolve'
>         if !$myodbc && -f "$odbchome/include/qeodbc.h";
>
627c627
<       #print {$sqlhfh} qq{#include <qeodbc.h>\n};
---
>       print {$sqlhfh} qq{#include <qeodbc.h>\n};
631,632c631
<           #print {$sqlhfh} qq{#include <sql.h>\n#include <sqltypes.h
+>\n#include <sqlext.h>\n};
<           print {$sqlhfh} qq{#include <sql.h>\n#include <sqltypes.h>
+\n#include <sqlext.h>\n#include <sqlucode.h>\n};
---
>           print {$sqlhfh} qq{#include <sql.h>\n#include <sqltypes.h>
+\n#include <sqlext.h>\n};

[download]

The Teradata client install builds a link /usr/odbc for ODBCHOME, but it didn't include includes or odbc_config so I found it better to set ODBCHOME directly to /opt/teradata/client/13.0/odbc_32 for building. InstallDir could still point to link /usr/odbc.

Replies are listed 'Best First'.
Re^7: DBD::ODBC to Teradata
by DanEllison (Scribe) on Mar 09, 2011 at 16:39 UTC

    Okay, I'm back...

    We've moved from the 32bit AIX environment to a 64bit Linux environment. I've followed my prescription from my previous troubles with no joy. DBD::ODBC compiles, but make test hangs in 05meth. If I install anyway and run, I get a Memory Fault.

    When I compiled, there are plenty of warnings of unused variables and differing signedness which makes me uneasy.

[reply]

      I get no warnings compiling here on Linux with unixODBC header files. The compilation warnings can depend on what ODBC header files you use - not all ODBC driver managers are the same. Please post your ODBC driver manager name and the warnings.

      If it hangs in 05meth then do prove -vb t/05meth.t and post it. Even better, set DBI_TRACE=15=x.log and export it, then run prove and post the output. If you don't want to do that here then rt it and I'll look at it.

      However, I have not got Teradata and if you are using a commercial ODBC driver manager or ODBC driver I may only be able to offer limited help.

[reply]

        Thanks for replying. Let me again note that I modified the Makefile.PL according to http://www.datadirect.com/resources/odbc/perl/config.html which was useful on 32bit AIX. I did keep a copy of the original Makefile.PL, and frankly I get the same result either way.

        delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> perl Makefile.PL PREFIX=${
+uwhdir}/${uwhenv}/public
Argument "6.57_06" isn't numeric in subroutine entry at Makefile.PL li
+ne 23
        main::BEGIN() called at /etldata_daidev/dev1/public/lib/perl5/
+5.8.8/ExtUtils/MakeMaker.pm line 23
        eval {...} called at /etldata_daidev/dev1/public/lib/perl5/5.8
+.8/ExtUtils/MakeMaker.pm line 23
Useless use of private variable in void context at Makefile.PL line 10
+24.

**********
        Remember to actually *READ* the README file!
        And re-read it if you have any problems.

**********

OSNAME: linux
LANG: en_US
ODBCHOME: /opt/teradata/client/13.0/odbc_64
LD_LIBRARY_PATH: /usr/teragss/suselinux-x8664/client/lib:/opt/teradata
+/client/13.0/odbc_64/lib:/opt/teradata/client/13.0/odbc_64/drivers:/o
+pt/teradata/client/13.0/tbuild/lib:/usr/lib
DBROOT:
WINDIR:
II_SYSTEM:
You are using a Perl configured with threading enabled.
Please read the warnings in DBI about this.

You should also be aware that on non-Windows platforms ODBC drivers co
+me
in two forms, thread-safe and non-thread-safe drivers and you may need
to make sure you are using the right one.

Press return to continue...
Looking for odbc_config at /opt/teradata/client/13.0/odbc_64/bin/odbc_
+config
Looking for odbc_config on PATH
  odbc_config not found
Looking for iodbc-config on PATH
  iodbc_config not found
odbc_config not found - ok, there are other things I can do
Still trying to guess ODBCHOME - looking for headers now
  trying /opt/teradata/client/13.0/odbc_64/include
  Found sql.h, sqlext.h, sqltypes.h in /opt/teradata/client/13.0/odbc_
+64/include
Using ODBCHOME /opt/teradata/client/13.0/odbc_64

This looks like a intersolve type of driver manager.
You seem to have the official header files.

Multiple copies of Driver.xst found in: /etldata_daidev/dev1/public/li
+b64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/ /usr/li
+b64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/ at Ma
+kefile.PL line 144
Using DBI 1.615 (for perl 5.008008 on x86_64-linux-thread-multi) insta
+lled in /etldata_daidev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_6
+4-linux-thread-multi/auto/DBI/
Multiple copies of Driver.xst found in: /etldata_daidev/dev1/public/li
+b64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/ /usr/li
+b64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/ at Ma
+kefile.PL line 1035
Using DBI 1.615 (for perl 5.008008 on x86_64-linux-thread-multi) insta
+lled in /etldata_daidev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_6
+4-linux-thread-multi/auto/DBI/
Writing Makefile for DBD::ODBC
Writing MYMETA.yml

The DBD::ODBC tests will use these values for the database connection:
    DBI_DSN=dbi:ODBC:udwdev     e.g. dbi:ODBC:demo
    DBI_USER=delli28
    DBI_PASS=XXXXXXXX

        [download]
        delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> make
Skip blib/lib/DBD/ODBC.pm (unchanged)
gcc -c   -I. -I/opt/teradata/client/13.0/odbc_64/include -I/etldata_da
+idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult
+i/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wde
+claration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D
+_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FO
+RTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size
+=4 -m64 -mtune=generic   -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fP
+IC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE"   Conver
+tUTF.c
gcc -c   -I. -I/opt/teradata/client/13.0/odbc_64/include -I/etldata_da
+idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult
+i/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wde
+claration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D
+_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FO
+RTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size
+=4 -m64 -mtune=generic   -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fP
+IC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE"   ODBC.c
ODBC.xsi: In function 'XS_DBD__ODBC__db__login':
ODBC.xsi:96: warning: unused variable 'p'
ODBC.xsi:95: warning: unused variable 'u'
ODBC.xsi: In function 'XS_DBD__ODBC__st_bind_col':
ODBC.xsi:497: warning: implicit declaration of function 'odbc_st_bind_
+col'
ODBC.xs: In function 'XS_DBD__ODBC__st__statistics':
ODBC.xs:99: warning: implicit declaration of function 'dbd_st_statisti
+cs'
ODBC.xs: In function 'XS_DBD__ODBC__db__ExecDirect':
ODBC.xs:138: warning: unused variable 'lna'
ODBC.xs: In function 'XS_DBD__ODBC__dr_data_sources':
ODBC.xs:286: warning: pointer targets in passing argument 1 of '__buil
+tin___strcpy_chk' differ in signedness
ODBC.xs:286: warning: pointer targets in passing argument 1 of '__strc
+py_ichk' differ in signedness
ODBC.xs:306: warning: pointer targets in passing argument 2 of 'Perl_n
+ewSVpv' differ in signedness
gcc -c   -I. -I/opt/teradata/client/13.0/odbc_64/include -I/etldata_da
+idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult
+i/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wde
+claration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D
+_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FO
+RTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size
+=4 -m64 -mtune=generic   -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fP
+IC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE"   dbdimp
+.c
dbdimp.c: In function 'odbc_db_login6':
dbdimp.c:906: warning: pointer targets in passing argument 3 of 'SQLDr
+iverConnect' differ in signedness
dbdimp.c:906: warning: pointer targets in passing argument 5 of 'SQLDr
+iverConnect' differ in signedness
dbdimp.c:1009: warning: pointer targets in passing argument 2 of 'SQLC
+onnect' differ in signedness
dbdimp.c:1009: warning: pointer targets in passing argument 4 of 'SQLC
+onnect' differ in signedness
dbdimp.c:1009: warning: pointer targets in passing argument 6 of 'SQLC
+onnect' differ in signedness
dbdimp.c: In function 'dbd_error2':
dbdimp.c:1238: warning: pointer targets in passing argument 2 of 'Perl
+_newSVpv' differ in signedness
dbdimp.c:1239: warning: pointer targets in passing argument 2 of 'Perl
+_newSVpv' differ in signedness
dbdimp.c:1260: warning: pointer targets in passing argument 1 of '__bu
+iltin___strcat_chk' differ in signedness
dbdimp.c:1260: warning: pointer targets in passing argument 1 of '__st
+rcat_ichk' differ in signedness
dbdimp.c:1261: warning: pointer targets in passing argument 1 of '__bu
+iltin___strcat_chk' differ in signedness
dbdimp.c:1261: warning: pointer targets in passing argument 2 of '__bu
+iltin___strcat_chk' differ in signedness
dbdimp.c:1261: warning: pointer targets in passing argument 1 of '__st
+rcat_ichk' differ in signedness
dbdimp.c:1261: warning: pointer targets in passing argument 2 of '__st
+rcat_ichk' differ in signedness
dbdimp.c:1262: warning: pointer targets in passing argument 1 of '__bu
+iltin___strcat_chk' differ in signedness
dbdimp.c:1262: warning: pointer targets in passing argument 1 of '__st
+rcat_ichk' differ in signedness
dbdimp.c:1266: warning: pointer targets in passing argument 1 of 'strl
+en' differ in signedness
dbdimp.c:1266: warning: pointer targets in passing argument 1 of '__bu
+iltin_strcmp' differ in signedness
dbdimp.c:1266: warning: pointer targets in passing argument 1 of 'strl
+en' differ in signedness
dbdimp.c:1266: warning: pointer targets in passing argument 1 of '__bu
+iltin_strcmp' differ in signedness
dbdimp.c:1266: warning: pointer targets in passing argument 1 of '__bu
+iltin_strcmp' differ in signedness
dbdimp.c:1266: warning: pointer targets in passing argument 1 of '__bu
+iltin_strcmp' differ in signedness
dbdimp.c:1268: warning: pointer targets in passing argument 1 of '__bu
+iltin___strcat_chk' differ in signedness
dbdimp.c:1268: warning: pointer targets in passing argument 1 of '__st
+rcat_ichk' differ in signedness
dbdimp.c:1272: warning: pointer targets in passing argument 5 of 'imp_
+xxh->com.std.dbistate->set_err_char' differ in signedness
dbdimp.c:1272: warning: pointer targets in passing argument 6 of 'imp_
+xxh->com.std.dbistate->set_err_char' differ in signedness
dbdimp.c:1275: warning: pointer targets in passing argument 5 of 'imp_
+xxh->com.std.dbistate->set_err_char' differ in signedness
dbdimp.c:1275: warning: pointer targets in passing argument 6 of 'imp_
+xxh->com.std.dbistate->set_err_char' differ in signedness
dbdimp.c: In function 'dbd_preparse':
dbdimp.c:1385: warning: unused variable 'param'
dbdimp.c: In function 'odbc_st_tables':
dbdimp.c:1575: warning: pointer targets in passing argument 2 of 'SQLT
+ables' differ in signedness
dbdimp.c:1575: warning: pointer targets in passing argument 4 of 'SQLT
+ables' differ in signedness
dbdimp.c:1575: warning: pointer targets in passing argument 6 of 'SQLT
+ables' differ in signedness
dbdimp.c:1575: warning: pointer targets in passing argument 8 of 'SQLT
+ables' differ in signedness
dbdimp.c: In function 'odbc_st_primary_keys':
dbdimp.c:1637: warning: pointer targets in passing argument 2 of 'SQLP
+rimaryKeys' differ in signedness
dbdimp.c:1637: warning: pointer targets in passing argument 4 of 'SQLP
+rimaryKeys' differ in signedness
dbdimp.c:1637: warning: pointer targets in passing argument 6 of 'SQLP
+rimaryKeys' differ in signedness
dbdimp.c: In function 'dbd_st_statistics':
dbdimp.c:1711: warning: pointer targets in passing argument 2 of 'SQLS
+tatistics' differ in signedness
dbdimp.c:1711: warning: pointer targets in passing argument 4 of 'SQLS
+tatistics' differ in signedness
dbdimp.c:1711: warning: pointer targets in passing argument 6 of 'SQLS
+tatistics' differ in signedness
dbdimp.c: In function 'odbc_st_prepare_sv':
dbdimp.c:1881: warning: pointer targets in passing argument 2 of 'SQLP
+repare' differ in signedness
dbdimp.c: In function 'odbc_st_execute':
dbdimp.c:2539: warning: pointer targets in passing argument 2 of 'SQLE
+xecDirect' differ in signedness
dbdimp.c:2592: warning: pointer targets in assignment differ in signed
+ness
dbdimp.c: In function 'rebind_param':
dbdimp.c:3491: warning: pointer targets in assignment differ in signed
+ness
dbdimp.c:3497: warning: pointer targets in assignment differ in signed
+ness
dbdimp.c:3667: warning: suggest parentheses around && within ||
dbdimp.c: In function 'odbc_db_STORE_attrib':
dbdimp.c:4088: warning: unused variable 'imp_drh'
dbdimp.c: In function 'odbc_db_FETCH_attrib':
dbdimp.c:4349: warning: unused variable 'imp_drh'
dbdimp.c: In function 'odbc_st_FETCH_attrib':
dbdimp.c:4639: warning: pointer targets in passing argument 2 of 'Perl
+_newSVpv' differ in signedness
dbdimp.c:4683: warning: pointer targets in passing argument 2 of 'SQLG
+etCursorName' differ in signedness
dbdimp.c: In function 'odbc_st_STORE_attrib':
dbdimp.c:4806: warning: unused variable 'value'
dbdimp.c:4802: warning: unused variable 'imp_dbh'
dbdimp.c: In function 'odbc_get_special_columns':
dbdimp.c:5037: warning: pointer targets in passing argument 3 of 'SQLS
+pecialColumns' differ in signedness
dbdimp.c:5037: warning: pointer targets in passing argument 5 of 'SQLS
+pecialColumns' differ in signedness
dbdimp.c:5037: warning: pointer targets in passing argument 7 of 'SQLS
+pecialColumns' differ in signedness
dbdimp.c: In function 'odbc_get_foreign_keys':
dbdimp.c:5102: warning: pointer targets in passing argument 2 of 'SQLF
+oreignKeys' differ in signedness
dbdimp.c:5102: warning: pointer targets in passing argument 4 of 'SQLF
+oreignKeys' differ in signedness
dbdimp.c:5102: warning: pointer targets in passing argument 6 of 'SQLF
+oreignKeys' differ in signedness
dbdimp.c:5102: warning: pointer targets in passing argument 8 of 'SQLF
+oreignKeys' differ in signedness
dbdimp.c:5102: warning: pointer targets in passing argument 10 of 'SQL
+ForeignKeys' differ in signedness
dbdimp.c:5102: warning: pointer targets in passing argument 12 of 'SQL
+ForeignKeys' differ in signedness
dbdimp.c: In function 'odbc_describe_col':
dbdimp.c:5129: warning: pointer targets in passing argument 3 of 'SQLD
+escribeCol' differ in signedness
dbdimp.c: In function 'odbc_col_attributes':
dbdimp.c:5389: warning: pointer targets in passing argument 1 of 'strl
+en' differ in signedness
dbdimp.c:5389: warning: pointer targets in passing argument 2 of 'Perl
+_newSVpv' differ in signedness
dbdimp.c: In function 'odbc_db_columns':
dbdimp.c:5473: warning: pointer targets in passing argument 2 of 'SQLC
+olumns' differ in signedness
dbdimp.c:5473: warning: pointer targets in passing argument 4 of 'SQLC
+olumns' differ in signedness
dbdimp.c:5473: warning: pointer targets in passing argument 6 of 'SQLC
+olumns' differ in signedness
dbdimp.c:5473: warning: pointer targets in passing argument 8 of 'SQLC
+olumns' differ in signedness
dbdimp.c: At top level:
dbdimp.c:1989: warning: 'S_SqlCTypeToString' defined but not used
dbdimp.c: In function 'odbc_st_lob_read':
dbdimp.c:5222: warning: 'retlen' may be used uninitialized in this fun
+ction
gcc -c   -I. -I/opt/teradata/client/13.0/odbc_64/include -I/etldata_da
+idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult
+i/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wde
+claration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D
+_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FO
+RTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size
+=4 -m64 -mtune=generic   -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fP
+IC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE"   unicod
+e_helper.c
Running Mkbootstrap for DBD::ODBC ()
chmod 644 ODBC.bs
rm -f blib/arch/auto/DBD/ODBC/ODBC.so
LD_RUN_PATH="/opt/teradata/client/13.0/odbc_64/lib" gcc  -shared -O2 -
+g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector 
+--param=ssp-buffer-size=4 -m64 -mtune=generic ConvertUTF.o ODBC.o dbd
+imp.o unicode_helper.o  -o blib/arch/auto/DBD/ODBC/ODBC.so      \
           -L/opt/teradata/client/13.0/odbc_64/lib -R/opt/teradata/cli
+ent/13.0/odbc_64/lib -lodbc       \

gcc: unrecognized option '-R/opt/teradata/client/13.0/odbc_64/lib'
chmod 755 blib/arch/auto/DBD/ODBC/ODBC.so
cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs
chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs
Manifying blib/man3/DBD::ODBC.3pm

        [download]
        delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_h
+arness(0, 'blib/lib', 'blib/arch')" t/*.t
t/01base................ok
t/02simple..............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 3-65
        Failed 63/65 tests, 3.08% okay
t/03dbatt...............dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 3-29
        Failed 27/29 tests, 6.90% okay
t/05meth................ok 1/13make: *** [test_dynamic] Interrupt
delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> export DBI_TRACE=15=x.log
delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> prove -vb t/02simple.t
t/02simple....1..65
0x2a00 DBI::db::get_info
0x10000 DBI::db::take_imp_data
0x10c00 DBI::db::disconnect
0x2000 DBI::db::selectrow_array
0x2200 DBI::db::tables
0x0430 DBI::db::quote_identifier
0x0000 DBI::db::clone
0x0430 DBI::db::quote
0x2200 DBI::db::type_info
0xaa00 DBI::db::statistics_info
0x2000 DBI::db::selectrow_arrayref
0x0400 DBI::db::begin_work
0x2800 DBI::db::last_insert_id
0xaa00 DBI::db::foreign_key_info
0x2200 DBI::db::primary_key
0x0c80 DBI::db::commit
0x0404 DBI::db::ping
0x2000 DBI::db::selectall_arrayref
0x2a00 DBI::db::type_info_all
0x3200 DBI::db::do
0x2000 DBI::db::selectcol_arrayref
0xa200 DBI::db::prepare_cached
0x0004 DBI::db::rows
0x0c80 DBI::db::rollback
0xaa00 DBI::db::column_info
0xaa00 DBI::db::table_info
0xaa00 DBI::db::primary_key_info
0xa200 DBI::db::prepare
0x0000 DBI::db::preparse
0x0004 DBI::db::connected
0x0200 DBI::db::data_sources
0x2000 DBI::db::selectall_hashref
0x2000 DBI::db::selectrow_hashref
0x0000 DBI::dr::default_user
0x0800 DBI::dr::data_sources
0x0004 DBI::dr::dbixs_revision
0x0800 DBI::dr::disconnect_all
0x8000 DBI::dr::connect_cached
0x8000 DBI::dr::connect
0x0000 DBI::st::more_results
0x0000 DBI::st::blob_read
0x0000 DBI::st::fetchall_hashref
0x0000 DBI::st::bind_param_inout_array
0x0000 DBI::st::finish
0x0004 DBI::st::rows
0x5040 DBI::st::execute_for_fetch
0x0000 DBI::st::fetchrow_hashref
0x0000 DBI::st::_get_fbav
0x0000 DBI::st::_set_fbav
0x0000 DBI::st::fetchrow
0x0000 DBI::st::fetch
0x5040 DBI::st::execute_array
0x0000 DBI::st::dump_results
0x0000 DBI::st::bind_param_array
0x0000 DBI::st::fetchrow_array
0x1040 DBI::st::execute
0x0000 DBI::st::bind_col
0x0000 DBI::st::fetchall_arrayref
0x0000 DBI::st::fetchrow_arrayref
0x0000 DBI::st::bind_param_inout
0x0000 DBI::st::bind_columns
0x0800 DBI::st::cancel
0x0000 DBI::st::blob_copy_to_file
0x0000 DBI::st::bind_param
0x0404 DBI::common::parse_trace_flag
0x0004 DBI::common::errstr
0x0004 DBI::common::trace_msg
0x0004 DBI::common::err
0x0004 DBI::common::CLEAR
0x0004 DBI::common::state
0x0000 DBI::common::_not_impl
0x0004 DBI::common::NEXTKEY
0x0004 DBI::common::trace
0x0004 DBI::common::debug
0x0404 DBI::common::parse_trace_flags
0x0000 DBI::common::private_attribute_info
0x0000 DBI::common::swap_inner_handle
0x0004 DBI::common::EXISTS
0x0404 DBI::common::visit_child_handles
0x0404 DBI::common::FETCH
0x0004 DBI::common::FIRSTKEY
0x0010 DBI::common::set_err
0x10004 DBI::common::DESTROY
0x0004 DBI::common::dump_handle
0x0404 DBI::common::FETCH_many
0x0100 DBI::common::can
0x041c DBI::common::STORE
0x0004 DBI::common::private_data
0x0006 DBI::common::func
ok 1 - use DBI;
ok 2 - use ODBCTEST;
dubious
        Test returned status 0 (wstat 11, 0xb)
DIED. FAILED tests 3-65
        Failed 63/65 tests, 3.08% okay
Failed Test  Stat Wstat Total Fail  Failed  List of Failed
----------------------------------------------------------------------
+---------
t/02simple.t    0    11    65  126 193.85%  3-65
Failed 1/1 test scripts, 0.00% okay. 63/65 subtests failed, 3.08% okay
+.
delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> prove -vb t/05meth.t
t/05meth....1..13
0x2a00 DBI::db::get_info
0x10000 DBI::db::take_imp_data
0x10c00 DBI::db::disconnect
0x2000 DBI::db::selectrow_array
0x2200 DBI::db::tables
0x0430 DBI::db::quote_identifier
0x0000 DBI::db::clone
0x0430 DBI::db::quote
0x2200 DBI::db::type_info
0xaa00 DBI::db::statistics_info
0x2000 DBI::db::selectrow_arrayref
0x0400 DBI::db::begin_work
0x2800 DBI::db::last_insert_id
0xaa00 DBI::db::foreign_key_info
0x2200 DBI::db::primary_key
0x0c80 DBI::db::commit
0x0404 DBI::db::ping
0x2000 DBI::db::selectall_arrayref
0x2a00 DBI::db::type_info_all
0x3200 DBI::db::do
0x2000 DBI::db::selectcol_arrayref
0xa200 DBI::db::prepare_cached
0x0004 DBI::db::rows
0x0c80 DBI::db::rollback
0xaa00 DBI::db::column_info
0xaa00 DBI::db::table_info
0xaa00 DBI::db::primary_key_info
0xa200 DBI::db::prepare
0x0000 DBI::db::preparse
0x0004 DBI::db::connected
0x0200 DBI::db::data_sources
0x2000 DBI::db::selectall_hashref
0x2000 DBI::db::selectrow_hashref
0x0000 DBI::dr::default_user
0x0800 DBI::dr::data_sources
0x0004 DBI::dr::dbixs_revision
0x0800 DBI::dr::disconnect_all
0x8000 DBI::dr::connect_cached
0x8000 DBI::dr::connect
0x0000 DBI::st::more_results
0x0000 DBI::st::blob_read
0x0000 DBI::st::fetchall_hashref
0x0000 DBI::st::bind_param_inout_array
0x0000 DBI::st::finish
0x0004 DBI::st::rows
0x5040 DBI::st::execute_for_fetch
0x0000 DBI::st::fetchrow_hashref
0x0000 DBI::st::_get_fbav
0x0000 DBI::st::_set_fbav
0x0000 DBI::st::fetchrow
0x0000 DBI::st::fetch
0x5040 DBI::st::execute_array
0x0000 DBI::st::dump_results
0x0000 DBI::st::bind_param_array
0x0000 DBI::st::fetchrow_array
0x1040 DBI::st::execute
0x0000 DBI::st::bind_col
0x0000 DBI::st::fetchall_arrayref
0x0000 DBI::st::fetchrow_arrayref
0x0000 DBI::st::bind_param_inout
0x0000 DBI::st::bind_columns
0x0800 DBI::st::cancel
0x0000 DBI::st::blob_copy_to_file
0x0000 DBI::st::bind_param
0x0404 DBI::common::parse_trace_flag
0x0004 DBI::common::errstr
0x0004 DBI::common::trace_msg
0x0004 DBI::common::err
0x0004 DBI::common::CLEAR
0x0004 DBI::common::state
0x0000 DBI::common::_not_impl
0x0004 DBI::common::NEXTKEY
0x0004 DBI::common::trace
0x0004 DBI::common::debug
0x0404 DBI::common::parse_trace_flags
0x0000 DBI::common::private_attribute_info
0x0000 DBI::common::swap_inner_handle
0x0004 DBI::common::EXISTS
0x0404 DBI::common::visit_child_handles
0x0404 DBI::common::FETCH
0x0004 DBI::common::FIRSTKEY
0x0010 DBI::common::set_err
0x10004 DBI::common::DESTROY
0x0004 DBI::common::dump_handle
0x0404 DBI::common::FETCH_many
0x0100 DBI::common::can
0x041c DBI::common::STORE
0x0004 DBI::common::private_data
0x0006 DBI::common::func
ok 1 - use DBI;

        [download]
[reply]
[d/l]
[select]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://871061]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others examining the Monastery: (4)
As of 2024-04-25 10:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found