I made the changes you suggested and got a little more output, but I'm not sure what this telling me... except is this showing a failure before trying to set autocommit, possibly on a dead connection?

delli28@apsa9012:/u/delli28> test.pl
    DBI 1.615-ithread default trace level set to 0x6000000/15 (pid 888
+884 pi 20009e68) at test.pl line 8
    -> DBI->connect(dbi:ODBC:nhitest, delli28, ****, HASH(0x2000ab38))
    -> DBI->install_driver(ODBC) for aix perl=5.008008 pid=888884 ruid
+=43679 euid=43679
       install_driver: DBD::ODBC version 1.25 loaded from /u/delli28/l
+ib/site_perl/5.8.8/aix-thread-multi/DBD/ODBC.pm
    New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef)
    dbih_setup_handle(DBI::dr=HASH(0x2052e7d4)=>DBI::dr=HASH(0x2052d27
+c), DBD::ODBC::dr, 0, Null!)
    dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#20009e68
    dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), Err, Null!) SCALAR(0x2
+0411574) (already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), State, Null!) SCALAR(0
+x204115bc) (already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), Errstr, Null!) SCALAR(
+0x20411598) (already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), TraceLevel, Null!) 0 (
+already defined)
    dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), FetchHashKeyName, Null
+!) 'NAME' (already defined)
install_method DBI::st::odbc_lob_read
    <- install_driver= DBI::dr=HASH(0x2052e7d4)
    >> connect     DISPATCH (DBI::dr=HASH(0x2052e7d4) rc2/3 @5 g0 ima8
+001 pid#888884) at /u/delli28/lib/site_perl/5.8.8/aix-thread-multi/DB
+I.pm line 665
    !! warn: 0 CLEARED by call to connect method
    -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x2052e7d4)~0x2052d27c 
+'nhitest' 'delli28' **** HASH(0x2025d028)) thr#20009e68
    New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x2052d27c),
+ id=undef)
    dbih_setup_handle(DBI::db=HASH(0x2052ebdc)=>DBI::db=HASH(0x2052eb4
+0), DBD::ODBC::db, 204a3608, Null!)
    dbih_make_com(DBI::dr=HASH(0x2052d27c), 205342f8, DBD::ODBC::db, 4
+48, 0) thr#20009e68
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Err, DBI::dr=HASH(0x20
+52d27c)) SCALAR(0x204a3794) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), State, DBI::dr=HASH(0x
+2052d27c)) SCALAR(0x204a37f4) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Errstr, DBI::dr=HASH(0
+x2052d27c)) SCALAR(0x204a37c4) (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), TraceLevel, DBI::dr=HA
+SH(0x2052d27c)) 0 (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), FetchHashKeyName, DBI:
+:dr=HASH(0x2052d27c)) 'NAME' (already defined)
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), HandleSetErr, DBI::dr=
+HASH(0x2052d27c)) undef (not defined)
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), HandleError, DBI::dr=H
+ASH(0x2052d27c)) undef (not defined)
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), ReadOnly, DBI::dr=HASH
+(0x2052d27c)) undef (not defined)
    dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Profile, DBI::dr=HASH(
+0x2052d27c)) undef (not defined)
non-Unicode login6
dbd_db_login6
    !!dbd_error2(err_rc=0, what=db_login/SQLAllocHandle(env), handles=
+(0,0,0)
    SQLDriverConnect 'nhitest', 'delli28', 'xxxx'
    SQLDriverConnect failed:
    SQLConnect 'nhitest', 'delli28'
Turning autocommit on
Illegal instruction
delli28@apsa9012:/u/delli28>

[download]

In reply to Re^4: DBD::ODBC to Teradata by DanEllison
in thread DBD::ODBC to Teradata by DanEllison

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.